title: why we going for sqlcommandbuilder?
body: <p>Option 1: to insert data in a db</p>
  
  <pre><code>SqlCommand cmd = new SqlCommand("INSERT INTO table_name(eid,eName,Dept) values('"+ textBox1.Text +"','"+ textBox2.Text +"','"+ Textbox3.Text +"'", con);
  
  cmd.ExecuteNonQuery();
  </code></pre>
  
  <p>Option 2: </p>
  
  <pre><code>SqlDataAdapter sqlda = new SqlDataAdapter("SELECT * FROM table_name",con);
  
  SqlCommandBuilder sqlcomb = new SqlCommandBuilder(sqlda);
  
  DataSet dset = new DataSet("table1");
  
  sqlda.Fill(dset,"table1");
  
  DataRow drow = dset.Tables["table1"].NewRow();
  drow["eid"] = textBox1.Text.ToString();
  drow["eName"] = textBox2.Text.ToString();
  drow["Dept"] = textBox3.Text.ToString();
  
  dset.Tables["table1"].Rows.Add(drow);
  
  sqlda.Update(dset, "table1");
  </code></pre>
  
  <p>My question is, I feel like option1 is best method to insert.. why we using <code>SqlCommandBuilder</code> to insert data? What is the use of SqlCommandBuilder? Any advantages in inserting the data using <code>SqlCommandBuilder</code>? your suggestion plz</p>