|
There's plenty of plugin articles here on CP.
Basically, you have to establish some sort of the common interface between the main code and the plugin. Usually, you'd base this in, of all things, an Interface, that each plugin would have to implement. This establishes what methods and properties the main code is going to expect each plugin to respond to. The same is true in the opposite direction.
|
|
|
|
|
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
|
|
|
|