Visual Basic

Re: String compare from different text files

27-Jul-07 12:38

I would to compare the value from the certain column, row of 2 different text files. I have already stored into them to 2d array. Any idea how to start from scratch so that i can compare them? It involves the complicated for loop or do while loop. Confused | :confused:

Christian Graus27-Jul-07 13:00

Re: String compare from different text files

27-Jul-07 13:00

I don't see what the question is. If you have them in a 2D array, then use the right indices to compare the values that need comparing ? Perhaps you need to explain more.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

sweehin1827-Jul-07 13:33

Re: String compare from different text files

27-Jul-07 13:33

For example:

For File A.txt and B.txt, I have already stored the value from certain row and column of A.txt and B.txt into 2 D array by using the do while loop. For A and B, they got their own do while loop.

If i compare the value outside the do while loop, the 2d array would get the undefined value. They cannot be compared at all.

If I put both of the A and B in One do while loop, it will become complicated.

Christian Graus27-Jul-07 14:35

3 Newbie Questions MS.Excel2003-VB.Net2003

27-Jul-07 14:35

So, create your arrays THEN use those arrays to lookup the values you want to compare.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

frankiebaby227-Jul-07 12:06

frankiebaby2

27-Jul-07 12:06

Q1/If this is the path to save an open Excel file running in the background

xlSheet.SaveAs("c:\My Path\tk" & Format (Me.MonthCalender1.SelectionStart, "yyyyMMdd") & ".xls")

How would I open a file using the MonthCalender1 (Change-Date) as the trigger to determine the name? e.g. "tk20070727.xls" ?

Q2/ Having opened the file (running invisable in the background), how can I pull the data from a cell to a variable?

Q3/ How do I close the invisable running .xls file in runtime?

Confused | :confused:

Dave Kreskowiak27-Jul-07 13:57

Dave Kreskowiak

27-Jul-07 13:57

So how many times are you going to post the same question(s) in one day? Yes, it's considered very rude.

I don't do Office Interop, so my experience with it is VERY limited.

But, I'd image you would find the Open method on a Workbooks collection. You'd have to pass it the complete path to the file you want to load. It looks like you already know how to generate the filename you need.

Pulling data from the cells would probably involve something about a Range object with, maybe, a Cells collection that holds a bunch of cells, and possible a Value property of each Cell.

There's a ton of examples out there. All you have to do is Google for something like "vb.net Excel workbooks", or "vb.net excel Range object", "vb.net excel retrieve cell values".

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

frankiebaby227-Jul-07 14:48

frankiebaby2

27-Jul-07 14:48

Thanks Dave for you compassion and understanding. I hope you have a wonderful day and everything goes the way you'd like it too.

ne0h27-Jul-07 20:05

ne0h

27-Jul-07 20:05

You have to manualy release COM object to kill the excel process running in the background.

Say your Excel.Application object is myApp. Then use this:

<br />
myApp.Quit()<br />
System.Runtime.InteropServices.Marshal.ReleaseComObject(myApp)<br />
System.GC.Collect()

--------------------------------
txtSignature

frankiebaby227-Jul-07 20:45

frankiebaby2

27-Jul-07 20:45

Thank you very much Neoh, it is good to get someone to help with this stuff.

Some people would rather abuse Newbies than spend the same time making the world move a little faster by helping them.

Google is great but doesn't always hit the nail on the head, and asking questions for help is what I thought this site was about.

Again many thanks mate, you're a champion!!

Frank Big Grin | :-D

Re: Creating Stock Program

ne0h27-Jul-07 21:20

ne0h

27-Jul-07 21:20

No Problemo Big Grin | :-D

--------------------------------
txtSignature

Combobox Datasource

ryan11727-Jul-07 10:58

ryan117

27-Jul-07 10:58

I'm populating a combobox "ChargeName" by datasource depends on the item selection of another combobox "ChargeDegree", the combobox "ChargeName" indeed displays the list of items I expected depending on the "ChargeDegree" combobox selection. However, when I select the "ChargeName" combobox to print out, let's say, on a label or on a grid cell, strangely it displays "System.Data.DataRowView", instead of the supposed item of a Charge Name I selected.

        Dim sqlCharge As String<br />
        Dim dbGate As New databaseGateway()<br />
        Dim dsCharge As New DataSet<br />
        Dim chargeDegree As String 'the degree of the charge<br />
