Error updating table in data grid view in c#

thanks for replay...but any other method we can update some colum(A.stdwt,A.netwt,A.grosswt) datagrid view rows in following code.
namespace AddEditDeleteDataGridView
{
  public partial class Form5 : Form
  {
  string con = "Data Source=ITSW2;Initial Catalog=Export;Integrated Security=True";
 
  private SqlConnection connection;
  private SqlCommand command;
  private SqlDataAdapter adapter;
  private SqlCommandBuilder builder;
  private DataSet ds;
  private BindingSource bindingSource;
  private DataTable userTable;
 
 
  public Form5()
  {
  InitializeComponent();
  }

  private void btnload_Click(object sender, EventArgs e)
  {


  //string query = "select * from boxpacking";
  string query = "select A.partno, A.BoxNo,A.partdesc,A.partypartno,A.boxqty,A.stdwt,A.netwt,A.grosswt from BoxPacking A join Packing B  on A.DespLotId=B.DespLotId where B.PackingId=1525";
  connection = new SqlConnection(con);
  connection.Open();
  command = new SqlCommand(query, connection);
  adapter = new SqlDataAdapter(command);
  builder = new SqlCommandBuilder(adapter);
  //ds = new DataSet();
  //adapter.Fill(ds, "boxpacking");
  userTable = new DataTable();
  adapter.Fill(userTable);

  //userTable = ds.Tables["boxpacking"];
  connection.Close();
  bindingSource = new BindingSource();
  bindingSource.DataSource = userTable;

  dataGridView1.DataSource = bindingSource;
  //connection.Close();
  //dataGridView1.DataSource = userTable;
  dataGridView1.ReadOnly = true;
  dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;

  edit.Enabled = true;
  btnupdate.Enabled = true;
 
 
  }

 

  private void btnupdate_Click(object sender, EventArgs e)
  {
  try
  {
  //connection.Open();
  adapter.Update(userTable);
  dataGridView1.ReadOnly = true;
  }
  catch (Exception ex)
  {
  MessageBox.Show(ex.ToString());
  btnupdate.Enabled = true;
  }
  finally
  {
  edit.Enabled = true;
  btnload.Enabled = true;
  connection.Close();
  }
  }

  private void edit_Click(object sender, EventArgs e)
  {
  try
  {
  dataGridView1.ReadOnly = false;
  edit.Enabled = false;
  btnupdate.Enabled = true;
  }
  catch (Exception ex)
  {
  MessageBox.Show(ex.ToString());
  }


  }

sorry bothering again..its work fine but here updating in one table I also update in second tabl.I m using bt error show.my query is ...
update a set a.username='mohit' b.location ='delhi' from UserInformation a inner join location b on a.UserID=b.LocationId where b.LocationId=3

thanks shankar...but I am not geting. it is my query.how to update this.

selectA.partno,A.BoxNo,A.partdesc,A.partypartno,A.boxqty,A.stdwt,A.netwt,A.grosswt from BoxPacking A join Packing B on A.DespLotId=B.DespLotId where B.PackingId=1525

Hi Mohit, You can do multiple row update using Joins. Something like this,

UPDATE

E SET E.COMM = E.COMM * 20

FROM

EMP E INNER JOIN EMP T

ON

E.EMPNO = T.EMPNO;

 Thanks, Shankar M

thanks shankr...but I want multiple row update in data gridview and data fetch from database using sql join query.but question is that how to update sql joining query.

Hi Mohit,

Where is your update statement to update the Table ?

Please find the below sample.
 
Thanks, Shankar