example:
-- euro --
21
43
44
45
so if i count all i get 153 euro.
i already got this
Code:
for (int i = 0; i < dataGridView26.RowCount; i++)
{
label34.Text = i.ToString();
14 results in 0.0041 seconds.
-
sword117 started a topic How to count all the rows in a column? using microsoft access 2000 databasein C SharpHow to count all the rows in a column? using microsoft access 2000 database
i want to count all the rows values in a column,
example:
-- euro --
21
43
44
45
so if i count all i get 153 euro.
i already got this
... -
How to import an Excel Spreadsheet without specific column(s)?
Hi All,
I am using the following code to import a spreadsheet into my Access 2003 tblWeekly table:
The strOutFile contains the path and file name of the spreadsheet. The "impData" is the range that contains the data I need to import. It is a fluid range (changes from week to week)....Code:DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "tblweekly", strOutFile, True, "impData"
-
Checkbox Column In Datagrid
When we add a customized checkbox column to a datagrid in .net (windows application) , the default property allows to check or uncheck the column using a double click. On the first click it selects the column and on the second click the column is either checked or unchecked.
To change this default property, we need to handle the click event on grid and modify the selected cell value.
Eliza -
Ormazd started a topic PERL script that prints out the file names and file sizes and determines the averagein PerlPERL script that prints out the file names and file sizes and determines the average
Hello,
I was wondering if anyone might be able to help me with a little PERL script? I'm very new and I have been given a task to write a simple Perl script that prints out the file names and file sizes and determines the average file size from the directory listing found in the "files.txt" file. In other words, I need to add up the size of all of the files listed in the text document and divide by the number of files listed.... -
separate user table with user settings?
I'm wondering if its a good idea to separate the user information (name, pass, age ...) and the users settings (notifications, themes ...)?
I guess the real question is if its bad practice to have a lot of columns in one table or if its actually faster? One obvious reason not to have them in the same table is if you want to have dynamic settings which require one insert for each setting but I'm not gonna do that right now. -
Hide column through VBA
How do I hide columns in a split form through VBA? I tried this:
but i have to close the form and open it again to see the change. Nor does adding this help.Code:Me.Controls("field").ColumnHidden = True
Any ideas?Code:Me.Requery Me.Refresh Me.Repaint
Thank you in advance. -
How to properly set a value on a multi-column combobox
Hi,
I'm having issues setting a multi-column combobox in the right way.
What I'm trying to do is that when I click on a table (access 2007 subform), a form should fill with the values of the record I clicked on.
No problem until I have to fill correctly a multi-column combo for 2 reasons:
- In the table I only have the value of one of the 2 columns (That can be solved if I query again one... -
How Access reads data stored in SQL Server
I guess my real question is how is data stored in SQL Server... I have a linked table in Access that I'm using ADO Recordsets in VBA to move to the last record. The code works fine, but I'm not getting the "correct" results.
Sample table:
...Code:ID Serial# Date --- ------- ------- 1 A123 08/21/09 2 S901 08/24/09 3 F789 08/23/09
-
using union, temp columns, in a SQL based search string
Trying to wrap my head around how a good SQL search string would work. I have three tables (two in the example below for learning) with different column names (but similar data.) I'm using aliases to make uniform columns. I can get all the matching rows from the different tables, but I need to know what table the row came from for the results to be actually useful (linking, etc)
How can I ADD a completely fabricated column to my result... -
compare columns
I have 1 file that I need to compare two columns and count how many account names (column1 ie jollywg) do not have a /home directory with that name (column 6 ie /home/jollywg). The file name is /etc/passwd...how can I do this!!...i've been scouring the internet for hours and have come up with nothing.
Thanks in advance!
Jollywg -
Add a new DataTable column with type "Integer"?
I have a dataview, and I am trying to "clone" its structure only in part, by creating a new table via code. I cut out most of the columns, so this is easier to read. My question is - Why does this always seem to add things a a string?
Later in my code, I try to sort based on "View_Order ", but it acts like a string. The values sort as 1,2,20,21,22,3, 4, NOT 1,2,3,4,20,21,2 2 like it should.
Using Cint()... -
Adding bitmap to colum other than the first in a ListView
How can I do this? This question has been asked so many times on other forums without an answer, so I am not hopeful. OAKview has been suggested but it doesn't work, so please don't suggest that. I would like to know how to do it myself anyway, rather than use someone else's control.
I would to add an image to the second column of a listview, it seems to only allow an image to be associated with an item rather than a subitem, though.... -
Extracting data from text file from different lines
Hi
I am confused about how to go about writing this program in perl.
I have a text file with data in columns 8 and 9. I need to extract the data value from column 8 from the line being read and then extract the data value in column 9 from the next line. This needs to be repeated for all lines in the file. So, i would be taking data from column 8 from lines 1,3,5,7,ect and column 9 from lines 2,4,6,8..... I need to move... -
Round entire column
Hello there,
In a table, with a field which type is float (lets say MYFLOAT from MYTABLE) I have this value
6.0949997901916 504
It it a value that was imported from an excel sheet.
when I usethe outcome is correctCode:SELECT ROUND(6.0949997901916504,3)
6.0950000000000 000
but when I usethe outcome is again 6.0949997901916 504!...Code:SELECT ROUND(MYFLOAT,3) FROM MYTABLE