<br />
        chargeDegree = cbxChargeDegree.SelectedItem.ToString()<br />
        sqlCharge = "Select ChargeName from Charge where ChargeDegree = '" & chargeDegree & "'Order by ChargeName"<br />
        dsCharge = dbGate.ExecuteQuery(sqlCharge)<br />
        cbxChargeName.DataSource = dsCharge.Tables(0).DefaultView<br />
        cbxChargeName.DisplayMember = "ChargeName"<br />
        cbxChargeName.ValueMember = cbxChargeDegree.SelectedText<br />
        cbxChargeName.SelectedIndex = 0

Does anyone know why this is it?

Please Help Me. Thank You Very Much. Ryan

Re: Combobox Datasource

Naji El Kotob27-Jul-07 11:28

Naji El Kotob

27-Jul-07 11:28

Hi,

By default the ToString returns then Namespace.ClassName of the object, you could change this behavior by overriding the ToString function (In case you design your own class), in your case try to use the following:
chargeDegree = cbxChargeDegree.Text

hope this helps Smile | :)

NajiCo http://www.InsideVB.NET[^]

It's nice 2b important, but it's more important 2b nice...

Re: Combobox Datasource

ryan11728-Jul-07 0:29

ryan117

28-Jul-07 0:29

Thank You, but it still doesn't work. I think the problem is one of the following syntax:

cbxChargeName.DataSource = dsCharge.Tables(0).DefaultView<br />
cbxChargeName.DisplayMember = "ChargeName"<br />
cbxChargeName.ValueMember = cbxChargeDegree.SelectedText<br />
cbxChargeName.SelectedIndex = 0

The chargeName combobox does has the items I expected upon the selection on the chargeDegree comobox, but strangely the text string display is "System.Data.DataRowView".
Can anyone else help me, please?

Thank You Very Much. Ryan

Creating Stock Program

yellowlogic27-Jul-07 10:38

yellowlogic

27-Jul-07 10:38

I would like to start creating a Program that will get all the information about stocks. i will be using Visual Basic 2005. can some please help me with how do i get the data from the internet to the program. I want this to be a windows application. if anyone has any ideas please let me know how you would do this. Thanks

Danny
yellowlogic@cox.net

Danny
yellowlogic@cox.net

Christian Graus27-Jul-07 11:02

Re: Creating Stock Program

27-Jul-07 11:02

You need to find a source for stock info, obviously.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Naji El Kotob27-Jul-07 11:04

Naji El Kotob

27-Jul-07 11:04

Hi,

XML is the best technology for data interchange, look for a provider that publish the data in XML format and the rest is easy.

Good Luck Smile | :)

NajiCo http://www.InsideVB.NET[^]

It's nice 2b important, but it's more important 2b nice...

Re: Creating Stock Program

penguin500027-Jul-07 11:06

penguin5000

27-Jul-07 11:06

Have a look at "Interacting With Web Sites in Code" by clicking here

How to use ArrayList?

sweehin1827-Jul-07 10:03

Re: How to use ArrayList?

27-Jul-07 10:03

ArrayList contains the row of data as its items. How to iterate through the lines, split each and store the data(array of columns) as new item in the ArrayList? Please provide example.

Naji El Kotob27-Jul-07 10:59

Naji El Kotob

27-Jul-07 10:59

Hi,

I am not sure if you I got you right, please post your code to make your question clearer, for now you could iterate using the Count and Item properties:

'Abstraction
Dim c() As Columns
For I as Integer = 0 to coll.Count -1 'coll = ArrayList
c = coll.Item(i)
'Process your columns here
For J as integer = 0 to c.Length -1
... c(J)
Next
Next

hope this helps Smile | :)

NajiCo http://www.InsideVB.NET[^]

It's nice 2b important, but it's more important 2b nice...

Re: How to use ArrayList?

sweehin1827-Jul-07 12:09

Re: How to use ArrayList?

27-Jul-07 12:09

In c#, the syntax is sth like this

(arry_List[3] as string[])[2]

arry_List[3] - the fourth item in the ArrayList, meaning third line.
the [2] means the third item in the columns array.

codemunkeh27-Jul-07 16:28

codemunkeh

27-Jul-07 16:28

Anything written "In c#" is not really a good idea to have in the VB forum.

Ninja (the Nerd)

Confused? You will be...

Help with dll

Bad Programmer27-Jul-07 9:46

Bad Programmer

27-Jul-07 9:46

HI,
I have an application Ensemblepro, which shows realtime stats of the business in our organisation. It uses remote DB to store. and i didnt know the structure of the DB. (Limited Access). I need to get the real time data ?????? From that application in any format???
Can anyone post ur suggestions...

Thanx in Advance..... Smile | :)

Bala

Re: Help with dll

Christian Graus27-Jul-07 11:02