Re: Update Database from DataAdapter

From: Strider (Strider_at_discussions.microsoft.com)
Date: 09/24/04 

Date: Fri, 24 Sep 2004 06:07:03 -0700

Here is my code of what im trying to do. What should i change to this

   Public Shared Function UpdateTable(ByVal ds As DataSet, ByVal dbloc As
String, ByVal tableName As String)
        Try
            'Create a connection to the new database.
            Dim ssceconn As New SqlCeConnection("Data Source = " & dbloc)
            Dim sqlDA As SqlCeDataAdapter

            'Select everything from the Routes table.
            sqlDA = New SqlCeDataAdapter("SELECT * FROM " & tableName,
ssceconn)

            sqlDA.Update(ds, tableName)
        Catch err As SqlCeException
            MsgBox(err.Message)
        End Try
    End Function

"Val Mazur" wrote:

> Hi,
>
> Calling Update should do this, but in a case of your DataSet was populated
> using Dataadapter (DA). In a case if your dataSet fall fabricated, then DA
> will not know anything about underlying database. Another potential issue is
> the you call AcceptChanges before calling Update method of DA. In this case
> AcceptChanges will reset state of the rows to unmodified and DA will not see
> any changes in a DataSet.
>
> --
> Val Mazur
> Microsoft MVP
>
>
> "Strider" <Strider@discussions.microsoft.com> wrote in message
> news:C934CEFE-DC65-43DA-B1B5-4B6E242E4715@microsoft.com...
> > Hey,
> > here is my problem. I have a dataSet which contains data that i want to
> > add
> > to my database. But i dont know how to update the dataadapter with the
> > dataset.
> > i've tried da.update(ds,tableName) but it does not update it.
> >
> > can anyone help
> >
> > Cheers
>
>
>