|
cstrader232 wrote: Does it make sense to do data analysis on a datagridview
What kind of data analysis are you speaking of?
"I've seen more information on a frickin' sticky note!" - Dave Kreskowiak
|
|
|
|
|
Hi. Thanks for your reply. Here's the postcard version, as expanded from the sticky.
This is not so much an issue of can I do it? but can I do it fast?
I have data on several thousand stocks which are downloaded every day. They are persisted on the disk in some format, each in its own file (several thousand files). Each file has a matrix of some string and some double and some integer values. The matrix is say 500 rows by 10 columns in each file, each row representing one date.
I need to, for each file
1. Open and read the matrix
2. Sort the matrix by date and select the dates I want
3. Calculate new values in new columns (say a moving average or a sum or difference)
4. Output the result
5. Close and move to the next file
My benchmark is c++ programs that seem to be able to do this really, really fast.
So what format should I store the files in?
Text? (small, but need to be read line by line)
Xml? (much bigger, but can be read into a dataset in one XMLread)
Serialized object array? (maybe, but how to filter the data by date?)
Data structure?
Other?
My strategy has been to
1. Store as XML datatable and read from that datatable
2. Create a dataviewer to sort and filter
3. Perform my calculations on the datagridview created from the dataview
This works, but I need to go faster. Would a data structure be appropriate? I could serialize an object array, but then how to filter it by date? SQL or ODBC didn’t seem like they would be useful.
Thanks again
|
|
|
|
|
Is there any reason why the stocks data is downloaded into a file rather than into a database table?
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Yes, interesting idea (I'm assuming you mean combine all of the 2000 individual files into one single dataset)
One problem is that the resulting dataset is huge.
Here is the issue:
The textfiles are about 25K each times 2000 files = 50,000. Not a problem
Turn each of those textfiles into a datatable, each datatable is now 200KB!
200 * 2000 = 40M
OK that can be done, but seems really wasteful, and takes a long time to read it.
So really I'm looking for an alternative that doesn't require datatables at all. Until I get an alternative, I'm tempted to just say with the textfiles themselves.
BTW object arrays serialize to a size that's somewhat bigger than the original textfiles, but not much (about 37K each)
|
|
|
|
|
How can I put code on the close[x] button of the messagebox?
|
|
|
|
|
MessageBox.Show() returns a DialogResult value, which depends on how it got closed.
There is a value for each possible Button, and IIRC the Cancel value is also returned
when the Close Box is clicked (check it!).
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
Abbhie wrote: How can I put code on the close[x] button of the messagebox?
You can't. However, you could always create a custom messagebox control.
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
Hi Abbhie
its Simple
Double click your Form. and looking for the Closing Event of the form. and Put the following code.
if(Messagebox.Show("Do you want to Exit?","Question")= vbyes then
me.Close
else
Me.Cancel
end if.
Try this, hope it helps
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Hi All,
I want to create a Wi-Fi Monitoring and Detection System using .Net 2.0.
1. It will detect any wireless computer coming in the range of access point….
2. It will then authenticate the detected ones by assigning them network parameters
3. It will then monitor the wireless computers by using SNMP protocol
Is there sdk present for that or any API available in .net. I have worked LAN Monitoring System, but i don't know how to monitor Wi- Fi devices.
Can anyone please help me out?
Thanx in advance.
__________________
Paramhans Dubey.
|
|
|
|
|
Yeah, you are not going to find any articles about that anywhere on the web. If you do I would love to read it as well.
Pete Soheil
DigiOz Multimedia
http://www.digioz.com
|
|
|
|
|
That ALMOST sounds illegal. May I ask what you are monitoring? Please don't lie and say something like your kid or for just for the sake of knowledge. It really sounds like your trying to steal sensitive material ie. credit card#, s.s., ect. But you may have a totaly valid explanation for wanting to know that kind of code and I would like to hear it.
|
|
|
|
|
Hi mykingdomforanewusername
I dont know why do you think I m trying to do any illegal thing or I m trying to steal any sensitive material. As i have mentioned earlier I m a Software Developer and I have designed a LAN Monitoring System and I now want to design a Wireless Network Monitoring System. I dont have any illegal things in my mind. I just dont know how to do it thats why I asked for help in this forum. I would appreciate any kind of help if u can.
Regards
Paramhans Dubey.
|
|
|
|
|
i think i know what you are tlaking about my toshiba laptop has something like that it is called "config Free" if that is it
|
|
|
|
|
Hi,
I m working in VB6 Application, in that application I have added more then one column string table. But i dont know how to access them?
Can any one help me out!
Thanx in advance.....
birajendu
CyberG India
Delhi
India
|
|
|
|
|
hi,
how can i apply xml comments in vb.net like we r giving in c# (///) for xml comments, please answer this.
thanks and regards
bikash pattanayak
|
|
|
|
|
Use 3 single quote marks together i.e. '''
Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
|
|
|
|
|
Almost the same...
use 3 apostrophies in a row - these are the comment markers in VB- '''
The rest will become evident. 
Too easy - Cam
|
|
|
|
|
In VB.NET for making statement a Comment you use '. If you are talking about to generate NDoc Documentation then you can install "VBCommenter" available at gotdotnet.com which is an add-in for Visual Studio .NET which can generate XML like comments but with ''' and can also generate NDoc file to generate MSDN like documentation.
Hope it helps !
AliAmjad(MCP)
First make it Run THEN make it Run Fast!
|
|
|
|
|
Hi Bikash,
We can apply Vb.Net comments in VB.Net in the following manner:
--------------------------------------------------------------------------------------------------
'''This is my method.
'''<remarks>This is remarks section
Sub myMethod()
End Sub
--------------------------------------------------------------------------------------------------
I hope this helps
Regards,
John Adams
ComponentOne LLC
|
|
|
|
|
How to link webservice (Server) to connect to PDA (Client)?
any source code? thanks
|
|
|
|
|
The concept is the same as using a webservice from a standard windows application, except that you will have to create a "Pocket PC" project to code the client.
What you have to do is to:
1. Create a Pocket PC Application Project.
2. Add a reference to the webservice you want to use.
3. Take advantage of the functions and routines available through that webservice.
A sample call for the client would be:
Imports Application1.WebService1
Public Class Form1
Private WebService1 As New WebService1.ClassName
Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
Dim resultAdd As Double = WebService1.AddNumbers(txtNum1.Text, txtNum2.Text)
lblResult.Text = resultAdd
End Sub
End Class
Pete Soheil
DigiOz Multimedia
http://www.digioz.com
|
|
|
|
|
I am in the process of writing a Button Bar control. The control inherits from the Windows.Forms.Panel but I only want to allow a Button to be added to control collection.
To achieve this I have written a ButtonCollection Class that inherits from Windows.Forms.Control.ControlCollection and shadowed the necessary method and properties to accept and return Buttons.
To the Button Bar class I have added a read only Property called Buttons that returns the ButtonCollection.
The problem I am currently having, is that when I now add a Button in design mode, using the Button property, I get the error message "'Child' is not a child of this parent"
This error is caused when the Paint event of the control fires :-
Private Sub ButtonBar_Paint(ByVal sender As Object, ByVal e As System.Windows.Forms.PaintEventArgs) Handles Me.Paint<br />
Me.Controls.Clear()<br />
For Each oButton As Infragistics.Win.Misc.UltraButton In Buttons.List<br />
Me.Controls.Add(oButton)<br />
Next<br />
End Sub
Any help here, greatly appreciated.
Thanks
Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
|
|
|
|
|
Are you still having trouble?
"I've seen more information on a frickin' sticky note!" - Dave Kreskowiak
|
|
|
|
|
Asalam-O-Alikum!
how to add and modify any string in app.config file using ConfigrationManager
BasharatAli
Internee
METESYS Lahore
Pakistan
|
|
|
|
|
Walaikum-Asalaam!
You can use ConfigrationManager's OpenExeConfiguration Method which returns a Configuration object use this object to manipulate your configuration file. As it is a shared Member you can access it without instantiating the ConfigrationManger Class.
For Example:
Dim Config as System.Configration.Configration = ConfigrationManager.OpenExeConfiguration(ConfigurationUserLevel.None)
Hope it helps !
AliAmjad(MCP)
First make it Run THEN make it Run Fast!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
