I have a general question regarding ADO Parameter class. I have never used it before, but came across a solution to a problem that uses it. (I was trying to insert a blob into a Mysql/ASA DB). As far as I understand the parameter class is used for stored procedures, is this correct, or does it go further than that? And when is it good to use the parameter class? All the solutions I could find for the problem above only used the parameter class, is there another way of inserting a blob into a DB without the parameter class, I tried a direct insert of the binary into the table, no joy. Basically I do not know what and when to use the ADO parameter class, if someone could help out with the basics, it would highly be appreciated. Thanks in advance. -- modified at 9:47 Tuesday 29th May, 2007

Kind Regards Scorn

Great, I do need to campare every record in the first table with every record in the second table. Thanks for the help.

Kind Regards Scorn

Hi Dave, I need to pick your brain some more please. I have managed to get right what I wanted to do, however I would like to know if this is the correct way of doing it, or if there is a different way. Once again is this code resource effiecient? Public Function fnCheckClientMasterRecords() As Boolean Dim dbrAsiClients As SqlDataReader Dim dbrXpressClients As OleDbDataReader 'Two functions that return the records that I need to compare and populates my new datareaders dbrAsiClients = fnGetAllASIClients() dbrXpressClients = fnGetAllXpressClients() While Not dbrAsiClients.Read = False While Not dbrXpressClients.Read = False If Not Left(dbrAsiClients.GetValue(0).ToString(), 6) = Left(dbrXpressClients.GetValue(0).ToString(), 6) Then MessageBox.Show(Left(dbrAsiClients.GetValue(0).ToString(), 6) & " - " & Left(dbrXpressClients.GetValue(0).ToString(), 6)) Else 'Yes code here End If End While 'Do I have to close the reader here everytime I Have looped through it and re-populate it. dbrXpressClients.Close() dbrXpressClients = fnGetAllXpressClients() End While End Function Your input will be appreciated. Kind Regards Sean Venter

Hi Kanniah, I am going to try Dave's solution first as I would like to save on resources. Should I not get it right I will try your solution. Thanks for the reply. Regards Sean

Hi Dave, Thanks for your reply, I will give your answer a try and see how I do. Regards Sean

Hi All, I am new to VB.net and I am struggling with small function I need to write. Basically this function must get results from two different datareaders, Oledb and SQL and compare the results. Is using a datareader the right way of going about a comparison between two recordsets, or is there a better way. Basically I need to compare the results of the two recordsets and the differences must be noted in a file. Any help will be appreciated. Regards Scorn.