how to prevent already inserted data by checkbox to insert into database

Question

0.00/5 (No votes)

See more:

Hello,

I have a grid view and in this gridview 1 checkbox is there. i want to insert the data into the database of checked row of gridview. but when second time i insert 2 or 3 row with old checked row of gridview then it should skip to insert the data of old selected row and insert the data of new selected row...

please help me..

Thanks..In Advance...

Posted 30-Jun-14 19:38pm

shyam kanungo

Add a Solution

Comments

George Jonsson 1-Jul-14 1:47am

Make a list of your different use cases so you know exactly what should be done in each case.
Then you can use the DataRow property RowState to check if the row is new or updated or what.

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)

praveenlob7 · Accepted Answer · 2014-07-02T00:12:00

Solution 1

Before you insert, check in the DB if that record exists. If so, then dont insert the record.

Posted 2-Jul-14 0:12am

praveenlob7

Comments

shyam kanungo 2-Jul-14 6:16am

sir,,
I have a grid view and in this gridview 1 checkbox is there. i want to insert the data into the database of checked row of gridview. but when second time i insert 2 or 3 row with old checked row of gridview then it should skip to insert the data of old selected row automatically and insert the data of new selected row...

George Jonsson 2-Jul-14 6:47am

The solution doesn't really solve his problem.
I presume he wants to avoid to check in the database.

shyam kanungo 2-Jul-14 7:01am

Exactly right sir..
I my project admin approve users from gridview using checkbox and selected users inserted into database. my problem is if in next admin checked another user to insert into database than previously checked user also inserted once again.. so i want to prevent this..

George Jonsson 2-Jul-14 7:05am

So what you really want to do is to avoid duplicates in the database?
The number transactions are not critical.Right?

shyam kanungo 2-Jul-14 7:13am

yaa right

George Jonsson 2-Jul-14 7:46am

I would go for a stored procedure that inserts a new row if it doesn't exist and updates the row if it already exists.
It is more safe if you have many clients trying to do the same thing.

shyam kanungo 3-Jul-14 6:57am

Thank you George .. I solved my problem by using your Comments ..