怎样利用下拉菜单,在数据库中插入数据?
怎样利用下拉菜单,在数据库中插入数据?我做了代码,但是,还差下拉菜单中的数据,无法读入。代码如下,请帮忙修改一下。
protected void Button1_Click(object sender, EventArgs e)
{
try
{
string connStr = ConfigurationManager.ConnectionStrings["schoolConnectionString"].ConnectionString;
SqlConnection Con = new SqlConnection(connStr);
Con.Open();
string InsertSql = "Insert Into Teacher_Pwd(username,name,'" +this.DropDownList1.Text+ "')values('" + username.Text + "','" + name.Text + "','" + pwd.Text + "')";
SqlCommand com = new SqlCommand(InsertSql, Con);
com.ExecuteNonQuery();
SqlDataAdapter ada = new SqlDataAdapter("Select * From Teacher_Pwd where name = '" + username.Text + "'", Con);
DataSet ds = new DataSet();
ada.Fill(ds);
//GridView1.DataSource = ds;
//GridView1.DataBind();
Con.Close();
Response.Write("<script language=javascript>alert('添加成功!')</script>");
}
catch
{
Response.Write("<script language=javascript>alert('添加失败!')</script>");
}
}