|
Dear Friends
how can i iterate through a subset of a datatable in vb.net. Following code is an eg which does not seems to work.
Dim MonthlyDT As DataTable
MonthlyDT = NewMonthlyReportData.MonthlyReportDataTable 'Class Object
Dim MyDataRow As DataRow
'Parent DataTable with Filtering
MonthlyDT.DefaultView.RowFilter = "[MYID]<=716100"
'Set the Clone to be of Parent table
Dim MonthlyDTClone As DataTable = MonthlyDT.Clone()
For Each MyDataRow In MonthlyDTClone.Rows
Select Case MyDataRow("Classification").ToString
Case "Classification1"
Classification1 += 1
Case "Classification2"
Classification2 += 1
Case "Classification3"
Classification3 += 1
End Select
Next
Your help.
|
|
|
|
|
What does 'does not work' mean ? Do you get Id's above 716100 ? Why is the id in [] ? That is not required.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Sorry for the trouble guys, I have sorted the Filtering problem as follow, but now have the issue of filtering the correct subset based on the month and year value of MemDateAdded (datetime field). Following code does not filter the data instead returns the entire records in the datatable. But if I use any other filtering instead of Date, it works perfectly eg. (STATE='VIC').
MyTableDataRows = MonthlyDT.Select(("Month(MemDateAdded)" = 12 & " AND Year(MemDateAdded)" = 2008)) 'Monthly Total Only
For Each dr As DataRow In MyTableDataRows
Select Case dr("Classification").ToString
Case "Classification1"
Classification1 += 1
Case "Classification2"
Classification2 += 1
Case "Classification3"
Classification3 += 1
End Select
Next
I want to iterate the subset of datatable based on user selected month and year passing to MemDateAdded. User month and year will come from a DateTime Picker control. Basically I want to sum different Classifications and passed them to the variables, which I want to use later on other applications like Excel for poking.
Your URGENT help on this....
|
|
|
|
|
Galle Guy wrote: ("Month(MemDateAdded)" = 12 & " AND Year(MemDateAdded)" = 2008)
what is this??
When not sorting Select() expects a single string, and your selection doesn't use variables, hence put double quotes at both ends, not inside the string and forget about ampersands.
|
|
|
|
|
what are you trying to do?
well, its early in the morning, but some notices to your code:
MonthlyDT.DefaultView.RowFilter = "[MYID]<=716100"
this line is useless in your context. you are filtering the view but later on,
you iterate the underlying datatable
Dim MonthlyDTClone As DataTable = MonthlyDT.Clone()
also useless. you clone the original datatable and iterate it. the method clone()
clones the schema and constraints NO data. use copy if you would like a "copy".
i just can think of what you will do:
Dim dtMonthly As DataTable = NewMonthlyReportData.MonthlyReportDataTable
Dim dvMonthly As DataView = dtMonthly.DataView
'filter wanted data
dvMonthly.RowFilter = "[MYID]<=716100"
'iterate the resulting data
For Each drvMonthly As DataRowView In dvMonthly
Select Case drvMonthly ("Classification").ToString
Case "Classification1"
Classification1 += 1
Case "Classification2"
Classification2 += 1
Case "Classification3"
Classification3 += 1
End Select
Next
|
|
|
|
|
Filtering the data should also eliminate the need for a copy unless you have a specific need for that.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
How to Change Drive later of disk?? It Possible Please Help me??
For Example I want to Change the drive name D to
Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com
|
|
|
|
|
Were you asking in the wrong forum before, or are you still hoping to do this in ASP.NET ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
No, he's just hoping that someone will tell him it is possible, he doesn't want to accept the truth
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Well, it sure seems likely.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Let's just say that if you changed the drive letter of the System or Boot partitions, either Windows, or any installed apps would no longer work.
Check out the code in this[^] article. Have fun crashing your system!
|
|
|
|
|
Hello all
Does anybody know how to access the "Save As Text" in FF programmatically?
Thank you in advance
Chandra
|
|
|
|
|
Firefox is a nightmare when it comes to emulating through programming (I know from experience). I would abandon all hope of using firefox programmatically and look into finding another solution.
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my Blog
|
|
|
|
|
Hi
Thanks for your reply...
What was your experience working with FF? Did you get anywhere? Maybe if you could give me some pointers, I could go along that path... even though it is not what you recommend. Right now, this seems to be the only solution I have, unfortunately 
Chandra
|
|
|
|
|
The aspect that I was trying to alter was the proxy settings for a network. I tried keyboard emulation by first starting the process with System.Diagnostics.Process class and then sending keystrokes to it through the said class. Mozilla does not work well with this method at all; I could not send text to the address bar and could not navigate between windows/frames. To get around this I had to find the configuration file where everything is stored which is located in a particular place for a profile.
This link should be able to help you: http://www.vbforums.com/showthread.php?t=532442
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my Blog
|
|
|
|
|
Thank you - I have been trying something like this too...
|
|
|
|
|
I'm a senior at Montour High School and we have to do projects in order to graduate. My project is to create a phone book and have it store contact information. Ive been contemplating different ways of doing this and i tried using strict txt files but thats very insecure. So my question is how do i go about using or creating a database to store this information (all in all there are aprox. 16 fields)
i know how to get the information from the fields and i know how to set he information in the fields. if more information is needed please ask.
Thanks
|
|
|
|
|
You can use MS-Access as the database engine to store the data and write the application in Visual Basic to access the data.
|
|
|
|
|
Ask your instructor if there are any limitations. Sometimes the DB is dictated/limited by the instructor.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
You can use SQL Express, its free and much better than Access.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I second that. There are times I wish Access would be a legacy product...
|
|
|
|
|
Mika Wendelius wrote: There are times I wish Access would be a legacy product...
Same here, and I am sure eventually (hopefully soon), it will truly be a legacy system people will steer away from
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
That is how I regard it these days.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I agree.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Better in what sense?
For developers/programmers SQL Server is, more often than not, a better solution.
For someone like the secretary to the local cricket (or baseball) club Access is a good solution. It's completely self-contained i.e provides forms, reports, easy set up of tables and relationships and you don't need to develop a WinForms front-end.
What more could you want if you are not a developer?
I once heard a developer loudly pontificating on databases to the effect that if it isn't Oracle it's not a real database. Can you imagine a local club investing in Oracle to keep member details for a couple of hundred people?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
