|
Hi
I want to read a reports file that comes in .txt , that report contain a Column like this
idno full name berth date
--------------------------------------------------------
1010000001 john Jackson 10/10/2007
1010044522 john molar 10/09/2007
1010000001 tom s******* 05/10/2007
all Column have a different lengths and different spaces between them
how to cut those Column and store it in a table by using vb.net
-- modified at 2:53 Saturday 10th November, 2007
|
|
|
|
|
Use the System.IO.File.ReadAllLines to read the contents of the file into an array. Then use string manipulation methods to split each line into its constituent parts.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
I well try to use this solution but let me tell you some thing a bout that report its contents 2000+ and more of line
Q: did the array is best way to use it here?
Q2: how to sorte it in tabel in database like MSaccess?
thank you for help me.
|
|
|
|
|
abdullah Hejory wrote: Q: did the array is best way to use it here?
You could use a StreamReader[^] if you are concerned about memory usage, although 2000 lines doesn't seem like that much data.
abdullah Hejory wrote: Q2: how to sorte it in tabel in database like MSaccess?
You would use ADO.NET[^] to import the data into MS Access.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
This forum is for asking specific VB(.NET) programming questions. No one is just going to do your work and give you the code.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
I didnt ask for ful coding. U can just suggest a way!!!
How to do?thats al..
Thank U
|
|
|
|
|
If you still want help, why have you deleted your original post?
BTW, it's rude to do this!
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi,
Does anyone know if it's possible to trigger an event whenever a video frame is being refreshed (e.g., every 50 ms for a 20 fps frame rate)? It can be either with DirectX or WMP SDK (or anything else within .NET. Alternatively, I could poll the video player and ask which frame is being played. Can't do that either at this point.
Thank you,
Yigal Agam
|
|
|
|
|
Please don't cross post.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
I am working on a program that needs a simple stacked bar graph (4 stacked values, 3 bars). I am doing it in VB due to all the math involved in the project. I have been searching for ways to do this, but all I have found are commercial controls that cost hundreds of dollars. The simplicity of the graphs and the scope of the program make this unreasonable (considering the $60 control as a last resort - csXGraph).
Any suggestions?
David Wilkes
|
|
|
|
|
If you are using VB.NET, you could draw the graph yourself using the classes in the System.Drawing namespace. I don't know about classic VB as I haven't used it for years.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
You can also use ZedGraph -
http://www.zedgraph.org[^]
Works incredibly well, has the feature you're asking for, you just pass it x and y values. You'd need to use VB.NET though unless you want to do a ton of COM interop, so this may rule it out since you're using VB.
"If you think of yourselves as helpless and ineffectual, it is certain that you will create a despotic government to be your master. The wise despot, therefore, maintains among his subjects a popular sense that they are helpless and ineffectual."
- Frank Herbert
|
|
|
|
|
Thanks! As it turns out I had this all along (got it but never used it for a diffrent project) but forgot about it.
David Wilkes
|
|
|
|
|
I have a project created in VB5 and migrated to VB6, VBNet 2003, and VBNet 2005.
I recently placed some labels on the form. When I clicked on the labels VS created the code to handle the click event. I placed my code in the event handler.
When I ran the project in the debugger I clicked on the labels. Nothing happened!
Labels are more complicated in 2005 compared to 2003.
I checked their properties. Enabled is true. I don't see any others that would apply.
What am I missing?
Thanks
RCarey
RCarey
|
|
|
|
|
|
On the Sub that handles the Click, does something similar to "Handles LabelName.Click" follow it?
The code that VS created should look something like:
<br />
Private Sub Label1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label1.Click<br />
<br />
End Sub<br />
I hope this helps,
Mitch
|
|
|
|
|
That was it!
Because of "pretty indenting" the Handle.Label1.Click was out of site on the right side and was misssingin the box I was testing.
Thanks
RCarey
RCarey
|
|
|
|
|
I'd like to replace the bytes in an existing filestream with the value of an update Int64 variable.
I don't think I can just write the variable to the stream.
I think I need to write a buffer at the appropriate point in the stream.
But how do I best get my new Int64 variable into a buffer?
Thanks!
|
|
|
|
|
Hello,
I have a project in VB6 where I create a icon in the system tray, and when the user selects the icon a popup appears. This is working correctly.
However, if I have a windows form loaded with vbModal (or the MsgBox) then the popup will not show.
Does anybody know how the solve this problem?
The code that I can using is similar to the code shown here: "http://www.codeguru.com/columns/vb/article.php/c6541/"
Thanks.
|
|
|
|
|
How I can enable or diable parent form's toolbar when user close the child form? There are 2 buttons on the child form Ok and Cancel.
If user press Cancel button then nothing should happend except closing the child form but if user click OK button then save button on parent forms' toolbar should disable.
How this can be solved?
Thanks in advance.
Ejaz
|
|
|
|
|
when opening the child form pass along an instance of the parent form:
dim frm as new child(me)
in child form constructor
private frm as parent
public sub new (p as parent)
frm = p
end sub
then when user clicks OK you should be able to access the button thru the instance of the parent
private sub OK_click
frm.button.enabled = false
end sub
hope this helps
If my help was helpfull let me know, if not let me know why.
The only way we learn is by making mistakes.
|
|
|
|
|
 hello
how can i convert this into time format?
1 = 60 //which is 1 minute is equal to 60 seconds
time = 2700 // this should be outputed as 00:45:00
a = format(time, "00:00:00")
a = 27:00
//how can i convert 2700 in time to make 00:45:00 in vb6?
|
|
|
|
|
look at timeserial(0,0,2700)
|
|
|
|
|
Hi,
I'm having BIG problems with the substring method.
I have a really big string and I need to extract data from this string; and for that I use substring, but it does not return a good value.
pointer = InStr(startingPointer, readout, Chr(13) + Chr(10))
If startFlag = True Then ' IGNORE this
line = readout.Substring(startingPointer - 1, pointer - 1) ' This block of code executes only once. ignore this .
pocetniPointer = pointer + 2
Else
line = readout.Substring(startingPointer, pointer + 2)
End If
I have debugg countless times. After couple of loops the variable line just adds up found substrings. For example after 5 loops startingPointer is 135 and pointer is 145 by the look of the second block in the else statement the line should return the string of 12 characters but instead it return the number close to 100+ characters.
It does not give a new value to the line it just adds up to the old value. This is the only code that uses the variable line.
Please help!
Thank you!
|
|
|
|
|
substring(startposition,length)
so when startingpointer is 135 and pointer is 145 you will get a string of 145 length
if you only want the 12 characters substract startingpointer from pointer before using it
hope this helps
If my help was helpfull let me know, if not let me know why.
The only way we learn is by making mistakes.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
