update unable to find tablemapping 'table' or datatable 'table'.

Question

Right so the title of the thread is my error (update unable to find tablemapping 'table' or datatable 'table'.). Basically I am trying to update my view when the data grid view cell is changed. This is attempted with the below code -

Code:

   private void dgvUQ_CellValueChanged(object sender, DataGridViewCellEventArgs e)         {             dc.GainConnection(" ", dgvUQ, "v_stafftrainingDetails");                      }

the gain connection method is called everytime I filter data for example searching first name with text box. However I have added dataAdapter.Update() in this method to see if it will do it but im getting the above error. the gain connection code is below

Code:

public void GainConnection(string command, DataGridView dgv, string strTable)         {             SqlCommand com1 = new SqlCommand();             string conStr;             conStr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\NTO.mdf;Integrated Security=True;User Instance=True";            SqlConnection connection = new SqlConnection(conStr);             connection.Open();             com1.Connection = connection;             com1.CommandType = CommandType.Text;             com1.CommandText = command;             DataSet ds = new DataSet();            SqlDataAdapter sqlAdp = new SqlDataAdapter(com1);            sqlAdp.Fill(ds);             sqlAdp.Update(ds);             dgv.DataSource = ds;             dgv.DataMember = strTable;             connection.Close();          }

Thanks for help

Sam Hobbs · Answer

You probably would get help in the other forums too if you provided more information. I suggest looking at some of the relevant articles in this web site. There are very many that can help you. I do not have enough information to know what else to suggest.

Luke Baker · Answer

It is the sqlAdp.Update(ds) which is erroring. Command is the parameter from where the function is called im not fussed about using this function to update the data in the table. Its just trying to update it when a cell has been changed but because the data has initilly been loaded using this gainConnection() method is proving difficult. By the way cheers for you help your the only one to reply out of 4 forums thanks alot. Do you think there is another way to update the edited data?

Sam Hobbs · Answer

You have nothing between sqlAdp.Fill(ds); and sqlAdp.Update(ds); so there is nothing to be done. I do not think however that that is causing the error but it would just do nothing. It will help to know what source code line is getting the error. Also you are calling sqlAdp.Fill(ds) and sqlAdp is created with com1 and com1.CommandText = command. You do not show what is in the command parameter. What is in the command parameter?

Luke Baker · Answer

Yer im trying to update the data in the database i know when using a data adapter you can just do dataAdapter.update() but because of putting the gainConnection method in a different class it is proving difficult

Sam Hobbs · Answer

What do you mean by update? Do you mean you are tryign to refresh the data in the form or are you trying to change the data in the datgabase? I don't see any SQL in your code. If the error is complaining about the SQL then the SQL is the most important data to show.