读书人

DataGridView 如何绑定数据库显示数据

发布时间: 2013-04-02 12:35:26 作者: rapoo

DataGridView 怎么绑定数据库显示数据库里面某些字段的内容
我不想用自定义的数据源来绑定,想自己写代码?但是不太会,是不是先把数据放到DataTable里面?谢谢大家指教下.
[解决办法]
前台绑定


protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GridViewBind();
}

}

protected void GridViewBind()
{
int flag=1;
if ((string)Session["teachersid"] == "admin")
{
GridView1.DataSource = UsersManager.BllGetAllUsersInfo(flag);
}
else
{
flag = 0;
GridView1.DataSource = UsersManager.BllGetAllUsersInfo(flag);
}
GridView1.DataBind();
}


后台查询

/// <summary>
/// 获取所有用户的信息
/// </summary>
/// <returns></returns>
public static List<UsersModel> GetAllUsersInfo()
{
string sqlstr = "select * from users order by [identity]";
SqlConnection conn = new SqlConnection(connstr);
List<UsersModel> list = new List<UsersModel>();
try
{
using (conn)
{
conn.Open();
SqlCommand cmd = new SqlCommand(sqlstr, conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{


UsersModel newUser = new UsersModel();
newUser.Id = Convert.ToInt32(reader["id"]);
newUser.UserId = Convert.ToString(reader["user_id"]);
newUser.Name = Convert.ToString(reader["name"]);
newUser.Pwd = Convert.ToString(reader["pwd"]);
newUser.Identity = Convert.ToString(reader["identity"]);
list.Add(newUser);
}
}
}
catch (Exception)
{
conn.Close();
conn.Dispose();
}
return list;
}


读书人网 >C#

热点推荐