Vb6 to C#-especially the part where they update the column in the datatable

• • Reply

  12 years ago

  by kingdev

  kingdev

  , United States

  Joined 12 years ago

  Hi! guys.. 

  Function FreeItemsRefNumber(addno As Integer)

  Dim rs As New ADODB.Recordset

  rs.CursorType = adOpenDynamic

  rs.LockType = adLockOptimistic

  rs.Open "SELECT * FROM FreeItemsRefNumber", clslib.cnn1

  If rs.EOF = True Or rs.BOF = True Then

  rs.AddNew

  rs("LastSerialNumber") = -1

  Else

  //i know how to add a new row, but how do i update

  rs("LastSerialNumber") = rs("LastSerialNumber") - addno

  End If

  rs.Update

  FreeItemsRefNumber = rs("LastSerialNumber")

  rs.Close

  Set rs = Nothing

  End Function

   ````````````````````````````````````````````````````````````````````

  using (SqlDataAdapter da = new SqlDataAdapter(sql, sqlConn))

  {

   

  da.Fill(dt);

  if(dt.Rows.Count<0)

  {

  DataRow dr=dt.NewRow();dr["LastSerialNumber"]=-1;

  dt.Rows.Add(dr);

  } else

  {

   

  }

   

  Report abuse