Question

DropDownList谁给我个例子

DropDownList绑定数据库里的数据 然后把取出数据的ID 插入另个表里 谢谢帮我写个简单的例子把

Answer 1

using System.Data.SqlClient;
//load事件
//绑定DropDownList1
if (!this.IsPostBack)
{
string strConn,strSelect;
strConn="连接字符串";
strSelect="select aID,b from aa";
SqlDataAdapter sda=new SqlDataAdapter(strSelect,strConn);
DataTable dt=new DataTable();
sda.Fill(dt);
this.DropDownList1.DataSource=dt;
this.DropDownList1.DataTextField="b";//要显示的字段名
this.DropDownList1.DataValueField="aID";//对应值的字段名
this.DropDownList1.DataBind();//绑定DropDownList1
}
//按钮事件
string aID,strInsert,strConn;
strConn="连接字符串";
aID=this.DropDownList1.SelectedValue;
strInsert="insert into 表名 (字段名) values ('"+aID+"')";
SqlConnection conn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand(strInsert,conn);
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch
{
}
finally
{
if(conn.State!=ConnectionState.Closed)
{
conn.Close();
}
}