locked
after Deploying webapplication Error" Operation must use an updateable query. " RRS feed

  • Question

  • User-2074802862 posted

    hi

    actually lots of hour i spend on this problem to solve

    if any bady has solution plz late me know

    the problem is webapplication running fine befor i deployed it but after deploying evry thin work expt insert and update command

    here is the problem

    Operation must use an updateable query.

     

              
    cmd = New OleDbCommand("insert into NewApplicationForm (csName, Cname, Nature, LOS, Post, Nationality, PPno, Salary, Pmode, BName, PPCopy, VScopy, IDcopy,NYC,Climit,OutS,LPnODC,CCstmt,CCcopy,Age,Altno,PPnVSvalidn,DOP,Aname,Verified,Status,Card,DOC,cComment) values ('" & txtName.Text & "','" & txtcompany.Text & "','" & txtnature.Text & "','" & txtlos.Text & "','" & txtpost.Text & "','" & dlNationality.SelectedItem.Text & "','" & txtpp.Text & "','" & txtsal.Text & "','" & dlpaymode.SelectedItem.Text & "','" & txtbank.Text & "','" & (Chkppc.Checked).ToString & "','" & (chkvs.Checked).ToString & "','" & (chkid.Checked).ToString & "','" & (chkbankstmt.Checked).ToString & "','" & (chkVnIdverify.Checked).ToString & "','" & dlUAE.SelectedItem.Text & "','" & txtccname.Text & "','" & txtccusing.Text & "','" & txtcclimit.Text & "','" & txtoutstand.Text & "','" & (chklate.Checked).ToString & "','" & (chkccstmt.Checked).ToString & "','" & (chkcccopy.Checked).ToString & "','" & txtage.Text & "','" & txtaltno.Text & "','" & (chkppnv.Checked).ToString & "','" & txtdop.Text & "','" & (Label2.Text) & "','" & dlstatus.SelectedItem.Text & "','" & dlstatus.SelectedItem.Text & "','" & dlcardtype.SelectedItem.Text & "','" & Date.Now() & "','" & txtcoment.Text & "')", cn)
            cmd.ExecuteNonQuery()

    Tuesday, March 31, 2009 2:03 AM

Answers

All replies