更新时间: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();