Visual Basic

29-Aug-06 20:12

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.

Kanniah30-Aug-06 4:21

Kanniah

30-Aug-06 4:21

Hi
You can go for Datasets, which is much easier to loop (as you can forward / rewind the dataset) you cannot do this in a datareader.

All the Best!

Kanniah

Sean Venter30-Aug-06 6:00

30-Aug-06 6:00

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

Dave Kreskowiak30-Aug-06 5:10

30-Aug-06 5:10

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

Sean Venter30-Aug-06 5:59

30-Aug-06 5:59

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

Regards
Sean

Sean Venter1-Sep-06 0:15

1-Sep-06 0:15

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

Dave Kreskowiak1-Sep-06 2:24

1-Sep-06 2:24

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

Sean Venter3-Sep-06 22:09

How to save users added controls?

3-Sep-06 22:09

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

Media

Socheat.Net29-Aug-06 16:57

Socheat.Net

29-Aug-06 16:57

Does anyone how can I play medai file such MP3, DAT,... in VB.NET
Thanks

................

Re: Media

CWIZO30-Aug-06 1:09

CWIZO

30-Aug-06 1:09

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!

UFL for crystal reports

eatwork29-Aug-06 11:06

eatwork

29-Aug-06 11:06

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

yanhe29-Aug-06 10:08

yanhe

29-Aug-06 10:08

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.

Re: How to save users added controls?

Kanniah30-Aug-06 4:25

Kanniah

30-Aug-06 4:25

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

Re: How to save users added controls?

yanhe30-Aug-06 5:26

yanhe

30-Aug-06 5:26

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

How to save users added controls?

Kanniah31-Aug-06 3:19

Kanniah

31-Aug-06 3:19

Hi
what you have written is correct. I don't think there is any other way to do this.

Kanniah

Clearing texboxs?

Magno R. Vasquez29-Aug-06 9:35

Magno R. Vasquez

29-Aug-06 9:35

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

Re: Clearing texboxs?

Dave Kreskowiak29-Aug-06 10:07

Looking for a good solution

29-Aug-06 10:07

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

Lee Ludden29-Aug-06 5:39

Lee Ludden

29-Aug-06 5:39

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

Re: Looking for a good solution

ToddHileHoffer29-Aug-06 8:36

ToddHileHoffer

29-Aug-06 8:36

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

Directory.GetFiles Method (String) - VB.NET 2005

Freddie Code29-Aug-06 4:40

Freddie Code

29-Aug-06 4:40

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. Confused | :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 />

Re: Directory.GetFiles Method (String) - VB.NET 2005

Dave Kreskowiak29-Aug-06 7:21

Re: Directory.GetFiles Method (String) - VB.NET 2005

29-Aug-06 7:21

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

Freddie Code30-Aug-06 4:34

Freddie Code

30-Aug-06 4:34

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.

Re: Directory.GetFiles Method (String) - VB.NET 2005

Dave Kreskowiak30-Aug-06 5:18