How to protecting data double on a DataGridView

Question

1.00/5 (1 vote)

See more:

SQL-server-2000

Hi I have a txtKodeITem and a DGPembelian.
*DGVPembelian (DatagridView)

The question:

How to do this logic when I click btnsave :
If txtKodeitem = DGVPEmbelian then
not add new row again but do update tblPembelian.
Sorry have not good speaking english.
Please understand.

Posted 3-Oct-13 15:38pm

irwan sesab

Updated 3-Oct-13 16:03pm

v2

Add a Solution

Comments

ZurdoDev 3-Oct-13 21:56pm

I don't understand. If you want to check if a record exists then use IF EXISTS() in SQL. IF EXISTS() then do UPDATE otherwise do INSERT

irwan sesab 3-Oct-13 22:01pm

I Mean. When I click btnSave than he check value on datagrid. If found then datagrid not add new row

ZurdoDev 3-Oct-13 22:05pm

So, where are you stuck?

irwan sesab 3-Oct-13 22:11pm

how to make the datagrid not add new row?

Manoj K Bhoir 6-Oct-13 9:35am

Don't make any DataGrid, it's already made by Microsoft :)
You just have to check Whether Value you are inserting into the Database is already Present or Not on your btnSave Button before Saving the Record. If record is already present then just Update the record otherwise insert the same record. Now to check record exist or not you have to execute some queries on your Database and I hope you have the basic knowledge of Database otherwise Google is your friend.
Best Of Luck :)

irwan sesab 9-Oct-13 0:57am

Before I insert into the database.
For the first time I inserting into the datagridView as a temporary table, then when I click btnSave that is going to insert into database.
My question is how to make a protected it when I during insert to the datagridView?

Manoj K Bhoir 9-Oct-13 1:39am

So check Record in your DataGridView. See below sample code :
Dim _mFlag as Boolean = False
For Each _mColumn As DataGridViewRow In DataGridView1.Rows
If _mColumn.Cells(0).Value = txtKodeitem.Text() Then
_mFlag = True
Else
_mFlag = False
End If
Next
If _mFlag = False Then
'Save Your Data into Table
Else
'Update Reocrd
End If
Just Change Column Index instead of 0 in _mColumn.Cells(0) with your column index in which you want to check value exist or not.

irwan sesab 10-Oct-13 1:01am

That code is not working as good.
Always do the line code 'MessageBox.Show("No Data Found")'.
Althought, the data between txtKodeItem and DatagridView1 not same.
Why like that?
What condition he read the line code ' MessageBox.Show("Record Present")' ?

Manoj K Bhoir 10-Oct-13 1:42am

Please check updated code.
This code simply check in each Row of DataGridView of your specified column
whether data is present or not. If data is not present in your DataGridView _mFlag value will be False so you can insert record in DataGridView otherwise update the same record.

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)