Re: dataadapter update problem, (please help!)

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

  • Re: VB vs C# question (trying to switch languages)
    ... some day i''m gona pay this forum back for all the help i''m getting ... So you'll have to explicitely add this handler as shown in the article I ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: VB vs C# question (trying to switch languages)
    ... some day i''m gona pay this forum back for all the help i''m getting ... "Patrice" wrote: ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: question on sqldatareaders
    ... some day i''m gona pay this forum back for all the help i''m getting ... If you do not explicitly close your reader ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: find height of a datagrid
    ... some day i''m gona pay this forum back for all the help i''m getting ... And i need to resize the panel to the specific height of the gridview. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: C# casting question
    ... some day i''m gona pay this forum back for all the help i''m getting ... public Boolean fn_isVaildUser(string userid, string password) ... SqlConnection sqlcon1 = new SqlConnection; ...
    (microsoft.public.dotnet.framework.aspnet)
Loading