none
Table adapter - Update Method RRS feed

  • Question

  •  

    Hi all;

     

    I created a dataset "myDataSet" and in that dataset I  created "myTableAdapter" with only one table so it created the update methods automatically,

    but for the select command I need the query to be from more than one table (Join) so I went to table adapter properties and I changed the select command to query from the tables which I want

    but the problem is when I am trying to call the update method after deleting a row it gives me the following message:

     

     

    The parameterized query '(@Original_ID int,@Original_Cust nvarchar(4),@IsNull_proj' expects the parameter '@Original_ID', which was not supplied

     

     

    My code for delete is the following:

     

    myDataSet.CustomerRow Customer = myDataSet.Customer.FindByCustID("ExampleCustomerID");

    Customer.Delete();

    myTableAdapter.Update(myDataSet);

     

     

     

    Please how can I solve this problem

    any help will be highly appreciated

    Thursday, January 31, 2008 7:05 AM