Data table issue

[Megan]

We've got a radgrid bound to a dataset and a search text box on our web page. When the user inputs a code to the text box, we want the radgrid to find the row within the dataset and scroll down to it in the grid.
 
This was possible to do in standard VB.NET but we're having issues using telerik.

So far we have this logic:

 

   Protected Sub form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles form1.Load
        cn = New SqlConnection(ConStr)
        ds = New DataSet
        dv = New DataView

        Dim ad As New SqlDataAdapter("select * from mytable", cn)

        ad.Fill(ds, "codeid")

        dv.Table = ds.Tables("codeid")

        RadGrid.DataSource = dv

    End Sub

    Protected Sub btnSearch_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSearch.Click
        Dim lpos As Integer

        dv.Sort = "codeid"
        lpos = dv.Find(btnSearch.Text)

        'here we want to set current row to lpos

        RadGrid.Rebind()

    End Sub

 

 

But when it comes to setting the data set's index we found the property was read only.

RadGrid2.SelectedItems.Item(0).DataSetIndex = 4

Property 'DataSetIndex' is 'ReadOnly'.

Is there another property we have to use instead to achieve the same effect of getting the grid to scroll down to the right place in the dataset position the user searched for?

 

[Vlad]

Hi Megan,

Can you post your standard VB.NET? We will gladly translate you to RadGrid style.

Sincerely yours,
Vlad
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Megan]

Imports System.Data

Imports System.Data.SqlClient

Public Class Form1

    Private ds As DataSet
    Private dv As DataView
    Private ConStr As String = "Data Source=SERVER;Initial Catalog=DATABASE;User ID=sa"
    Private cn As SqlConnection

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

        cn = New SqlConnection(ConStr)
        ds = New DataSet
        dv = New DataView

        Dim ad As New SqlDataAdapter("select * from mytable", cn)

        ad.Fill(ds, "codeid")
        dv.Table = ds.Tables("codeid")

        Me.DataGridView1.DataSource = dv

    End Sub

    Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged

        Dim strVal As String

        strVal = Me.ComboBox1.Text
        Label1.Text = "The data is sorted on column " & strVal
        dv.Sort = "codeid"

    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim lpos As Integer

        dv.Sort = "codeid"
        lpos = dv.Find(TextBox1.Text)
        DataGridView1.CurrentCell = DataGridView1.Item("codeid", lpos)
        '  DataGridView1.pos() ' = True '= lpos ' = DataGridView1.Item(lpos, 1)
        'Find the customer named "Smith" in the primary key column
        'Int(i = dv.Find("Smith"))

    End Sub

    Sub ComboBox2_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox2.SelectedIndexChanged

        Dim filtStr As String
        filtStr = Me.ComboBox2.Text
        Label1.Text = "The Data is Filtered for all Names starting with alphabet " & filtStr
        dv.RowFilter = "Name like '" & filtStr & "*'"

    End Sub

End Class

I assume only memebers of staff can add attachments to posts so I hope this is enough to work from.

[Vlad]

Hi Megan,

As far as I know CurrentCell property is available in WinForms grid.

All the best,
Vlad
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Megan]

Is there no other way to achieve this? We don't have WinForms.

I don't understand why this property has to be readonly.