I am currently using a recursive search to get all of the files in a directory as well as in all subdirectories of that directory. At the moment (as a temporary solution to make sure the script worked) I have all files with their respective directories listed in a listview (2 separate columns).
View 3 RepliesDeclare some class level variables that will keep track of the sums for each column. For example:
[Code]....
During the RowDataBound event, retrieve the data from each column and add it to the appropriate sum. I'm not sure if you are developing an ASP.NET application or a Win-forms desktop application so I cannot help you any further at this point. What have you tried so far to solve the problem?
I have the below Linq query that is returning the data but I need to aggregate the columns to group on the Period and Sum the Count columns. How do I go about doing this?
LINQ
from t In tblTimes
join h In tblEngineeringDashboard_CADMachinesCounts on t.ID Equals h.TimeID
Order By t.Period
[code].....
I am retrieving the data from AD and sending it to th CSV file. but the data is not coming in Column1,column2 and Column3. Can you guys help me with formatting.[code]When i export the data to Excel the 3 fields i am retrieving are merged. Can you guys help me on how to get the data into excel with individual columns?
View 4 RepliesI need to split an Arraylist into individual columns, here is an example of a column in the arraylist:
John Doe - John.Doe@email.com
I want to split up the arraylist so I can use the name and the email address in an email routine i.e. Dear John Doe, yada yada
I need a few columns in my datagridview to have the font be aligned to the right, but no matter what code I use it doesnt work.
I would also like my columns with numbers to always have 2 decimals.
And lastly I would like the right side of the column header to be blank and not movable. I can do this by adding another column to my table with a blank name and then set the width to fill, but the problem is I can just move this around, which is not good, I want to freeze it so it looks good. I do want to be able to move around on the other columns, just not this one. Unless there is another way to do that?
How do we set width of individual columns in data grid ?
View 4 RepliesI have a listview that I add items to by loading from a file, and that works fine. I then edit the items or add new ones, and on form dispose, the file is supposed to be saved containing the listview items, but when I step through this process, mylistview.items.count is said to be zero, which I know is not true because I can see the items right on my screen, I added them myself.[code]I use this same method for saving and loading to and from listboxes, and it works fine.
View 3 RepliesI'm trying to set something up where the user can sort each column by clicking on the header... i've looked at some other examples and they seem pretty longwinded..so far i have the below...
VB
Private Sub resultsListView_ColumnClick(ByVal sender As Object, ByVal e As System.Windows.Forms.ColumnClickEventArgs) Handles resultsListView.ColumnClick
Dim oldsort As SortOrder
[code]....
which works fine... but only for the first column in the list view.Is there a way of specifying which column to sort based on which is clicked?
I need to loop inside listview and its columns Sub Items. I'm currently using this.
For Each item As ListViewItem In ListView1.Items
For Each si As ListViewItem.ListViewSubItem In item.SubItems
Next
Next
But it over loops on the items causing the code to produce incorrect tasks.
Problem: I need a way to have individual notes for all the items in a listview. Tools: 1 Listview, 1 button and 1 Textbox.I would like to click an item and have notes for that item pulled from the settings.When the button is pressed I want the notes for the item to be saved in the settings.
View 6 RepliesI have a ListView with the columns 'Name', 'Expected', 'Total', and I want to add another column saying 'Recount' at the end. The 'Recount' column will ideally have a checkbox only if the 'Expected' value is larger than the 'Total' value.
So far I have got the ListView with columns and can add a check box on the left hand side, but that check box is not under a column heading (though I can probably put another column with no values in there to work around that) and it is on all of the records.
I would like to know if it is possible if the columns of the listview can be resized automatically based on the information in the listview?
View 4 RepliesTextboxes are arranged in a 5x5 matrix and each text box is only restricted to either a "1" or "0" input. I need help in the code that will count all 1's in each row and column. Since this is a 5x5 arrangement, there are 5 rows and 5 columns each. I am actually making a simulation of a VRC/LRC program. There will be 2 buttons namely "Even/Odd Parity". If user presses Even parity and the number of 1's in that specific row/column is Even, the result will be a 0,If odd the result is 1. There is a result textbox at the end of each row/column.
View 1 Repliesi have a DataGridView bound to a table that has 22 fields in it. In the datagridview columns, the first 2 have the visible property set to false and the last 7 also set to false. This works since there are 13 columns displayed in the datagridview when the program runs. Here's where my issue come in. When I do the following, Console.WriteLine("Column count = " & DataGridView1.Columns.Count.ToString()), I get the expected "Column count = 22 in the output. However, when I do Console.WriteLine("Visible = " & DataGridView1.Columns.GetColumnCount(DataGridViewElementStates.Visible)), I get 20 instead of the expected 13 that actually have the property set to visible.
[Code]...
im wondering which way may be better to find out the number of cols for a row:
1) row.Table.Columns then count
2) row.ItemArray then count
3) am i missing something, is there a much more "direct" way to do it?
I am trying to figure the best way to programmatically re-size table column headers in ReportViewer.Basically, my current resolution is the following: ColumnWidth = Header Caption_CharacterCount * 0.32...Where 0.32 is an estimated width of a typical character using my current font size.The issue is that the width leaves a lot of whitespace for longer captions.The more characters a caption has, the more whitespace I end up with.The issue with estimating this way is that not all characters are the same width. A good example would the the "I" character, which takes up less screen width than the rest of the alphabet.[code]
View 1 Repliesim usinf Gembox to read Excel files.I'm copying the fields to a datatable, so i have to add the columns to the datatable first.
Therefor im using this code:
For i As Integer = 0 To objWorksheet.Columns.Count - 1
objDataTable.Columns.Add(i, GetType(ExcelCell))
Next
But objWorksheet.Columns.Count is 0 even if theres data in 4 columns.
i have a listview box full of items, image below:
when i click a button i would like a msgbox to pop up displaying how many are alive.
How would i do this ?
Also how would i remove all items that status is "Dead"
In the previous reply, you showed how to open a CSV in Excel. How does one determine the number of rows and columns that were imported?
View 1 RepliesSo I have a code atm that has 2 combo boxes, one to select the make, then it will enable the model, I have 3 model choices, here's code: [code] Once I have selected my model of the car, it takes me to that specific form with a picture of that model, I then want to display individual parts, with individual prices that will add up in a text box above.
View 2 RepliesI was wondering how you could have a label keep the number count on the number of rows on a listview?
View 14 RepliesHow can I count the number of items in the listview.
Example scenario.
Today, I added students say, 20 students and tomorrow I added another 15 students, i need to have a breakdown on how many students i have been adding per day.
I'm having problems with adding columns to listview. [code]....
View 1 RepliesWin XP, VS 2008, .NET 2.0
When I use Count property to count checked items in ListView (set to detail view with check boxes), sometimes i get NullReferenceException on count part. Sometimes I get it but sometimes I don't get it... It's very randomly and I can not reproduce it always?
[Code]......
I am working on my first project with the Entity Framework and am having some difficulty displaying advanced information with the EntityDataSource and a ListView.
For example, given the two entities:
Item
Name
[code].....
I am working on my listview as I want to count how many checkboxes that I have ticked and unticked on my listview. Please can you tell me how I could do this?
If you do know how I could do this in simple way, I would be very grateful if you could tell me how I could do this.
how to add information in to a listview with information from a dss. So far i have managed to get all the information from SQL and now im just in the process of populating the listview.
Im aware i could use a datasouce for this but i want to learn it this way
So heres my code
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim retrieve As New GlobalFunctions
[Code]...
It doesnt throw an error it finishes loading and then presents with me a listview with a vertical scroll bar but with an empty screen....i think i may have got things a bit muddled up
I am having trouble adding items to individual columns. When I do the following[code]....
Everything gets added to the first column instead of the assigned column.
I have seven columns in a table Customer (custId, Date, AccountCode, Description, Quantity, Price, Amount)Also i have seven textboxes on the form from where data is transferred to the Listview. Listview has all seven columns from where data is to be transferred to the seven columns of Table Customer.I want that data should be transferred to all the seven columns of LIstview but Listview should display only last four columns and hide first three columns to display. In otherwords user may be able to see only the last four columns in Listview.
View 2 Replies