title: C# asp.net SQL how to add new value to database by dropdownlist?
body: <p>the code below is my example of code how to connect and add by textbox what i want now is how to add with dropdownlist... code sample how to add by dropdownlist someone please???</p>
  
  <pre><code>public partial class SQL_Test : System.Web.UI.Page
      {
          SqlConnection myConnection;
          DataSet dataSet;
          string sql;
          SqlDataAdapter dataAdapter;
          protected void Page_Load(object sender, EventArgs e)
          {
              myConnection = new SqlConnection("trusted_connection=yes;" + "database=DataBaseConnection;" + "connection timeout=30;");
              dataSet = new DataSet();
              sql = "SELECT Firstname,Surname FROM BasicInfo";
              dataAdapter = new SqlDataAdapter(sql, myConnection);
              //fill dataset
              dataAdapter.Fill(dataSet, "datafill");
  
              //bind database to gridviwe
              GridView1.DataSource = dataSet;
              GridView1.DataBind();
          }
          protected void Button1_Click(object sender, EventArgs e)
          {
              myConnection.Open();
              SqlCommand AddCommand = new SqlCommand("INSERT INTO BasicInfo (Firstname,Surname) values(@a,@b)", myConnection);
  
              if (TextBox1.Text != null &amp;&amp; TextBox2.Text != null)
              {
                  //TextBox set Parameters
                  AddCommand.Parameters.AddWithValue("@a", TextBox1.Text);
                  AddCommand.Parameters.AddWithValue("@b", TextBox2.Text);
  
                  //Execute Query
                  AddCommand.ExecuteNonQuery();
  
                  //emptied textbox's
                  TextBox1.Text = "";
                  TextBox1.Text = "";
  
                  //Redirect
                  Response.Redirect("SQL-Test.aspx");
              }
  
              //close connection
              myConnection.Close();
          }
  </code></pre>