|
The actual problem appears to be that the lines that belong together, are mixed up.
You could just create a datatable (or a temporary database table), and insert all lines separately, including the tag numbers.
Then sort the table by tag numbers, concatenate the rows where necessary, and then insert the concatenated values into the production database table.
My advice is free, and you may get what you paid for.
|
|
|
|
|
Something like (with possible syntax errors  ):
using sr as stringreader = new stringreader("MyFile)
dim inLine as string = sr.readline() 'assumes first line has tag
while sr.peek >=0
dim s as string = sr.readline
if s.startwith(":")
'write inLine as db record
inLine = s
else
inline = inLine & s
end if
end while
end using
Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
|
|
|
|
|
Thanks for the reply,its been very helpful.
That should handle the first transaction block with a (":").I have a query though.See every tag(":")has its own transaction eg :61: and :86: are totally different transactions and this two should be stored in different tables in the db.What happens when i reads the next(":") and want to store it on a different table.How can i map this line to the tag that appeared just before it?
Regards
|
|
|
|
|
Would something like this do what you want?
using sr as stringreader = new stringreader("MyFile)
dim inLine as string = sr.readline() 'assumes first line has tag
while sr.peek >=0
dim s as string = sr.readline
if s.startwith(":")
'Might be possible to use Select Case instead of multiple Ifs
If inline.Startswith(":61:") then
'do 61 stuff
End if
If inline.Startswith(":86:") then
'do 86 stuff
End if
inLine = s
else
inline = inLine & s
end if
end while
end using
Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
|
|
|
|
|
When i m changing my system Resoluction then my software controls are not viewing.
Suggest me how to set resoluction setting for my application.
Thanks
If you can think then I Can.
|
|
|
|
|
try out My.Computer.Screen
My advice is free, and you may get what you paid for.
|
|
|
|
|
Getting Computer Resoluction is not my Problem. My problem is that how to Manage software for diffrent resoluction and DPI.
If you can think then I Can.
|
|
|
|
|
If you can retrieve the resolution, of the screen, then you could build your GUI dynamically.
Use relational sizing for your controls (and font sizes where necessary) and add them to the form at runtime.
Alternatively you could spread out your controls over multiple forms, that you call when necessary, or over a tab control.
My advice is free, and you may get what you paid for.
|
|
|
|
|
My application is simple dialog which size is 867, 666.
but when i am changes it's DPI 120 then its Controls are not showing which are standing in the Buttom of Form.
If you can think then I Can.
|
|
|
|
|
Dim g As Graphics = Graphics.FromHwnd(Me.Handle)
MsgBox("DPI Value: " & g.DpiX.ToString())
This bit of code will get you the DPI setting of the machine your app is running on.
Maybe you can use this, when you calculate the size of your controls and fonts
My advice is free, and you may get what you paid for.
|
|
|
|
|
I am using this code.But my form height is not incresing.
If you can think then I Can.
|
|
|
|
|
I had a similar problem. Set the "AutoScaleMode" property of the form to "Off". When you change the DPI, it's auto-scaling your controls and causing them to display incorrectly.
Hope that helps,
-Ray
|
|
|
|
|
I have generate one more problem.
I am creating Control at runtime in 96 DPI it shows normally. but when i am changing DPI 120 controls are moving thereware.
If you can think then I Can.
|
|
|
|
|
I have a grid view and i want a code that when the value of the cell (3) from row(3) is 1, to move to row number 15 otherwise move to row number 4
can someone help me plz?
|
|
|
|
|
in the cell change value event do the following
check the location of the cell
if it is 3/3 check the value of the cell
if 1 then select row 15
else select row 4
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi, I have made a database where I can sort all my mp3's.
When I search for an artist, I can open a song in Windows Media Player just by double-clicking it. My problem is that if I want to play more than 1 song at a time, Windows Media Player removes my "Now playing" list and starts playing the song I only want to ADD to the list.
I have searched for a solution for this and I found some info at this page, http://msdn.microsoft.com/en-us/library/aa386383(VS.85).aspx[^], but it did not solve my problem. I still can't add a song to the "Now playing" list. 
What I want is a command that behaves like when I r.click on a mp3-file in Explorer and choose "Add to Windows Media Player list".
I would be very grateful if anyone can help me with this. I have tried to find a solution for 4-5 hours now and I'm close to giving up...
- Ragnar
|
|
|
|
|
Looking though the file options for WMA files, I found that when you click on a WMA file, Windows uses the following command:
"C:\Program Files\Windows Media Player\wmplayer.exe" /prefetch:5 /Play "%L"
%L is the path to the file/files (I assume). You will have to experiment. Usually %1 indicates the path.
Hope that helps,
Ray
|
|
|
|
|
Thanks for answer, but it did not help me with my problem.
But I got some nice results when I searched with /prefetch that showed me that Winamp could do what I needed, so now I can just do it with
'Winamp /add "songname"'
- R
|
|
|
|
|
I am confused ,
I am delevering thousands of video frames from different movies to my main program.
-BaseClass : 'papa' , handles frames
-Has got a declared class : 'baby' , produces frames
First it thought of raising a event in baby when a new frame arrived.
Papa class could have a handler to handle the frames.
But then it thought : events use a messageque somewhere , mayb no good idea.
Secondly , i thought of calling parent.dowork sub in baby class.
But when i wrote a test project, parent.dowork is a = only 1 % faster.
raise event : 10138 papa.dostuff : 10067
raise event : 10123 papa.dostuff : 10171
raise event : 10154 papa.dostuff : 10143
raise event : 10338 papa.dostuff : 10264
raise event : 10204 papa.dostuff : 10799
raise event : 10729 papa.dostuff : 10720
raise event : 10579 papa.dostuff : 10156
raise event : 10181 papa.dostuff : 10285
raise event : 10918 papa.dostuff : 10752
raise event : 10377 papa.dostuff : 10317
?????? HUH ???????
Jarno Burger
Video Jockey
modified on Sunday, May 17, 2009 9:04 AM
|
|
|
|
|
huh ? what is the question ?
This signature was proudly tested on animals.
|
|
|
|
|
how is this possible , that raising event is as fast a calling the sub in the parent?
Jarno Burger
Video Jockey
|
|
|
|
|
That is because it was written by someone who can't read. You.
|
|
|
|
|
haha 
Jarno Burger
Video Jockey
|
|
|
|
|
hey,
i must say i am letting all my friends run crazy over this world that i am in at this present moment.
Troy
|
|
|
|
|
There wouldn't be that much of a difference. I guess you were thinking that messages sit around in the message pump for a few seconds before they're processed?? Not true...
Having the child directly call a method in the parent class in not a good idea, unless you're using delegates and Invoking. The child should never be tied directly to another class.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
