Re: dataadapter update problem, (please help!)

Okay so now we need to figure out what the command text's are of the various
commands on your dataadapter.

--

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
----------------------------------------------------------------------------
---------------

"WebBuilder451" <WebBuilder451@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C877E65C-19F2-4344-9A0D-15C7DBA7719B@xxxxxxxxxxxxxxxx
> row is false also.
> But now it is working and the continue on error is false. (?)
> I did a check yesterday to see if the sp was getting called by harcoding a
> paramter value and it showed that the sp was not getting called. It was as
if
> it were getting skipped. This has happened to me a few time and my guess
is
> that as you suggested it's an error in the table. I'd think a sql error
would
> give an exception. I would think that an error in the ds.table.row would
also
> throw an exception is this true or does it need to be checked?
> thanks for your help
> kes
>
> --
> thanks (as always)
> some day i''m gona pay this forum back for all the help i''m getting
> kes
>
>
> "Sahil Malik [MVP]" wrote:
>
> > Okay what about the rest of the things I asked?
> >
> > --
> >
> > - Sahil Malik [MVP]
> > ADO.NET 2.0 book -
> > http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
>
> --------------------------------------------------------------------------
--
> > ---------------
> >
> > "WebBuilder451" <WebBuilder451@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
> > news:EEB68FB4-1716-40FA-B172-93DED2562358@xxxxxxxxxxxxxxxx
> > > the haserrors on the usr table is comming back false
> > > --
> > > thanks (as always)
> > > some day i''m gona pay this forum back for all the help i''m getting
> > > kes
> > >
> > >
> > > "Sahil Malik [MVP]" wrote:
> > >
> > > > What value does the HasErrors property on the DataTable have after
you
> > run
> > > > DataAdapter.Update?
> > > > You can get the error per row as the RowError property, if you
databind
> > it
> > > > to a datagrid it will appear as an exclamation mark and a relevant
> > tooltip.
> > > >
> > > > The exact reason for the error - more than likely your InsertCommand
and
> > > > UpdateCommand are faulty. Check the CommandText for those two, using
> > either
> > > > debug mode, or SQL Profiler.
> > > >
> > > > - Sahil Malik [MVP]
> > > > ADO.NET 2.0 book -
> > > >
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
> > >
> >
> --------------------------------------------------------------------------
> > --
> > > >
> > > >
> > > > "WebBuilder451" <WebBuilder451@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> > message
> > > > news:15CC24EE-05B6-4DB1-90A4-C518D35B8210@xxxxxxxxxxxxxxxx
> > > > >i can get it to update if i set Me.daMem.ContinueUpdateOnError =
True
> > > > > this being said how can i see the error?
> > > > > again please ANY advice on this would be appreciated
> > > > > --
> > > > > thanks (as always)
> > > > > some day i''m gona pay this forum back for all the help i''m
getting
> > > > > kes
> > > > >
> > > > >
> > > > > "WebBuilder451" wrote:
> > > > >
> > > > >> I've run into an interesting problem:
> > > > >> I have a very straight forward form that will update or insert
> > records
> > > > >> using
> > > > >> a dataadapter and a dataset. I worked fine until i changed the
select
> > > > >> parameter.
> > > > >> i regenerated the dataset and configured the adapter. Now i can't
> > update
> > > > >> nor
> > > > >> insert
> > > > >> I can select fine, but when i insert or update the table does not
get
> > > > >> updated. There are no errors just nothing. when i check for
dataset
> > > > >> changes i
> > > > >> get a true.
> > > > >> ok here is the code (is there a bug or known issues with vs.net
or
> > > > >> changing
> > > > >> sp's that will cause this?)
> > > > >> Private Sub lbtnUpdate_Click(ByVal sender As System.Object,
ByVal
> > e
> > > > >> As
> > > > >> System.EventArgs) Handles lbtnUpdate.Click
> > > > >> Try
> > > > >> ' get the current data set with the row
> > > > >> Me.daMem.SelectCommand.Parameters(1).Value =
> > > > >> User.Identity.Name
> > > > >> Me.daMem.Fill(Me.DsMem1.usr)
> > > > >> ' set the values in the row and update
> > > > >> With Me.DsMem1.usr(0)
> > > > >> .usrFName = Me.txtFName.Text
> > > > >> .usrMI = Me.txtMi.Text
> > > > >> .usrLName = Me.txtLname.Text
> > > > >> .usrTitle = Me.txtTitle.Text
> > > > >> .usrEmail = Me.txtEmail.Text
> > > > >> .usrUrl = Me.txtURL.Text
> > > > >> .usrUserID = Me.txtUserID.Text
> > > > >> .usrPassword = Me.txtPswd.Text
> > > > >> .usrPhone = Me.txtPhone.Text
> > > > >> .usrWkPhone = Me.txtWkPhone.Text
> > > > >> .usrCellPhone = Me.txtCell.Text
> > > > >> .usrFax = Me.txtFax.Text
> > > > >> .usrCompany = Me.txtCompany.Text
> > > > >> .usrAddress = Me.txtAddress.Text
> > > > >> .usrCity = Me.txtCity.Text
> > > > >> .usrState = Me.ddlState.SelectedValue
> > > > >> .usrZip = Me.txtZip.Text
> > > > >> .usrMemType = Me.txtMemType.Text
> > > > >> .usrMemDate = Me.txtMemDate.Text
> > > > >> .usrExpDate = Me.txtMemExpDate.Text
> > > > >> .usrExtra1 = Me.txtExtra1.Text
> > > > >> .usrExtra2 = Me.txtExtra2.Text
> > > > >> .usrStatus = Me.chkStatus.Checked
> > > > >> End With
> > > > >> Me.lblMSG.Text = Me.DsMem1.HasChanges().ToString
> > > > >> Me.lblMSG.Text &= Me.DsMem1.HasErrors()
> > > > >> Me.daMem.Update(Me.DsMem1)
> > > > >> ' Me.lblMSG.Text = Me.DsMem1.usr(0).usrFName + " " +
> > > > >> Me.DsMem1.usr(0).usrID.ToString
> > > > >> Catch ex As Exception
> > > > >> Dim msg As String = String.Format("<B>MSG:</B> {0}
<BR>
> > > > >> <B>STACK
> > > > >> TRACE:</B> {1}", _
> > > > >> ex.Message, ex.StackTrace)
> > > > >> Me.lblMSG.Text = "<B>ERROR:</B> " &
ex.GetType.ToString +
> > > > >> "<br>"
> > > > >> + msg
> > > > >> End Try
> > > > >> End Sub
> > > > >> --
> > > > >> thanks (as always)
> > > > >> some day i''m gona pay this forum back for all the help i''m
getting
> > > > >> kes
> > > >
> > > >
> > > >
> >
> >
> >


.

Relevant Pages