[Solved] Problem to fill datagrid by using OleDbConnection

[Ali]

Hello
I use this code to fill datagrid , but rows was created without data! whats the problem?

Dim connString As String = "Provider=SQLOLEDB.1;Password=*******;Persist Security Info=True;User ID=sa;Initial Catalog=chek;Data Source=ahnd"
        Dim myConnection As OleDbConnection = New OleDbConnection
        '192.168.168.1
        'Data Source=ahnd;Initial Catalog=chek;Persist Security Info=True;User ID=sa
        myConnection.ConnectionString = connString
        Dim da As OleDbDataAdapter = New OleDbDataAdapter("select * from x" , myConnection)
        Dim ds As DataSet = New DataSet
        da.Fill(ds, "x")
        RadGridView1.DataSource = ds.Tables("x").DefaultView

[Emanuel Varga]

Hello Ali,

Please check your resulting data set / data table for data before setting it as a data source to the grid. If the grid loads columns correctly i don't believe that there is a problem with the grid, in my point of view the problem is coming from the query itself.

Hope this helps, if you have any other questions or comments, please let me know,

Best Regards,
Emanuel Varga

Telerik WinForms MVP

[Ali]

Hello
I change my radgrid properties to default and problem solved.
Thank u.