T
TerishD
Okay, people, this is where I was told that I could get
some help. Anyway, I have continued to work. The code
below does not error out, but it also does not update the
data (the data afterwards is the old data). What is
missing?
----------------------
CSQLa = New SqlDataAdapter
(SC, "Server=BLLSYS\GOMACOLA;database=data_00;Trusted_Conne
ction=Yes")
CSQLa.UpdateCommand = New SqlCommand("UPDATE OECTLFIL_SQL
WHERE start_ord_no = @start_ord_no", CSQL1)
CSQLd = New DataSet()
CSQLa.Fill(CSQLd, "OECTLFIL_SQL")
CSQLr = CSQLd2.Rows(0)
CSQLd2 = CSQLd.Tables("OECTLFIL_SQL")
CSQLr("start_ord_no") = S3
CSQLa.Update(CSQLd2.Select(Nothing, Nothing,
DataViewRowState.CurrentRows))
-------------------
some help. Anyway, I have continued to work. The code
below does not error out, but it also does not update the
data (the data afterwards is the old data). What is
missing?
----------------------
CSQLa = New SqlDataAdapter
(SC, "Server=BLLSYS\GOMACOLA;database=data_00;Trusted_Conne
ction=Yes")
CSQLa.UpdateCommand = New SqlCommand("UPDATE OECTLFIL_SQL
WHERE start_ord_no = @start_ord_no", CSQL1)
CSQLd = New DataSet()
CSQLa.Fill(CSQLd, "OECTLFIL_SQL")
CSQLr = CSQLd2.Rows(0)
CSQLd2 = CSQLd.Tables("OECTLFIL_SQL")
CSQLr("start_ord_no") = S3
CSQLa.Update(CSQLd2.Select(Nothing, Nothing,
DataViewRowState.CurrentRows))
-------------------