G
Guest
I am using sql parameters to attempt to update a table but but no matter what
"CustomerId" is only the first row in the table is being updated instead of
the row specified, here is the abreviated code :
Me.SqlUpdateCommand1.CommandText = "UPDATE Queue SET January = @January,
March = @March, April = @April, May = @May, " & _
"June = @June, July = @July, August = @August, September =
@September, October = " & _
"@October, November = @November, December = @December, February
= @February WHERE CustomerId = @CustomerID"
Me.sqlDataAdapter1.Fill(DataSet1, "Queue")
Dim QueueRow As DataRow = DataSet1.Tables("Queue").Rows(0)
QueueRow(month) = ProductList.ToString()
Me.sqlDataAdapter1.Update(DataSet1, "Queue")
Me.SqlUpdateCommand1.Parameters.Add("@CustomerId",
System.Data.SqlDbType.Int, 255, "CustomerId").Value = myCustomerID
Any ideas?
Thanks, Justin.
"CustomerId" is only the first row in the table is being updated instead of
the row specified, here is the abreviated code :
Me.SqlUpdateCommand1.CommandText = "UPDATE Queue SET January = @January,
March = @March, April = @April, May = @May, " & _
"June = @June, July = @July, August = @August, September =
@September, October = " & _
"@October, November = @November, December = @December, February
= @February WHERE CustomerId = @CustomerID"
Me.sqlDataAdapter1.Fill(DataSet1, "Queue")
Dim QueueRow As DataRow = DataSet1.Tables("Queue").Rows(0)
QueueRow(month) = ProductList.ToString()
Me.sqlDataAdapter1.Update(DataSet1, "Queue")
Me.SqlUpdateCommand1.Parameters.Add("@CustomerId",
System.Data.SqlDbType.Int, 255, "CustomerId").Value = myCustomerID
Any ideas?
Thanks, Justin.