|
cstrader232 wrote: several thousand small text files
Certainly if you are going to be using the data many times you would be better to convert the files into a database of some description, then work with your database.
Of course, all this goes out the window if you get a new set of "several thousand small text files" each day...
-------------------------------------------
Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Just bugger off and leave me alone!!
|
|
|
|
|
Yes the files are new every day.
Isn't it possible to store the data from a text file in a file that is _smaller_ than the textfile itself? If I create a database and then serialize it, the resulting file is about 10x _larger_ than the original textfile.
Is there a binary file format that would allow a quicker read of the data into a datatable? Or is serializing the datatable likely to be fastest?
Thanks
|
|
|
|
|
What exactly is it that you are trying to accomplish?
-------------------------------------------
Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Just bugger off and leave me alone!!
|
|
|
|
|
OK, I want to read the file from disk. It is an two dimensional array of double() - size about 10 x 300
Then I need to go through the array and make some simple calculations
Then close the file and do the next file.
...many thousands of times, as fast as possible.
Perhaps I should be using binarystreamreader?
Do datatables have a lot of overhead?
thanks
|
|
|
|
|
when i update a record in the database using command from another form, the database becomes updated but the oledbdataadapter in the second form does not relect this changes until i restart the application. when I deployed the application, the changes do not even reflect even when I restart the application though the updated record appears in the database
this is the code i use to refresh the dataset.
Try
DsAsets1.Clear()
OleDbDataAdapter1.Fill(DsAsets1)
count()
Catch ex As Exception
MsgBox(ex.ToString)
End Try
I am using Ms Access as my database.
David T. Motajo
|
|
|
|
|
Sounds like you have to somehow commit the dataset to the database.
"The early bird may get the worm, but the second mouse gets the cheese" - anonymous, found in Uncle John's Bathroom Reader
|
|
|
|
|
I am quite new to windows form programing. In my application i want to be able to show a dialog box that has a progressbar in it when the main form loads a set of images into memory. I have created the form that contains a progress bar in it.. now what?
Thank you very much
|
|
|
|
|
Load your images in a thread so your UI remains responsive, then update the progress bar when each image loads. You want to use the BackgrouindWorker class, it can send messages to the UI thread to update progress.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
I was wondering if it possible to get VB to connect to a MySQL database or not, I've tried a few tutorials and I can't get it to work. I Don't want VB.NET to do it as I'm running this script on server that only serves PHP
|
|
|
|
|
Do you mean VB6 or VBscript ? Neither has anything to do with PHP.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Andrew Brock wrote: possible to get VB to connect to a MySQL database or not
Yes it is.
Andrew Brock wrote: I Don't want VB.NET to do it as I'm running this script on server that only serves PHP
Huh?
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
You can use VB6 as well as VB.NET to connect to MySQL. You will be needing ODBC data source for MySQL for that. This can be downloaded from MySQL site.
Nav
|
|
|
|
|
You should have directed your post to Andrew 
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
thanx guys I have since done anoth way using PHP. To answer the question why PHP the place I am building this for don't have Windows Server Licenses so they are using Linux but people can use Windows laptops to connect to the internet and other stuff like that
|
|
|
|
|
if can not used in vb.net ,if there other language or tool can used to detecting the mic
|
|
|
|
|
Don't start a new thread for follow up questions.
Christian was talking about physical limitations, it has nothing to do with the programming language you are using.
Experience is the sum of all the mistakes you have done.
|
|
|
|
|
Hi,
I wondered if anyone could help me (again). In a database, I have a list of users and their portfolio paths. I have got them to load into a list box. I need it so when a user clicks on a user ID from the list box, it shows the content of the folder in an explorer style window (using icons).
Being good at VB6, I can do that quite easily and the standard TreeView in .net is a bit dull and I have no idea how to do what I need to do.
Could anyone help me with this problem?
My sincere thanks.
|
|
|
|
|
Hi,
I wondered if people could help. I have a program which imports users and creates a folder for the user. The users details (including network username, folder path etc) are stored in a database. That all works fine.
I now need, as part of the import process, for the program to set the folder permissions so that the user has modify access permission and the group 'staff' have full control. Being new to this, I am a little confused as to how to do it. I have looked into it online, but it is not clear.
Could anyone help me please?
-- modified at 16:56 Tuesday 6th November, 2007
|
|
|
|
|
Hi Everyone,
I wondered if anyone could help me. I am baffled with this one. I am trying to allocate permissions on folders within my program. I am aliasing Imports Microsoft.Win32.security. When I do, I just get the error: Namespace or type 'security' for the Imports 'Microsoft.Win32.security' cannot be found.
Any ideas?
Many thanks.
|
|
|
|
|
Have you added the reference to the appropriate assembly. (Right click on the project in the solution explorer and select "Add Reference..." and pick the assembly from the list in the first tab)
|
|
|
|
|
Found it, just as you suggested it. Thank You 
Not used to VB.Net Environment.
Many thanks.
|
|
|
|
|
chrischome wrote: Found it, just as you suggested it. Thank You
You're welcome.
|
|
|
|
|
I have a Windows Forms Project with a form that has a DataGridView with 15 columns. Depending upon criteria when the user navigates to the form, some of the columns are hidden. Some of the columns are defined at design time, and some of the columns are added via connecting the DataGridView to a datasource in the page load event. After loading the DataTable that is the DataSource to the grid, I set the DisplayIndex of each DataGridViewColumn to the order I want them to appear in. However, when the screen loads, they are still not in that order. I have added code to make the DisplayIndex appear in the column header text, and it goes
0, 2, 4, 3, 5 ...
Column 1 in this case was not visible, which was correct...but why isn't it
0, 2, 3, 4, 5 ...
I tried NOT hiding the columns I want to make invisible and that didn't fix it. I made sure I'm setting the DisplayIndex for all of the columns and that didn't fix it. I'm out of ideas. What other settings are involved with reordering the columns on a DataGridView? Or what other settings could interfere with this? I would appreciate any help or advice.
|
|
|
|
|
hi,
how detecting headset mic plugged in to computer?
|
|
|
|
|
can't. The only possible way is to detect input on the mic, you can't just tell it is there.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
