本文介绍如何在网页开发中将GridView和DropDownList控件结合起来使用,实现数据筛选、排序等功能,提高用户体验。适合初学者参考学习。
namespace Exercise1.DepMng
{
public partial class UserM2 : System.Web.UI.Page
{
Helper he = new Helper();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Bind();
}
}
public void Bind()
{
string user_sql = select * from User;
DataSet ds = he.GetDataSet(user_sql, User);
GridView1.DataSource = ds;
GridView1.DataKeyNames = new string[] { UserID };
GridView1.DataBind();
//设置 DropDownList 默认值
for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
{
DataRowView mydrv = ds.Tables[0].DefaultView[i];
DropDownList ddlDepList = (DropDownList)GridView1.Rows[i].FindControl(depList);
ddlDepList.SelectedValue = ds.Tables[0].Rows[i][DepId].ToString();
DropDownList ddlRoleList = (DropDownList)GridView1.Rows[i].FindControl(roleList);
ddlRoleList.SelectedValue = ds.Tables[0].Rows[i][RId].ToString();
}
}
public DataSet DdlBind()
{
string sql = select * from Department;
DataSet ds = he.GetDataSet(sql, Department);
return ds;
}
}
}