filling a datagrid

[reidarT]

I want to fill a datagrid with different dataadapters.
The problem is to refresh the datagrid. How do I populate the datagrid with
different dataadapters?
I use buttons to do this
button1
Private Sub cmdAnsatt_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles cmdAnsatt.Click
OleDbDAAnsatt.Fill(DsAnsatt)
'Me.Refresh()
End Sub
button2
Private Sub cmdAnsatt2_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles cmdAnsatt2.Click
OleDbDAAnsatt3.Fill(DsAnsatt)
'Me.Refresh()
End Sub

This does not work
regards
reidarT

 

[Ken Tucker [MVP]]

Hi,

Try something like this.

Private Sub cmdAnsatt_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles cmdAnsatt.Click
dsansatt.clear
OleDbDAAnsatt.Fill(DsAnsatt)
datagrid1.datasource=dsansatt.tables(0)
End Sub
button2
Private Sub cmdAnsatt2_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles cmdAnsatt2.Click
dsansatt.clear
OleDbDAAnsatt3.Fill(DsAnsatt)
datagrid1.datasource=dsansatt.tables(0)
End Sub

Ken
-----------------------------

I want to fill a datagrid with different dataadapters.
The problem is to refresh the datagrid. How do I populate the datagrid with
different dataadapters?
I use buttons to do this
button1
Private Sub cmdAnsatt_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles cmdAnsatt.Click
OleDbDAAnsatt.Fill(DsAnsatt)
'Me.Refresh()
End Sub
button2
Private Sub cmdAnsatt2_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles cmdAnsatt2.Click
OleDbDAAnsatt3.Fill(DsAnsatt)
'Me.Refresh()
End Sub

This does not work
regards
reidarT