且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在我的编辑页面....如何在下拉列表中的List之间绑定下拉列表....

更新时间:2023-02-24 21:44:36

这可能对你有所帮助



http://www.daniweb.com/web-development/aspnet/threads/430401/dropdownlist-in-gridview -problem [ ^ ]
This may help you

http://www.daniweb.com/web-development/aspnet/threads/430401/dropdownlist-in-gridview-problem[^]


string sQuery = "SELECT CountryID, CountryName FROM COUNTRY";
DataTable dtData = new DataTable();
SqlConnection oSQLConnection = new SqlConnection("sConString");
SqlCommand cmd = new SqlCommand(sQuery, oSQLConnection);
SqlDataAdapter da = new SqlDataAdapter(cmd);
oSQLConnection.Open();
da.Fill(dtData);
da.Dispose();

DropDownList1.DataSource = dtData;
DropDownList1.DataValueField = "CountryID";
DropDownList1.DataTextField = "CountryName";
DropDownList1.DataBind();