下拉列表为动态读取数据 下拉列表ID 是 HH
SqlConnection1 = new SqlConnection(ConfigurationSettings.AppSettings["Conn"]);
SqlDataAdapter1 = new SqlDataAdapter();
SqlDataAdapter1.SelectCommand=new SqlCommand("abc",SqlConnection1);
SqlDataAdapter1.SelectCommand.CommandType=CommandType.StoredProcedure ;
DataSet1=new DataSet();
try
{
SqlDataAdapter1.Fill(DataSet1,"表名");
}
catch
{
Response.Write("<script>alert('数据库操作错误!');</script>");
}
AuthorityList.DataSource=DataSet1.Tables["字段名"].DefaultView;
HH.DataTextField="字段名";
HH.DataValueField="字段名";
HH.DataBind();
SqlConnection1.Close();SqlCommand1.Parameters.Add(new SqlParameter("@AA",SqlDbType.NVarChar,500));
SqlCommand1.Parameters["@AA"].Value =HH.SelectedValue.Trim();不管选第几个值, 每次添加进表里的值都是下拉列表里第一个值
应该是HH.SelectedValue.Trim(); 这段代码有问题 请高手指点
SqlConnection1 = new SqlConnection(ConfigurationSettings.AppSettings["Conn"]);
SqlDataAdapter1 = new SqlDataAdapter();
SqlDataAdapter1.SelectCommand=new SqlCommand("abc",SqlConnection1);
SqlDataAdapter1.SelectCommand.CommandType=CommandType.StoredProcedure ;
DataSet1=new DataSet();
try
{
SqlDataAdapter1.Fill(DataSet1,"表名");
}
catch
{
Response.Write("<script>alert('数据库操作错误!');</script>");
}
AuthorityList.DataSource=DataSet1.Tables["字段名"].DefaultView;
HH.DataTextField="字段名";
HH.DataValueField="字段名";
HH.DataBind();
SqlConnection1.Close();SqlCommand1.Parameters.Add(new SqlParameter("@AA",SqlDbType.NVarChar,500));
SqlCommand1.Parameters["@AA"].Value =HH.SelectedValue.Trim();不管选第几个值, 每次添加进表里的值都是下拉列表里第一个值
应该是HH.SelectedValue.Trim(); 这段代码有问题 请高手指点
绑定下拉列表的方法一般放在if(!IsPostBack){}里面;
以防提交时重新加载绑定下拉列表的方法!
{
//写你的绑定函数
}