SqlDataAdapter adapter = new SqlDataAdapter("Select * from Employees", connection); SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(adapter); DataSet ds = new DataSet("Employees"); adapter.Fill(ds, "Employees"); DataRow row = ds.Tables["Employees"].NewRow(); row["empId"] = textBox1.Text; row["empName"] = textBox2.Text; row["empSal"] = textBox3.Text; ds.Tables["Employees"].Rows.Add(row); adapter.Update(ds, "Employees");