[2008] Updating database using SqlAdapter

[lasota]

hi,

Using SqlAdapter and "SELECT ... RIGHT OUTER JOIN .... BY .... " I'm creating datatable1 Tabela1 which consist of 4 columns. First two columns came from dbo.prierwsza another 2 columns from dbo.druga.
The Question is how can I update my secound datasource dbo.druga after changing some data in Tabela1? The Database is on MS Server 2005.

My cod is as follows:

Dim sqlConn As New SqlClient.SqlConnection
        sqlConn.ConnectionString = "server = SLY-C7BD4217D27; database = nowa; integrated security = true"
        
        Try
            sqlConn.Open()
        Catch ex As Exception
            ListBox1.Items.Add(ex.Message)
            MessageBox.Show(ex.Message, "Verbindung mit dem Datenbank koennte nich aufgebaut werden")
        End Try

        If sqlConn.State = 1 Then
            Me.Text = "Connected!!!!"
            Me.BackColor = Color.Chocolate
            ListBox1.Items.Add("Connected!")
        End If

        

        Dim sqlcomm As SqlCommand

        tabela1 = New DataTable("tabela1")
        'Dim artikel As New DataColumn("artikel")
        'artikel = New DataColumn()


        sqlcomm = sqlConn.CreateCommand()
        sqlcomm.CommandType = CommandType.Text
        sqlcomm.CommandText = "SELECT dbo.pierwsza.artikel, dbo.druga.klucz, dbo.pierwsza.abc, dbo.druga.ggg FROM dbo.pierwsza LEFT OUTER JOIN dbo.druga ON dbo.pierwsza.artikel = dbo.druga.klucz"


        

       
        
        Dim sqlAdapt As New SqlDataAdapter(sqlcomm)
        sqlAdapt.Fill(tabela1)

        mydataset.Tables.Add(tabela1)
        
        DataGridView1.DataSource = mydataset.Tables("tabela1")
        
       

        'sqlConn.Close()