快速查询出数据并且快速的将数据绑定在数据控件上，如GridView

Sqlconnection conn = new SqlConnection(strcon);

conn.Open();

SqlDataAdapter ada = new SqlDataAdapter(“select * from Users”,conn);

DataSet ds = new DatSet();

ada.Fill(ds,”Users”);

GridView1.DataSource = ds.Table[“Users”];

GrdView1.DataKeyNames = new string[] {“userid”};

GrdView1.DataBand();

conn.Close();

转载于:https://www.cnblogs.com/hc10/p/3371007.html