This is a migrated thread and some comments may be shown as answers.

'RowIndex' is not a member of 'Telerik.winControls.UI.GridView.CellInfo'

7 Answers 136 Views

GridView

This is a migrated thread and some comments may be shown as answers.

Jesse asked on 16 Aug 2011, 11:40 AM

Then what is the counterpart of RowIndex?

I have a form with a GridView on it and it displays the data i want it to perfectly, However I want to bring up an Add/ Edit form using a context menu strip to edit or add a record to the database. To fill the form for the edit part I need to do something like this(actually works when using the standard Data Grid)

Private Sub EditToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles EditToolStripMenuItem.Click

Dim frm As New frmAddEdit

frm.GUID_User = Me.dgvUsers.Item(0, Me.dgvUsers.SelectedCells(0).RowIndex).Value.ToString()

frm.GUID_Group = Me.dgvUsers.Item(1, Me.dgvUsers.SelectedCells(0).RowIndex).Value.ToString()

frm.txtADName.Text = Me.dgvUsers.Item(2, Me.dgvUsers.SelectedCells(0).RowIndex).Value.ToString()

frm.txtUserName.Text = Me.dgvUsers.Item(3, Me.dgvUsers.SelectedCells(0).RowIndex).Value.ToString()

frm.txtEmail.Text = Me.dgvUsers.Item(4, Me.dgvUsers.SelectedCells(0).RowIndex).Value.ToString()

frm.txtLogin.Text = Me.dgvUsers.Item(5, Me.dgvUsers.SelectedCells(0).RowIndex).Value.ToString()

frm.txtPassword.Text = Me.dgvUsers.Item(6, Me.dgvUsers.SelectedCells(0).RowIndex).Value.ToString()

frm.txtTelNo.Text = Me.dgvUsers.Item(7, Me.dgvUsers.SelectedCells(0).RowIndex).Value.ToString()

frm.txtFax.Text = Me.dgvUsers.Item(8, Me.dgvUsers.SelectedCells(0).RowIndex).Value.ToString()

frm.cbActive.Checked = IIf(Me.dgvUsers.Item(9, Me.dgvUsers.SelectedCells(0).RowIndex).Value.ToString() = "True", True, False)

frm.GUID_Company = Me.dgvUsers.Item(10, Me.dgvUsers.SelectedCells(0).RowIndex).Value.ToString()

frm.cbLead.Checked = IIf(Me.dgvUsers.Item(11, Me.dgvUsers.SelectedCells(0).RowIndex).Value.ToString() = "True", True, False)

frm.cbSplit.Checked = IIf(Me.dgvUsers.Item(12, Me.dgvUsers.SelectedCells(0).RowIndex).Value.ToString() = "True", True, False)

frm.cbTelesales.Checked = IIf(Me.dgvUsers.Item(13, Me.dgvUsers.SelectedCells(0).RowIndex).Value.ToString() = "True", True, False)

frm.cboOffice.SelectedValue = Me.dgvUsers.Item(14, Me.dgvUsers.SelectedCells(0).RowIndex).Value.ToString()

frm.txtAddress.Text = Me.dgvUsers.Item(15, Me.dgvUsers.SelectedCells(0).RowIndex).Value.ToString()

frm.Text = "Edit User"

frm.ShowDialog()

End Sub

The Problem is that the Rad GridView doesn't recognize the RowIndex.

Can Anyone help me with a solution?
What is the Telerik Grid's counterpart to the standard DataGrid's RowIndex

7 Answers, 1 is accepted

answered on 18 Aug 2011, 09:43 AM

Martin

Thanks for the response, I tried that but I get an ArgumentOutOfRangeException.
Using the code you supplied modified:

Dim rowIndex As Integer = Me.dgvUsers.SelectedCells(0).RowInfo.Index

I get the above mentioned exception, It says the Index was out of range.Must be non-negative and less than the size of the collection.Parameter name: index.

I am very new to programming, As stated before I got this working using the standard visual studio controls.

I also tried dong the following

frm.GUID_User = Me.dgvUsers.SelectedCells(0).RowInfo.Index.ToString()

But this also throws the same exception.

Please Help

Regards

Jesse

answered on 23 Aug 2011, 08:54 AM

Hello Jesse,

Thank you for getting back to me.

I was not able to identify what causes the exception and I will need to check your code to investigate further. It is possible to experience the issue, because the SelectedCells collection is empty (e.g. you do not have selected cells in your grid). I would suggest checking whether the collection is empty, before executing this code. Here is a sample:

If Me.radGridView1.SelectedCells.Count > 0 Then

