|
You can do this with DataReaders. They'll be faster and more memory efficient than loading entire sets of data. They also offer the flexibility of looking at millions of records without loading them all into RAM.
After that, you just compare record for record, incrementing each DataReader to compare then next records.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi Dave,
Thanks for your reply, I will give your answer a try and see how I do.
Regards
Sean
|
|
|
|
|
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?
<br />
Public Function fnCheckClientMasterRecords() As Boolean<br />
<br />
Dim dbrAsiClients As SqlDataReader<br />
Dim dbrXpressClients As OleDbDataReader<br />
<br />
'Two functions that return the records that I need to compare and populates my new datareaders<br />
dbrAsiClients = fnGetAllASIClients()<br />
dbrXpressClients = fnGetAllXpressClients()<br />
<br />
<br />
While Not dbrAsiClients.Read = False<br />
While Not dbrXpressClients.Read = False<br />
If Not Left(dbrAsiClients.GetValue(0).ToString(), 6) = Left(dbrXpressClients.GetValue(0).ToString(), 6) Then<br />
MessageBox.Show(Left(dbrAsiClients.GetValue(0).ToString(), 6) & " - " & Left(dbrXpressClients.GetValue(0).ToString(), 6))<br />
Else<br />
'Yes code here<br />
End If<br />
End While<br />
<br />
'Do I have to close the reader here everytime I Have looped through it and re-populate it.<br />
dbrXpressClients.Close()<br />
dbrXpressClients = fnGetAllXpressClients()<br />
<br />
End While<br />
End Function<br />
Your input will be appreciated.
Kind Regards
Sean Venter
|
|
|
|
|
If your comparing every record side-by-side against a corresponding record in the second dataset then you don't use two while loops. You use one.
If your comparing every record in the first table with every other record in the second table, then this works. And yes, you have to reload the DataReader for each pass, since they a forward-only readers. You can't move the cursors in them backwards.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
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
|
|
|
|
|
Does anyone how can I play medai file such MP3, DAT,... in VB.NET
Thanks
................
|
|
|
|
|
Yes you can.
--------------------------------------------------------
My portfolio & development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
Hi,
I am currently in need of an article or the steps required for creating a UFL that I can then use within my crystal report. I have no idea how to do this, and after reading a few articles online, they require me to create a new project, win32 dynamic link library project, but I cannot find anything close to that unless I go into the MFC projects. Could someone point me to a good article or give me a walkthrough on how to create this project? thank you.
PS
I am using visual studio 2003.. standard?
eatwork
|
|
|
|
|
Here's my question
I know how to create controls and add them to the winform at runtime.
While I hope I can save added controls somewhere on the disk, so next time the users open the winform, the added controls will be there.
Thanks.
|
|
|
|
|
Hi
You have to store the information somewhere in the database/textfile from where you can load the controls when the user wants at a later stage. The information to be stored are Control Type, Left, Top, Width and Height, so that you can recreate the controls and set these properties.
Hope this helps you.
Kanniah
|
|
|
|
|
Thank you so much, this does help me.
but I got a further question about this.
I am doing a project pretty much like the photoshop (but much simpler and easier).
Users can add and edit controls on a winform.
I was trying to save the users added controls in a txt file by saving a string
object.gettype.tostring. e.g: "System.Windows.Forms.PictureBox"
while when trying to Retrive the information, How can I create this object back?
I can do the following:
if string = "System.Windows.Forms.PictureBox" then
dim a as new picturebox
end if
Are there other ways of doing this?
Thanks
|
|
|
|
|
Hi
what you have written is correct. I don't think there is any other way to do this.
Kanniah
|
|
|
|
|
I need to know if exists a control o method that can i clear the texboxes in a form. for example i have texbox1,texbox2,texbox3,texbox4 but only want to clear de textboxes 1 and 4, i looking for a control or method no the manually form. if some body know a cotrol plis send me a email to magno.vasquez@gmail.com
|
|
|
|
|
There's no method to do it for you. You have to clear the TextBox's yourself.
TextBox1.Text = String.Empty
TextBox4.Text = String.Empty
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I have an application is running on a local LAN. I need to create a service that other users on the LAN can send XML data to, have it process it, and return back an XML recordset. It will need to be able to queue requests from multiple clients.
I am looking for some ideas on where to get started.
The clients will all be authenicated via Windows.
They all will be connected directly via LAN.
VB.NET is my preferred development language (have both 2003 and 2005)
Thanks for your time.
Lee
|
|
|
|
|
Look into web services. They are easy to create and work fine in a LAN environment. You can pass datasets to and from a web service. They make working with xml easy.
how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things
--thedailywtf 3/21/06
|
|
|
|
|
According to the Microsoft Online Help: http://msdn2.microsoft.com/en-us/library/07wt70x2.aspx
For VB.NET, it says to declare GetFiles per below before using it. Why do you need to redeclare it in your code? I would thing that if it is part of the System.IO Namespace, it is already declared? Help, very confused.
<br />
'Namespace: System.IO<br />
'Visual Basic (Declaration):<br />
Public Shared Function GetFiles(path As String) As String()<br />
<br />
'Visual Basic (Usage):<br />
Dim path As String<br />
Dim returnValue As String()<br />
returnValue = Directory.GetFiles(path)<br />
|
|
|
|
|
Freddie Code wrote: For VB.NET, it says to declare GetFiles per below before using it.
No, it doesn't. The Declaration is only there for reference in passing parameters and what the return value, if any, is going to be. Don't include the Declaration code in your own code.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I have the GetFiles method working correctlynow, thanks. GetFiles reutrns the complete path, not just the file name. Searching the help, there does not seem to be a method that just returns the file name.
My goal is to prepend the file names per the users input in a textbox. What would be the best way to do this? Since the file name returned by GetFiles includes the entire path, is there an easy way to extract just the file name, modify it and resave it?
Thanks.
|
|
|
|
|
There is nothing that will return just the filename. You have to parse each filepath to get the name. This is easily doen with the Path[^] class.
Dim fn As String = Path.GetFileName(Fully Qualified Path)
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I have to develop a vb appln that sends email to some people at regular intervals. It should start executing at the os startup and remain active forever. At a particular time, it should send an email to some recipients.
Pls it is a bit urgent, can somebody help me?
Thanks in advance,
Pasha
|
|
|
|
|
This is for VS 2003 and it looks like it has changed for VS2005. Here is some code to get you started. Look on MSDN for more class documentation.
Dim email As New System.Web.Mail.MailMessage<br />
Dim EmailSrv As System.Web.Mail.SmtpMail<br />
email.To = "youremail@yourcompany.com"<br />
email.From = "youremail@yourcompany.com"<br />
email.BodyFormat = Web.Mail.MailFormat.Html<br />
email.Body = "Testing"<br />
email.Subject = "Test Email"<br />
EmailSrv.SmtpServer = "email.yourcompany.com"<br />
EmailSrv.Send(email)
|
|
|
|
|
For VS2005, use the System.Net.Mail namespace instead. The System.Web.Mail namespace has been deprecated.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Does this approach require a Mail Server running on the same machine as the application?
|
|
|
|
|
No. You supply the DNS name or IP address of a valid SMTP server to the SmtpClient[^] class.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
