核心提示:string connStr = 'Server = 192.168.*.*;' + 'Database = 数据库名;' + 'User ID = 用户名;' + 'Password = 密码;';...
string connStr =
"Server = 192.168.*.*;" +
"Database = 数据库名;" +
"User ID = 用户名;" +
"Password = 密码;";
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
string sql = "select * from 数据表名 order by id desc";//定义执行查询操作的SQL语句
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataKeyNames = new string[] { "id" };
GridView1.DataBind(); //绑定数据库表中数据