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");






    Please how can I solve this problem

    any help will be highly appreciated

    Thursday, January 31, 2008 7:05 AM