在asp.net中的赋值给DropDownList
询问一下,如何将数据库中取出的值赋给DropDownList
我的代码如下,希望高手赐教
string ds=ConfigurationSettings.AppSettings["System_manage"]; SqlConnection myConnection=new SqlConnection(ds);
SqlCommand SelectCommand;
SelectCommand=new SqlCommand("select * from ProjectDetailedTable where id=@id");
SelectCommand.Connection=myConnection;
SelectCommand.Parameters.Add(new SqlParameter("@id",SqlDbType.Int,4));
myConnection.Open();
SelectCommand.Parameters["@id"].Value=Session["uid"].ToString();
SqlDataReader myred=SelectCommand.ExecuteReader();
myred.Read();
txtid.Text=SelectCommand.Parameters["@id"].Value.ToString();
DropDownList1.SelectedValue.ToString()=myred["type"].toString();