vb
Dim CheckedRows = From dgv As DataGridViewRow In Me.DataGridView4.Rows _
Where dgv.Cells(0).Value = True _
Select New With {.a = dgv.Cells(1).Value, .b = dgv.Cells(2).Value}
my code above works fine but how to get the index of the row on which the checkbox is checked
If I use a LINQ query over some type of collection, is there any way to know the initial index of an element of the result?
Purpose: I make a query to set as source of a DataGridView, and on a (button)cellclick event I want to a call a method that needs to reference the collection at the correct index.
I am using Sub to format datagridview but during Form_Load this error occur. There are rows in datasource and dg.row.count is > 0.
.Columns(0).Width = 50 <==== ERROR HERE
.Columns(1).Width = 150
.Columns(2).Width = 80
.Columns(0).HeaderText = "ID"
[code].....
I'm trying to set a background color for a row in my datagridview. Here is the code I'm using:
[Code]...
I have a column in a datagridview that is a combobox with 4 items in it. I can use this code to see the text value of the selected item:
View 2 RepliesProblem: Calling a method which uses a cell's value from a DataBound DataGridView. Works as desired without adding an image column.When I add the image column, the method attempts to use the value from column 1 instead of column 2, as the code in the 2nd method below ("findSign") states:
vb
Private Sub getAtmTOF()
Try
[code].....
I get an error on the last line of sub where I am trying to assign a combobox to a column which is a textbox.error:Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index[code]....
View 3 RepliesI've become undone when trying to convert xml linq query result to a datagridview (see code below), needing some pointers,.
Dim doc As XDocument
doc = XDocument.Load("C: empxmltest.xml")
Dim query = From c In doc.<quotefile>.<quote> _
[code].....
I am working in VB 2008 and I have set up a datagridview to display rows of data which can then be selected. When I select the first row I get the error: Index was out of range. Must be non-negative and less than the size of the collection. When I select any other row the program executes as it should. From what I have learned so far is that the DataGridView has an index of -1 and that it counts the header row as part of the index which is the -1.When I select the first row through either DataGridView1_RowHeaderMouseClick or DataGridView1_CellContentClick the index is 0 for the first record. If the index is 0 I think it would fire off, but I have no idea what is happening behind the scenes. I can check the index, so when it is 0 and the code attempts to access the row, that is when I get the message.On an index number of 1 and up the code executes fine.So, is there a way to re-index the DataGridView, or is there a work around/fix for this issue?
View 2 RepliesI currently have a program that uses Linq to read a CSV file. Everything was working great until a recent change was done where the CSV file had records being added to it where the last 2 columns where empty. So, the error I am getting now is Index was outside the bounds of the array. The question I have is how do I handle a column where an empty or null value is set in the CSV file?
Here's my abbreviated code below.
Function readLINQ(ByVal strCustomerFile As String) As DataTable
Dim readlines = File.ReadAllLines(strCustomerFile)
File.WriteAllLines(strCustomerFile, readlines.Skip(4).ToArray())
Dim gTable As New DataTable("CashFile")
With gTable
[Code] .....
I am trying to get an index of a List(Of Details) Details being a class i use instead of an annon method. Is it because i am using array.findindex when it's not an array but a list(Of???
Dim index As Integer = Array.FindIndex(Details, Details.FirstOrDefault(Function(nd) nd.Name = "name"))
Error1Data type(s) of the type parameter(s) in method 'Public Shared Function FindIndex(Of T)(array() As T, match As System.Predicate(Of T)) As Integer' cannot be inferred from these arguments. Specifying the data type(s) explicitly might correct this error.
I'm having trouble with VB LINQ syntax. I have a web service that is returning JSON to jQuery and I need the index of the items but can't figure it out. [code]...
View 1 RepliesI'm using a DataGridView to post the results of LINQ-from-SQL query. I was hoping that the data would be editable in the DataGridView, but it isn't. I made sure that DataGridView.readonly = false. I'm using VB.
VB 2008
DB = New CXToolDataContext()
Dim Systems = (From TBLSYSTEMS In DB.tblSystems, TBLSYSTYPES In DB.tblSystemTypes _
Where TBLSYSTEMS.ProjectName = projectnumber And TBLSYSTEMS.SystemType =
[Code]...
My LINQ query:
Dim groupedData = (From p In pData _
Group By p.TruncParam Into Group) _
.SelectMany(Function(g) g.Group) _
.Select(Function(d, idx) New With { _
[Code]...
When the TruncParam changes, I would like the index (idx) in the Select clause to reset to 1. So, in the list above, the Index should be SOLUB0001, SOLUB0002, INSOL0001, INSOL0002...CLRES0001, SUMCA0001, SUME0001.
How should I alter the LINQ query?
I need to sort a datatable. I do it with linq this an example
Dim query = From c In dt.AsEnumerable _
Order By c.Field(Of DateTime?)("LastPurchaseDate"), _
c.Field(Of String)("LastName") Descending
Dim dv As DataView = query.AsDataView
But my problem is that i need to sort the fields not by passing the name of the column but the index of that.
I've got the web browser with tabs in all working fine, but there's one bug, i can add tabs, delete em, etc.. but when i delete a tab then go to create a new tab, it gives me the error: InvalidArgument=Value of '6' is not valid for 'index'. Parameter name: index '6' is the number of tabs i had open.Here's the bit of code i use to create the tabs with the browser in it:
vbcode
Dim browse As New WebBrowser
browse.Name = "b1"
browse.Dock = DockStyle.Fill
[code]....
When the selected index changes I for a second time this code errors.
vb.net
lvReports.SelectedItems.Item(0).SubItems.Item(2).Text
with this error message
InvalidArgument=Value of '0' is not valid for 'index'. Parameter name: index
Why is this?It worked for the listviews.click event perfectly.
I'd normally do this in C# but since I've got to get this code in this particular assembly which is a vb.net one, I'm stuck.
Here's my linq query:
Dim i As Integer = 0
Dim oldAndCurrentIntersectionOnNames = From currentApplicant In currentApplicants _
Group Join oldApplicant In oldApplicants _
[CODE]...
You'll see the .Index = i+=1
This was my attempt to do what I'd quite happily do in C# (i.e. Index = i++) in VB. Unfortunately the VB compiler doesn't like that. how I'd do this in VB.
I have a DataGridView containing a large number of columns. I want the users to be able to select multiple columns and then select a menu item to hide the selected columns. For example a user might selected columns 5 through 10 and I want the program to hide those columns. I know how to hide columns, one at a time. I can get the count of selected columns but I have not figured out how to get the index to the left-most selected column. Trial and error is such a slow process.
Considering the huge number of options offered by the DataGridView tool, it would be nice if this forum had a special category for the DataGridView (common to VB and C#).
Finally I got the desired results but it took a lot of coding, looping through the selected cells to find the one with the lowest column index, then a second loop to count previously-hidden columns, then a third loop for hiding the selected columns, stepping past previously-hidden columns and declining to hide frozen columns.
Is there a way to force my application to ignore the index out of bounds error from the DataGridView? I have gone through from top to bottom and there is no reason why I should be receiving this error. No operations, rows, nor columns are affected by just continuing past the er
View 5 RepliesI have a datatable with 10 records linked to a datagridview. When I initially load the datagridview, row 0 in the datagridview = row 0 in the datatable - based purely on the order they load, and the datatable's default sort order. I then filter my datagridview and am left with 5 records. Is there a way of determining programatically, the actual datatable row number of a row displayed in a datagridview, considering that row 0 in the datagridview is now not necessarily row 0 in the datatable?
View 6 RepliesI am wondering in row in the datagridview, How can i show the row index in the row header?
View 1 RepliesIs that possible to get current Enumerator (...or iterator? Don't know which tern is the correct one) in a LINQ query ? For example, I try to create a XML output (via LINQ to XML) of all currently loaded assemblies. [code] is it possible to somehow get current "index" (counter?) from LINQ's Selects? I would like to use it in XML. [code]
View 1 RepliesI binded a datagridview with datasource, But its order was changed then I used Columns("ColumnName").DisplayIndex property to arrange the columns of DatagridView. Now I am exporting this DataGridView to Excel, All things are right but problem is about the column positioning, Columns in excel file are shown in wrong order (it shows order before I applied Columns("ColumnName").DisplayIndex property to arrange the columns of DatagridView). My question is that how I permanently change the Column index of DataGridView......?
Public Sub gererateReport(ByVal dg As DataGridView)
Dim oExcel As Excel.Application
Dim oBook As Excel.Workbook
Dim oSheet As Excel.Worksheet
Dim oMissing As Object = System.Reflection.Missing.Value
[Code] .....
I have a datagridview which I am populating of a database, scrollbars are disabled to allow for autoresize
I created a Scroll Event that causes me some issues:
1. I can scroll down only
2. To move from one row to the next I need to rotate the mouse-wheel up in between two rows - as if the row index isn't being updated
3. The procedure results in an error : Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
Public Sub grdScroll(ByVal sender As Object, ByVal e As ScrollEventArgs)
Dim RowIndex As Integer = grdAccountTypes.CurrentRow.Index + e.NewValue
' grdAccountTypes.CurrentRow.Index = grdAccountTypes.CurrentRow.Index + e.NewValue
grdAccountTypes(0, RowIndex).Selected = True
[Code] .....
I have datagridview with XSD as the binding source (i configured it with the smart tags). After build, the dgv change its columnIndex which surely result error of my code.
For example
columnIndex(0) = idEmployee (dataGridViewTextBoxColumn)
columnIndex(1) = name (dataGridViewTextBoxColumn)
columnIndex(2) = status (dataGridViewCheckBoxColumn)
suddenly, the columnIndex(2) moved into columnIndex(0)
I have a DataGridView, everything work fine except that when I delete a row from my binding DataTable I'm getting this error in my DataGridView:The following exception occurred in the DataGridView:System.IndexOutOfRangeException: Index o does not have a value.at System.Windows.Forms.CurrencyManager.get_Item(Int32 index)at System.Windows.Forms.DataGridViewDataConnection.GetError(Int32 rowIndex)To replace this default dialog please handle the DataError event.Why?
View 4 Repliescycle through the cell values of particular column in a datagridview. and if duplicates are found, display them in a message box.
Dim wacko As String
wacko = DataGridView1.Rows(0).Cells(1).Value
For m As Integer = 0 To DataGridView1.Rows.Count
[code]....
Now this is a very basic concept, but the problem is when the last row value is returned, i get an indexing error "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index" i tried to count-1, but that doesnt cover everything. And even easier, would be to set no duplicate allowed in the datatable itself. but i want to fill those particualr rows with color.
I am trying to sort a column in DGV as follows:
DataGridView8.Sort(DataGridView8.Columns(0), ListSortDirection.Ascending)
However, I want to use the name of the column and extract the index number in the first parameter of the Sort method. However this fails:
DataGridView8.Sort(DataGridView8.Columns("Date").Index, ListSortDirection.Ascending)
I can't seem to set the selected index or selected value of a DataGridView combobox when loading data from a database. My DGV has two combobox columns which are bound to datatables. The DGV itself is not bound initially. After adding a row, I select a value from each combobox which then populates the rest of the cells in the row. I'm using the EditingControlShowing event to add an eventhandler to catch the SelectedIndexChange of the combo boxes. This all works as needed. My issue comes when populating the DGV with saved data, I need to add the rows and set the selected index and/or selected value of each combo box. I've searched through various forums and articles for the last week with no luck.
I'm using VS2008 sp1, .NET 3.5 sp1 and SQL 2005 sp2 Express.
