Get selected row values of any column
8 Replies
Hi Pratura,
To get the value from a grid row in VB.NET code and JS, you have to use theRowSelected event. Please find the below code snippets.
VB.Net:
You can also use OnServerRowSelected server-side event of the Grid. Please find the code example.
| [Default.aspx] <ej:grid ID="gvAlumnos" runat='server' AllowPaging="True" AllowGrouping="true" OnServerRowSelected="gvAlumnos_ServerRowSelected"> <Columns> <ej:Column Field="CustomerID" HeaderText="CustomerID" Width="75" /> <ej:Column Field="OrderID" HeaderText="OrderID" /> <ej:Column Field="EmployeeID" HeaderText="EmployeeID" Width="75" /> <ej:Column Field="ShipCity" HeaderText="ShipCity" Width="75" /> </Columns> </ej:grid> [Default.aspx.vb] Protected Sub gvAlumnos_ServerRowSelected(sender As Object, e As Syncfusion.JavaScript.Web.GridEventArgs) Dim selectedrowindex As Integer = Convert.ToInt32(e.Arguments("rowIndex")) Dim id As Integer Dim data As Dictionary(Of String, Object) = TryCast(e.Arguments("data"), Dictionary(Of String, Object)) For Each keyval As KeyValuePair(Of String, Object) In data If keyval.Key = "EmployeeID" Then //find the EmployeeID column value. id = keyval.Value End If Next End Sub |
The OnServerRowSelected event helps to get the selected ones in the server side.
Please find the attached samples in VB.net below:
JS:
We have achieved your requirement by using rowSelected event of the ejGrid. Please find the below code snippets.
| $("#Grid").ejGrid({ dataSource: data, allowPaging: true, allowSorting: true, columns: [ { field: "OrderID", headerText: "Order ID", width: 75, textAlign: ej.TextAlign.Right }, { field: "CustomerID", headerText: "Customer ID", width: 80 }, ], //client side event rowSelected: "rowSelected", }); function rowSelected() { var obj = $("#Grid").ejGrid("instance"); //getSelectedRecords method will display the selected row in a grid alert(obj.getSelectedRecords()[0].CustomerID); } |
The “rowSelected” event helps to getSelected in client side.
Please find the below attached samples and Online Documentation link about getSelectedRecords and rowSelected events.
Documentation link for getSelectedRecords: https://help.syncfusion.com/api/js/ejgrid#methods:getselectedrecords
Documentation link for rowSelected: https://help.syncfusion.com/api/js/ejgrid#events:rowselected
Regards,
Isuriya R.
Hi Pratura,
Sorry for inconvenience caused.
We have validated your requirement , currently we don’t have support directly get selected value through method in server side . So We suggest to use the selected values are stored in global variable through Server “RowSelected” event of Grid and you can get selected valued from the global variable . please find the code example
|
[code behind]
Public Class _Default
Inherits System.Web.UI.Page
Dim Shared selectedData 'global variable declaration
Protected Sub Submit(sender As Object, e As EventArgs)
Dim selectedRows As Object
selectedRows = selectedData 'global variable resue
End Sub
Protected Sub gvAlumnos_ServerRowSelected(sender As Object, e As Syncfusion.JavaScript.Web.GridEventArgs)
Dim selectedrowindex As Integer = Convert.ToInt32(e.Arguments("rowIndex"))
Dim id As Integer
Dim data As Dictionary(Of String, Object) = TryCast(e.Arguments("data"), Dictionary(Of String, Object))
For Each keyval As KeyValuePair(Of String, Object) In data
If keyval.Key = "EmployeeID" Then
id = keyval.Value
End If
Next
selectedData = data
End Sub
End Class
[aspx]
<asp:Button ID="selectRow" runat="server" OnClick=" Submit" Text="getSelectedRecords" />
<ej:grid ID="gvAlumnos" runat='server' AllowPaging="True"
. . .
</ej:grid> |
.
In above code example we have stored selected values in global variable through “RowSelected” event of Grid . when get the selected Rows through global Variable as “selectedData”. Please find the screen shot.
Get selected data from “RowSelected” event of Grid and its stored in Global variable as SelectedData.
Get selected rows data from global variable when click external button :
Regards,
J.Mohammed Farook
SIGN IN To post a reply.
