Ad:

VB.NET Discussion Thread
Unsolved
Views: 16038

Nov 26th, 2008

-1

Datatable and datarow.

Expand Post »

Doing a small project in which data from warranty cards are entered into a database ie. warranty card number, salesman name and ID, etc etc......after all the data has been entered into the database I need to check and see if there are any duplicate warranty card numbers in the database.

The way I am thinking is that ill first load the table into a dataset and datatable and then loop through all the records using the datarow object. compare each each record with all the other records and if i find a duplicate ill probably set a flag to make both invalid. I understand the concept but i am not too comfortable using all these objects ie datatable, datarow. It would be great if you could give me a simple syntax on how to loop through all the records using a datarow object.

Similar Threads

Trouble adding new row to DataTable (C#) in C#
Data from datatable after datagrid sorting in VB.NET
SQL, Dataview, DataTable and DataAdapter.Update in VB.NET
Export DataTable to Excel with variable number of fields in VB.NET
DataTable To CSV Don't have a clue in Visual Basic 4 / 5 / 6

isaackhazi

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

22 posts
since Sep 2008

Permalink

Nov 28th, 2008

Re: Datatable and datarow.

Dear Friend

I can not accept Your procedure .

I think you should check it before entering the syatem.

Check it before entering the system.

Suppose your dataset is ds;

dim count as integer

count=o
while (count < ds.rows.coun)

if ("Code is here"=ds.rows(count).ItemArray("Colomn No from table")
msgbox "Duplicate data"
else
end if
end while

Try it ...................

Gayan Wijeratne

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Nov 2008

Permalink

Nov 28th, 2008

Re: Datatable and datarow.

hmmm..... Shouldn't thé approach be : only insert a warranty-card-number into the database after a check if the card-number already exists?
You could write a stored procedure for example in which you use a 'transaction' which will be roled back if the cardnumber exists?

4advanced

Reputation Points: 33

Solved Threads: 10

Junior Poster in Training

Offline

67 posts
since Nov 2008

Permalink

Nov 28th, 2008

Re: Datatable and datarow.

dim _rows() as DataRow = mDataSet.Tables(TableName).Select("CardNumber = " & cardNumber)
if _rows.Lenght > 0 Then
.....
else
....
end if

I Agree. It is very strange to check duplicate after entered to database. You need to do it before.

Rogachev

Reputation Points: 11

Solved Threads: 9

Light Poster

Offline

44 posts
since Nov 2008

Permalink

Nov 30th, 2008

Re: Datatable and datarow.

thanx guys............well the problem is, its not a new project.........some other programmer has already created the database and entered a lot of data ......so, im trying to use the same database.......
Well from the information ive got , the company wishes to have duplicate data. I guess because they are not sure which data is legitimate......Well, at the end of it i need to check for duplicates after the data is entered.......No choice guys......

So getting back to the problem as i mentioned before .... I think i would use the code you gave me above as follows:

VB.NET Syntax (Toggle Plain Text)
for(count = 0;count < ds.rows.count;count++)
for(count1 = 0;count<ds.rows.count;count1++)
 
if (ds.rows.(count1).ItemArray("coulmn No from table")=ds.rows(count).ItemArray("Colomn No from table")
"What ever action to be taken"
else
end if
for(count = 0;count < ds.rows.count;count++)
for(count1 = 0;count<ds.rows.count;count1++)

if (ds.rows.(count1).ItemArray("coulmn No from table")=ds.rows(count).ItemArray("Colomn No from table")
"What ever action to be taken"
else
end if

Do you think this would work??........Any other ideas?? All this because if there are duplicates I have set the record as duplicate but i need it to be present in the database.
Thnx again guys. Appreciate it.

isaackhazi

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

22 posts
since Sep 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: How to get infor from SQL database in vb

Next Thread in VB.NET Forum Timeline: database connection for sql server 5.0 and vb.net

DaniWeb Message

Cancel Changes

User Name
Password