Click to See Complete Forum and Search --> : Re: how to give value to parameter in a query of dataset in C#.net2005?


ssfftt
January 22nd, 2006, 12:58 PM
he query is for FillByCNPending is:

SELECT ServiceID, ServiceDeliveredDate, CustomerName, FROM [Freedom Scooter Service Reminder]
WHERE (CustomerName = "@CNAME")
AND (ServiceDeliveredDate IS NULL)

my code is:

this.TableAdapterCusV.FillByCNPending(this.dataSetCusV.Freedom_Scooter_Service_Reminder,comboBoxCusName.SelectedValue.ToString());

when i run the app, it throws error:

No overload for method 'FillByCNPending' take '2' arguments

plz help

exterminator
January 23rd, 2006, 04:04 AM
No overload for method 'FillByCNPending' take '2' arguments
This is not really a database issue! Why have you posted it here? It should go in the C# forum or the ADO.NET forum. Anyways, the error is correct in what is says. The function (or its overloads) must not be taking 2 arguments. We do not have enough of your code visible to comment further on your code. Regards.