Problem Updating Database

[Justin]

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.

[Ollie Riches]

surely it is just reutrning the number of affected rows not the rows that
were affected?

HTH

Ollie Riches

"Justin" <Ju****@discussions.microsoft.com> wrote in message
news:BB**********************************@microsof t.com...

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.