如何把LIST里的对象绑定到gridview中?List<Student> sts=new List<Student>();
...
//假设在sts中存有五个学生,Student类有三个属性:id,name,age
GridView1.DataSource=....??
GridView1.DataBind();请问如何把这LIST中的对象绑定到GRIDVIEW中???
...
//假设在sts中存有五个学生,Student类有三个属性:id,name,age
GridView1.DataSource=....??
GridView1.DataBind();请问如何把这LIST中的对象绑定到GRIDVIEW中???
{
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand(safeSql, Connection);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
return ds.Tables[0];
} /// <summary>
/// 查询所有管理员信息
/// </summary>
/// <returns></returns>
public static List<Admin> GetAllAdmin()
{
string sql = "select * from admin"
List<Admin> list = new List<Admin>();
DataTable dt = DBHelper.GetDataSet(sql);
foreach (DataRow row in dt.Rows)
{
Admin admin = new Admin();
admin.id = Convert.ToInt32(row["id"]);
admin.loginname = row["loginName"].ToString();
admin.loginpwd = row["loginPwd"].ToString(); list.Add(admin);
}
return list;
}List<Admin> list=GetAllAdmin();
GridView1.DataSource=list;
GridView1.DataBind();
List<Admin> list=GetAllAdmin();Admin admin = new Admin();foreach(Admin admin in list)
{
DROPDOWNLIST.Item.add(new ListItem(admin.ID,admin.Name));
}
DROPDOWNLIST.DataBind();思路就是这样的!
List<Admin> list=GetAllAdmin();foreach(Admin admin in list)
{
DROPDOWNLIST.Item.add(new ListItem(admin.ID,admin.Name));
}
DROPDOWNLIST.DataBind();
DropDownList1.DataTextField = "要显示在文本中的列名";
DropDownList1.DataValueField = "要保存的值的列名"; DropDownList1.DataSource = RoomManager.GetRooms();//绑定数据
DropDownList1.DataBind(); //不要忘了
获取值的方法DropDownList1.SelectedValue;