Bind datatable to a datagrid

[SALIH ATAOZ]

cnn.Open()
Dim sql As String = "select * from kayitlar;"
Dim dt As New DataTable()
Dim dausers As New OleDb.OleDbDataAdapter(sql, cnn)
dausers.Fill(dt)
DataGrid1.SetDataBinding(dt, "kayitlar")

somethings wrong i cant fill the datagrid

 

[Tim Newton]

try with the ";" at the end of the select, i.e. :-

Dim sql As String = "select * from kayitlar"

Tim

http://newtonsoftware.net

 

[Alan]

How do I clear the datagrid in order to fill in it again ?
In my case the sql is "Select * from Table1 where...."

Everytime I fill in the datagrid I need to clear it before fill in.

 

[One Handed Man]

See my reply to your duplicate post above.

Regards - OHM