RE: dataadapter update problem, (please help!)

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: dataadapter update problem, (please help!)
    ... What value does the HasErrors property on the DataTable have after you run ... >> Private Sub lbtnUpdate_Click(ByVal sender As System.Object, ... >> some day i''m gona pay this forum back for all the help i''m getting ...
    (microsoft.public.dotnet.framework.adonet)
  • 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: Problem with Rich Text Box
    ... > gentlleman from that forum... ... Private Type POINTAPI ... Private Sub RichTextBox1_Click ... Dim HighLight As Boolean ...
    (microsoft.public.vb.bugs)
  • 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)
Loading