|
:(Hi, I am really struggling to figure out how to add the values in a datagrid column named "Category Ratio". I don't want the "Category Ratio" column total to be less than or higher than 100(it is functioning as a percentage column) and I therefore need to check that the user has set the colun values for each row to add up to 100. Can anybody tell me how to add up the column values. The column is the second column in the datagrid. column 1 = "Category Name" column 2 = "Category Ratio". Thanks
Mr Oizo
|
|
|
|
|
Hi,
Adding the values up is not that difficult, just loop through the rows in the dataset or datatable (not the datagridview) and add up the values. Something like this:
<br />
Dim rw as DataRow<br />
Dim i as Integer 'or double or whatever<br />
For each rw in YourDataSet1.Tables("YourTableName").Rows<br />
If IsDbNull(rw.Item("Category Ratio")) = True Then<br />
i += 0<br />
Else<br />
i += rw.Item("Category Ratio")<br />
End If<br />
Next<br />
What you really need to think about though, is how you want your app to react when the rows do not add up to 100 percent: throw a simple MessageBox and let the user calculate it in his head, reset all values to 100 divided by the number of rows, adjust all values equally, adjust only all values or some, or only one according to certain logic?
Good luck,
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
 HI..
pls help me to get the system time.. vb.net..
chamil
|
|
|
|
|
i dont know if pocket pc really applies to what you want....meaning compact framework right?
otherwise, i think with a datetimepicker and a timer control's tick method you can get the timer at every tick even to millisecond
just check the interval property of the tmer control
phatkin
|
|
|
|
|
thanks for the qucik reply..
actualy the thing is i want to extract the time from system..
then later i can convert it to milliseconds anyhow..
the thing is i don't know trhe codings to get the thing..
thanks
regards
chamil
|
|
|
|
|
ok add a timer control say timer1 to your project
add a datetime picker also
set the timer interval to 1 ( maybe )
on your form load you can put something like
then go to its start method thus
timer1.start (byval......) {
//label to display time on
label3.text=date.now.millisecond
//view the other methods of the date.now, to get what you want
}
phatkin
|
|
|
|
|
Using a timer with an interval less than 15 is pretty pointless. The resolution of the system clock is not higher than that, and also the screen is not updated more often than that.
---
single minded; short sighted; long gone;
|
|
|
|
|
Hi,
I don't know about PocketPC/Compact Framework, but most approaches that express
time in milliseconds don't have that resolution at all (i.e. the value increments
by 20 or more at once).
You may want to read my "timers" article.
Luc Pattyn [Forum Guidelines] [My Articles]
this weeks tips:
- make Visual display line numbers: Tools/Options/TextEditor/...
- show exceptions with ToString() to see all information
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
You can't get the system time in milliseconds, because the system clock doesn't have that resolution.
You can use the DateTime.Now property to get the system time. A DataTime value has resolution down to 1/10000 second, so you can display it as milliseconds if you like, although the system clock doesn't have that resolution.
---
single minded; short sighted; long gone;
|
|
|
|
|
Hi,
I would like to know how to create a file at a specified URL and want to attach that file to an email using vb.net.
thanks
RB
|
|
|
|
|
i think you first of have have to have your file url as a string var then
you create a new io.fileinfo object, give it the url you want
then you call the create method
try that
phatkin
|
|
|
|
|
I don't get it. Would you please show me some sample code?
Thanks in advance
RB
|
|
|
|
|
ok
dim s as string="c:\myfilelocation.txt"
dim finfo as new io.fileinfo(s)
finfo.create
thats all
got it now
phatkin
|
|
|
|
|
i have an lan where i can get all the computer names unto a certain treeview
actually i want to be able to get their informations like ip addresses using iphostentry by selecting that particular node
i get the text correctly representing the machine name on the network and i do something like this
dim ip as new iphostentry
ip=dns.gethostentry(treeview1.selectednode.text)
dim compip as string=ip.addresslist(0)
Actually i get an error saying that "HOST UNKNOW", NO SUCH HOST EXISTS"
Any help?.Thanks
phatkin
|
|
|
|
|
You probably have to supply the full DNS name, not just the machine name. Like this: someComputer.myCompany.com. This, of course, depends on your DNS, or Active Directory if you have it, structure.
|
|
|
|
|
I am developing an application in VB.NET on the .NET framework v2.0, that consists of 2 parts. The client part, which is installed on the Client pc and the server part which is installed on the server (obviously)
The client part consists of a form containing a menuStrip, ToolStrip and an Explorer bar, all of which have no options as they are added to each of the controls at run-time, from an XML configurarion file located on the server. The server install also includes all the DLL that contain the Business logic. The client app connects to the DLLs ,on the server, using late binding.
All is working well when running locally on my PC, but as soon as I but the server part of the app onto my testing server, the .NET Framework security kicks in and stops the app from loading the DLLs from the server.
I would be grateful for any assistance on how to resolve this problem.
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'
|
|
|
|
|
It doesn't work because in the .NET Framework, code running from a non-local source (i.e.: Network) is not trusted. Read up on Code Access Security[^] to learn about how to control trusting foreign sources.
|
|
|
|
|
Hey I was wondering if anyone can help me?
I want to export data from VB 6 to an excel spreadsheet.
Any Help?
Cheers
|
|
|
|
|
A little Google goes a long way[^]. There's plenty of examples out on the web. All you have to do is a little searching.
|
|
|
|
|
I am assuming everyone...well most everyone here knows what datagridview looks like. On the control to the very left, there is something like a column that has an arrow type symbol in it and whenever a row is selected, that symbol is at the beginning of the row. I think it's called something like a row selector or something. Anyway, I was wondering what it is and how to get rid of it if possible.
|
|
|
|
|
I think it is Rowheader and there is some properties in datagridview property .
|
|
|
|
|
Yep, that was it, thanks enmahdi
|
|
|
|
|
I want to get tables Name in a Access (mdb) file and my quary is
"select * from msysobject where type = 1 and flags = 0"
but the exeption with the text " Records can not be read ; no permision on'msysobjects'"
has happend
please help me about this problem .
|
|
|
|
|
hi,
use following code
here cnn is connection object
Dim Schema As DataTable = cnn.GetOleDbSchemaTable _<br />
(OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"})<br />
<br />
For Each row As DataRow In Schema.Rows<br />
If Not row.Item(2).ToString.StartsWith("~") Then<br />
Me.ComboBox1.Items.Add(row.Item(2).ToString)<br />
End If<br />
Next
hope this helps
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
My Company
|
|
|
|
|
Hi,
I imported the data into excel. For this purpose I have added a micorosoft.excel com file as a reference and imported Microsoft.Office.Interop
The problem is while run the exe in the target machine, it is showing an
error, It couldn't find the file "Microsoft.office.Interop."
Please advise me.
Ahamed Azeem
Software Programmer
Saudi Postal Technologies – Riyadh
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
