title: c# How to insert textbox value and save it to sql database?
body: <p><br>
  How to insert textbox value and save it to sql database?
  I need some help here regarding to the question above. When I clicked button save, it should update the input textbox to the sql database Workers. Could you guys make some coding sample to achieve this? Because what I do is not working at all. This is the coding :</p>
  
  <pre><code>private void btnSave_Click(object sender, EventArgs e) {
  #region SaveButton
              // System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter ();
  
              //System.Data.SqlClient.SqlCommandBuilder cb;
              //cb = new System.Data.SqlClient.SqlCommandBuilder (da);
  
              //add to Dataset a new row
              DataRow dRow = ds1.Tables["Workers"].NewRow();
  
              //add data to the new row just have been created
              //refer to first_Name
              dRow[1] = textBox1.Text;
              dRow[2] = textBox2.Text;
              dRow[3] = textBox3.Text;
  
              //add command
              //add to table worker a new row that declared by row variable name dRow
              ds1.Tables["Workers"].Rows.Add(dRow);
  
              MaxRows = MaxRows + 1; //to enable last row is still last row
              inc = MaxRows - 1;
  
              //call data adapter da to update and save data into database sql server
              //da.Update(ds1, "Workers");
  
              MessageBox.Show("Entry Added!");
  #endregion
              con.ConnectionString = "Data Source=.\\SQLEXPRESS; AttachDbFilename =D:\\MyWorkers.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
  
  
              string strSQL = "INSERT INTO Workers (first_Name, last_Name, job_Title )" + " VALUES ('" + textBox1.Text + "', '" + textBox2.Text + "', " + " '" + textBox3.Text + "') ";
  
  
  
  
  
              con.Close();  
          }
  </code></pre>