Dim index As Integer = Me.radGridView1.SelectedCells(0).RowInfo.Index

End If

I hope this helps. If you need further assistance, please do not hesitate to contact me.

All the best,
Martin Vasilev
the Telerik team

Thank you for being the most amazing .NET community! Your unfailing support is what helps us charge forward! We'd appreciate your vote for Telerik in this year's DevProConnections Awards. We are competing in mind-blowing 20 categories and every vote counts! VOTE for Telerik NOW >>

answered on 23 Aug 2011, 12:02 PM

Martin

Thanks again for your response, I tried the code you supplied in your last resply and that sorts out the argument out of range exception but i still cant seem to get the form populated the way I need it to be with data from a specific row of the GridView, So that I can edit that specific record which I will then save back to the Database. The Code I used in the first version of the program looked excactly like the code I posted when I started this thread. All I really need is a way to achieve the excact same effect using the Telerik GridView, Ill include all the VB code in a Code Block Below

Public Class Users

Private Sub Users_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Fill_Names()

End Sub

'Fills The Grid

Private Sub Fill_Names()

Dim conn As New System.Data.SqlClient.SqlConnection(DBCon)

Dim ds As New System.Data.DataSet()

Dim adapter As New System.Data.SqlClient.SqlDataAdapter()

Dim strWhere As String =

"SELECT dbo.tbl_USR_Names.GUID_User, dbo.tbl_USR_Names.GUID_Group, dbo.tbl_USR_Names.GUID_Company, dbo.tbl_USR_Names.vch_AD_Name, dbo.tbl_USR_Names.vch_UserName, dbo.tbl_USR_Names.vch_USR_Email, dbo.tbl_USR_Names.vch_Login, dbo.tbl_USR_Names.vch_PWD,dbo.tbl_USR_Names.vch_USR_Tel, dbo.tbl_USR_Names.vch_USR_Fax, dbo.tbl_USR_Names.bit_Active, dbo.tbl_USR_Names.bit_USR_GetLeads,dbo.tbl_USR_Names.bit_USR_GetSplit, dbo.tbl_USR_Names.bit_USR_IsTelesales, dbo.tbl_USR_Names.chr_Office, dbo.tbl_USR_Names.vch_Address,dbo.tbl_SYS_UserGroups.vch_GRP_Description, dbo.tbl_SYS_Company.vch_COM_Name FROM dbo.tbl_USR_Names WITH (nolock) INNER JOIN dbo.tbl_SYS_UserGroups WITH (nolock) ON dbo.tbl_USR_Names.GUID_Group = dbo.tbl_SYS_UserGroups.GUID_GROUP INNER JOIN dbo.tbl_SYS_Company WITH (nolock) ON dbo.tbl_USR_Names.GUID_Company = dbo.tbl_SYS_Company.GUID_Company ORDER BY dbo.tbl_USR_Names.vch_UserName"

adapter.SelectCommand = New System.Data.SqlClient.SqlCommand(strWhere, conn)

adapter.SelectCommand.CommandTimeout = 1000

adapter.Fill(ds, "ProTrack Users")

Me.dgvUsers.SuspendLayout()

Me.dgvUsers.BestFitColumns()

Me.dgvUsers.DataSource = ds.Tables(0)

Me.dgvUsers.Columns(0).IsVisible = False

Me.dgvUsers.Columns(1).IsVisible = False

Me.dgvUsers.Columns(2).IsVisible = False

Me.dgvUsers.ResumeLayout()

conn.Close()

conn.Dispose()

End Sub

'Brings up a from to add a new user

Private Sub AddToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles AddToolStripMenuItem.Click

Dim frm As New frmAddEdit

frm.Text = "Add New User"

frm.ShowDialog()

End Sub

'Edit existing user -- Is Supposed to fill the AddEdit form with data from the grid

Private Sub EditToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles EditToolStripMenuItem.Click

Dim frm As New frmAddEdit

'Solves the ArgumentOutOfRange Exception but the grid is not getting filled.

'If Me.dgvUsers.SelectedCells.Count > 0 Then

' Dim rowIndex As Integer = Me.dgvUsers.SelectedCells(0).RowInfo.Index

'End If

'Tried the Following but it Throws an Argument Out of range exception

'Dim rowIndex As Integer = Me.dgvUsers.SelectedCells(0).RowInfo.Index

'Original code from version one using the standard GataGridView supplied by VS

'as you can see i get the 'RowIndex' not a member of 'Telerik.WinControls.UI.GridViewCellInfo' problem

'I wrote about initially I need to know how to achive the same effect using Telerik controls.