title: How to insert Records in Database using C# language?
body: <p>I am just a begginer on C# so i need too much help. Now the problem is that i have designed a windows form in which there are many fields like first name, last name, address etc. Now i want to do is that when i fill the form and click insert button all the information goes into database. Does anyone know how to do that?</p>
  
  <pre><code>private void button1_Click(object sender, System.EventArgs e)
  {
      string connetionString = null;
      SqlConnection cnn ;
      SqlDataAdapter adapter = new SqlDataAdapter();
      string sql = null;
      connetionString = "Data Source=UMAIR;Initial Catalog=Air; Trusted_Connection=True;" ;
  
      cnn = new SqlConnection(connetionString);
      sql = "insert into Main (Firt Name, Last Name) values(textbox2.Text,textbox3.Text)";
  
      try
      {
          cnn.Open();
          adapter.InsertCommand = new SqlCommand(sql, cnn);
          adapter.InsertCommand.ExecuteNonQuery();
           MessageBox.Show ("Row inserted !! ");
      }
      catch (Exception ex)
      {
          MessageBox.Show(ex.ToString());
      }
  }
  </code></pre>