how to trace duplicate data in a gridview

Question

4.00/5 (1 vote)

See more:

VB

Dim connection As OleDbConnection
 connection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; " _
& "Data Source=" & Server.MapPath("~/Database/dbLupon.mdb") & ";")
 Dim commandPos As OleDbCommand
 commandPos = New OleDbCommand("Select POSITION_C FROM tblLupon_C WHERE POSITION = 'C' REGION_C = '" & lblRegion_C.Text & "' AND PROVINCE_C = '" & lblProvince_C.Text & "' AND CITYMUN_C = '" & cmbCityMun.SelectedValue & "' AND BARANGAY_C = '" & cmbBarangay.SelectedValue & "'")
 connection.Open()
 Dim DataReader As OleDbDataReader
 DataReader = commandPos.ExecuteReader()
 If GridView1.Rows.Count = 0 Then
     MsgBox("AKO!")
 Else
     While DataReader.Read
         MsgBox("duPLICATE")
     End While
 End If

hello guys!
I'm having a problem regarding duplicate data.
Is my code right? I must have one Chairman in my record. thanks!

Posted 20-Feb-11 14:50pm

sevengenn

Add a Solution

Comments

Albin Abel 20-Feb-11 22:18pm

This code not seems to be having problem. Duplicates may be from the database itself?. If the table joins with other table (one to many) then in the result the parent column will have duplicates.

Henry Minute 20-Feb-11 22:22pm

I cannot see anywhere in your code that you are putting any data into your GridView1. So I would expect that GridView1.Rows.Count will always be 0.

sevengenn 20-Feb-11 22:42pm

I used those code to validate if there are existing chairman in the field position. but I can't run it correctly..

thanks for commets :)

2 solutions

Solution 1

Since you are using a query, it would be better to trace duplicate data in the query itself.
Dont allow duplicate data to be displayed in the gridview.

Posted 20-Feb-11 17:11pm

Abhinav S

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)

Venkatesh Mookkan · Accepted Answer · 2011-02-20T17:21:00

Solution 2

I don't see anywhere you are binding the result to the GridView1.

From the above code, I did few modification. I hope this would help to find the duplicates.

VB

If Not DataReader.HasRows Then
    MsgBox("AKO!")
Else
    While DataReader.Read
        MsgBox("duPLICATE")
    End While
End If

Mark it as answer if it is helpful.

Posted 20-Feb-11 17:21pm

Venkatesh Mookkan

Comments

sevengenn 21-Feb-11 0:11am

thanks for the help :)

it works! :) thank much! :)

Venkatesh Mookkan 21-Feb-11 0:29am

You are most welcome.

sevengenn 21-Feb-11 0:42am

sir, can I asked again some questions regarding this? in this thread?

Venkatesh Mookkan 21-Feb-11 0:45am

You will get more responses (from others too), if you start a new thread for other question. Moreover, I visit CP very less time.

So post is as new question.

sevengenn 21-Feb-11 0:48am

thanks sir :)