How to get the specific column value for each checked rows in sfdatagrid

[sulthan]

    Private Sub btnDelete_Click(sender As Object, e As EventArgs) Handles btnDelete.Click

        ' Dim selectedRows = Me.grdMain.View.Records.Where(Function(item) TryCast(sender, DataRowView).Row("isClosed") = True).ToList

        Dim selectedRowIndex As Integer

        Dim records = grdMain.View.Records

        Dim x As Integer = 0

        For Each record In records

            Dim dataRowView = TryCast(record.Data, DataRowView)

            If dataRowView IsNot Nothing Then

                Dim selected = dataRowView.Row("isClosed")

                If selected.[GetType]() <> GetType(DBNull) AndAlso CBool(selected) Then

                    selectedRowIndex = selected.RowIndex

                    '  Dim rowIndex As Integer = 2

                    Dim columnIndex As Integer = grdMain.TableControl.ResolveToGridVisibleColumnIndex(1)

                    If columnIndex < 0 Then

                        Return

                    End If

                    Dim recordIndex = grdMain.TableControl.ResolveToRecordIndex(selectedRowIndex)

                    If recordIndex < 0 Then

                        Return

                    End If

                    Dim record1 = grdMain.View.Records.GetItemAt(recordIndex)

                    If record1 IsNot Nothing Then

                        Dim cellValue = (TryCast(record1, DataRowView).Row.ItemArray(columnIndex))

                        Dim cellString = String.Empty

                        If cellValue IsNot Nothing Then

                            cellString = cellValue.ToString()

                        End If

                        MessageBox.Show(cellString)

                    End If

                Else

                End If

            End If

        Next

    End Sub

When i click a button, i need to get specific column values on each row which is checked = True (isClosed = True)

[Vijayarasan Sivanandham]

Hi Sulthan,   

  

Thank you for contacting Syncfusion Support.   

  

We have analyzed your query. Your requirement “to get specific column value when checked row is true"can be achieved by using SfDataGrid.View.Records. Please refer the below code snippet.   

 

Private Sub BtnGetValue_Click(ByVal sender As Object, ByVal e As EventArgs) 

    txtColumnValue.Text = String.Empty 

 

    For Each records In sfDataGrid.View.Records 

        Dim datarowview = TryCast(records.Data, OrderInfo) 

        If datarowview.IsShipped = True Then 

                     txtColumnValue.Text &= datarowview.CustomerName 

                 End If 

    Next records 

End Sub 

 

  

Please find sample for the same from the below link, 

  

Sample Link:  https://www.syncfusion.com/downloads/support/forum/151397/ze/ColumnValue1936547937  

If we misunderstood your requirement, please provide more information regarding the requirement. This would help us to proceed further.   

  

Regards,   

Vijayarasan   

[sulthan]

Hi Sulthan,   

  

Thank you for contacting Syncfusion Support.   

  

We have analyzed your query. Your requirement “to get specific column value when checked row is true"can be achieved by using SfDataGrid.View.Records. Please refer the below code snippet.   

 

Private Sub BtnGetValue_Click(ByVal sender As Object, ByVal e As EventArgs) 

    txtColumnValue.Text = String.Empty 

 

    For Each records In sfDataGrid.View.Records 

        Dim datarowview = TryCast(records.Data, OrderInfo) 

        If datarowview.IsShipped = True Then 

                     txtColumnValue.Text &= datarowview.CustomerName 

                 End If 

    Next records 

End Sub 

 

  

Please find sample for the same from the below link, 

  

Sample Link:  https://www.syncfusion.com/downloads/support/forum/151397/ze/ColumnValue1936547937  

If we misunderstood your requirement, please provide more information regarding the requirement. This would help us to proceed further.   

  

Regards,   

Vijayarasan   

Thanx for the help..

 For Each record In grdMain.View.Records

            Dim datarowview = TryCast(record.Data, DataRowView)

            If datarowview IsNot Nothing Then

                If datarowview.Row("isClosed") = True Then

                    cellString = datarowview.Row("Voucher No")

    End If

            End If

        Next record

for me this runs what i expected..

[Farjana Parveen Ayubb]

Hi Sulthan, 

 

Thanks for the update. 

 

We are glad to know that the reported problem has been resolved at your end. Please let us know if you have any further queries on this. We are happy to help you. 

 

Regards, 

Farjana Parveen A