object data source could not found method insert , update , delete

Question

5.00/5 (1 vote)

See more:

Hello ,
I am a asp .net coder . I am doing my project using c# and at the back end there is my-sql . I have created dataset from solution explorer . I have configured table adapter correctly for Customer creation . here the method get works correctly . than i have add query regarding insert , update , delete . At the asp .net web form first i have added a objectdatasource from the toolbox . configured it with datasettableadapters.customerstableAdapter . select the get method as select method and provide insert , update , delete method what i have created at the dataset table adpater . Than i have drag a details view and select the datasource as objectDataSource1 . enable insert , update ,
delete . Every thing works fine now on word . When I run the webpage the detailsView show the information of the customers . But when i go for edit , update , delete than it shows an error that object datasource could not find query delete and it's parameter . What may be the solution .

Posted 2-Aug-10 6:09am

jamil_2342

Add a Solution

Comments

Prasad Bansi Vagal 2-Aug-10 12:27pm

Reason for my vote of 5
good question as it migh be very important to make your code work at your working place.

Prasad Bansi Vagal 2-Aug-10 12:56pm

Reason for my vote of 5
It is very essential, concentration is very important for this to be done.

koool.kabeer 2-Aug-10 12:58pm

are you using stored procedure?...

2 solutions

Solution 2

thing is that i am using query instead procedure .

Posted 2-Aug-10 7:19am

jamil_2342

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prasad Bansi Vagal · Accepted Answer · 2010-08-02T06:27:00

this error means that even though you have writen the code correct, you have not created the stored proceduer in sql by using query analiser or management studio of Sql as you created the table in sql.

use the stored procedure string in code also, then it will work, according to me you are using parameters to pass query values in the database in your code as you might be using stored procedure value in insert query of your code, but as you have not created a stored procedure in sql it is giving an error of parameters not found.I hope stored procedures work for you, yes ofcourse it will.

prasad :-D