Please help my Update doesn't want to work!!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Nessa
    New Member
    • Apr 2012
    • 1

    #1

    Please help my Update doesn't want to work!!

    updateAdapter.U pdateCommand = new OleDbCommand("U PDATE DoBEDetails SET NoD=@NoD,Projec tName=@ProjectN ame WHERE ClientID =@ClientID", dbConn);

    updateAdapter.U pdateCommand.Pa rameters.AddWit hValue("@Client ID", OleDbType.Integ er).Value = txtID.Text;
    updateAdapter.U pdateCommand.Pa rameters.Add("@ NoD", OleDbType.VarCh ar).Value = txtNoD.Text;
    updateAdapter.U pdateCommand.Pa rameters.Add("@ ProjectName", OleDbType.VarCh ar).Value = txtPro.Text;

    dbConn.Open();
    updateAdapter.U pdateCommand.Ex ecuteNonQuery() ;
    dbConn.Close();

    dbConn.Open();
    updateAdapter.U pdateCommand.Ex ecuteNonQuery() ;
    dbConn.Close();
Working...