我这句话应放在哪??来者有分!!!
这是一个查询,把查出的结果放到 DrDlei,DrXlei这两个dropdownlist控件里
选择DrDlei里的一个大类名 DrXlei里的小类会跟着变. 我想一点确定按扭然后把 DXlei里查出来的小类的id 插入数据库中!!
这两句话应放在哪呀?
drXlei.DataTextField="xname";
drXlei.DataValueField="id";
string sqlstring="select * from bk_lei";
conn.Open();
DataSet ds=new DataSet();
SqlCommand comm=new SqlCommand(sqlstring,conn);
drDlei.DataTextField="lname";
SqlDataReader dr=comm.ExecuteReader();
while(dr.Read())
drDlei.Items.Add(dr["lname"].ToString());
dr.Close();
string sqlstring2="select * from bk_xlei where id=1";
DataSet ds1=new DataSet();
SqlCommand comm1=new SqlCommand(sqlstring2,conn);
SqlDataReader dr2=comm1.ExecuteReader();
while(dr2.Read())
drXlei.Items.Add(dr2["xname"].ToString());
conn.Close();
drDlei的事件
private void drDlei_SelectedIndexChanged(object sender, System.EventArgs e)
{
SqlConnection connd=new SqlConnection(ConfigurationSettings.AppSettings["conn"]);
string sqlstring="select * from bk_lei";
connd.Open();
DataSet ds=new DataSet();
SqlCommand comm=new SqlCommand(sqlstring,connd);
SqlDataReader dr=comm.ExecuteReader();
string ssid;
dr.Close();
string cname;
cname=drDlei.SelectedValue.ToString();
if(cname=="--请选择--")
{
Response.Write("<script>alert(\"请选择大类中的项\")</script>");
return;
}
string sqlstring2="select id from bk_lei where lname='"+cname+"'";
SqlDataAdapter sda=new SqlDataAdapter(sqlstring2,connd);
sda.Fill(ds);
ssid=ds.Tables[0].Rows[0]["id"].ToString();
string sqlstring1="select * from bk_xlei where id='"+ssid+"'";
SqlCommand comm1=new SqlCommand(sqlstring1,connd);
SqlDataReader dr1=comm1.ExecuteReader();
drXlei.Items.Clear();
while(dr1.Read())
drXlei.Items.Add(dr1["xname"].ToString());
}
这是插入方法
string sql="insert into bk_zheng (id)values(@id)";
SqlCommand cmd=new SqlCommand(sql,conn);
cmd.Parameters.Add(new SqlParameter("@id",SqlDbType.Int,20));
cmd.Parameters["@id"].Value=drXlei.SelectedItem.Value;
try
{
conn.Open();
int i=cmd.ExecuteNonQuery();
conn.Close();
if(i>0)
{
Response.Write("<script>alert(\"添加成功!!!\")</script>");
}
}
catch(Exception ex )
{
Response.Write(ex.Message);
}