i am trying to update the customername it wont update?

Posted by Sudheep.grandhe under C# on 11/25/2011 | Points: 10 | Views : 931 | Status : [Member] | Replies : 5
HI,

i am developing windows applications in this i created a customerform.in this i want to update the customername,address but i am not able to update those details if i click on new it shows some message as:update requires a "valid insert command when passed datarow colletion with the newrows" and in same way in delete also it shows like" valid insert command when passed datarow colletion with the newrows".please do the needful.i posted my code here.

Best,
Sudheep.



Responses

Posted by: SheoNarayan on: 11/26/2011 [Administrator] HonoraryPlatinum | Points: 25

Up
0
Down
Hi Sudheep,

You need to write the Updatecommand for the SqlDataAdapter.

Read this http://support.microsoft.com/kb/308055

Even this thread can give you some idea - http://www.daniweb.com/software-development/csharp/threads/368140

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Arefin on: 11/26/2011 [Member] Starter | Points: 25

Up
0
Down
Hi Sudheep,
Actually this is very simple task. But I think you are missing something. So can you say, how your code is running for Update and Delete action? Then it would be easy to find out the problem.

Thanks,
Arefin

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sudheep.grandhe on: 11/28/2011 [Member] Starter | Points: 25

Up
0
Down
Hi,

I am using this referrence for my updating and deleting.i follow this link."http://www.akadia.com/services/dotnet_update_form.html"

Best,
Sudheep.

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Mittaikariss on: 11/29/2011 [Member] Bronze | Points: 25

Up
0
Down
now u got output Mr.Sudeep

http://www.invomtech.com/

....sundarsowmia....

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sudheep.grandhe on: 11/30/2011 [Member] Starter | Points: 25

Up
0
Down
Hi,

I am not getting output.please help me.

Best,
Sudheep.

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response