62,046
社区成员
发帖
与我相关
我的任务
分享
string sql = "select [某列] from [某表]";
DataTable dt = rdtable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
dropdownlist1.Items.Add(new ListItem(dt.Rows[i]["Name"].ToString(), dt.Rows[i]["Id"].ToString()));
}
public static DataTable rdtable(string sql, string strConnection)
{
SqlConnection objConnection = new SqlConnection(strConnection);
SqlDataAdapter objAdapter = new SqlDataAdapter(sql, objConnection);
DataTable objDataTable = new DataTable();
objAdapter.Fill(objDataTable);
objConnection.Close();
return objDataTable;
}
DropDownList1.DataSource = dt;
DropDownList1.DataValueField ="选项值的列名";
DropDownList1.DataTextField = "选项文本显示的列名";
DropDownList1.DataBind();