How to handle update and insert command on same submit button

Question

0.00/5 (No votes)

See more:

I have one gridview in that a link button is used for update. on click on update(Edit) it assign a value of selected row to respective text box .We can insert data dynamically by filling text boxes and then click on submit button.
the problem is that the submit button should use for both update and insert .

Posted 8-Oct-15 2:44am

asplover1

Add a Solution

Comments

Maciej Los 9-Oct-15 1:45am

What database? What have you tried? Where are you stuck?

1 solution

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)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2015-10-08T07:29:00

Solution 1

You should have some primary key field value in a HiddenField or something. So, if it is an existing record, you can get a Id which will be greater than 0, meaning a valid Id.

So, if Id is greater than 0, then update that record, else insert.

Posted 8-Oct-15 7:29am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

asplover1 9-Oct-15 0:04am

But I want to insert and update record both on same submit button

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 9-Oct-15 2:00am

That's what I said too. You need to store the Id of the field being inserted/updated. If Id is greater than 0, then in button click event, you can easily identify that it is an existing record. Otherwise it will be a new record.

asplover1 9-Oct-15 2:03am

Ok got it. I will try it. Thank you

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 9-Oct-15 2:33am

Great. After you solve it, please accept the answer. :)

asplover1 9-Oct-15 2:57am

Thank very much. I done it. It works Properly.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 9-Oct-15 2:59am

Glad to hear that. :)

asplover1 9-Oct-15 6:31am

hiwould you plz help me . I post my question
http://www.codeproject.com/Questions/1037748/How-to-get-values-of-selected-row-of-DataGridview

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 9-Oct-15 8:41am

I have answered. Please check.