When I try to Update my Datagrid, it takes whichever row i edit and puts those values in all datagrid columns instead of just the one. Here is my code:
DA.UpdateCommand = New SqlCommand
With DA.UpdateCommand
.Connection = cnn
.CommandType = CommandType.StoredProcedure
.CommandText = "CardioUP"
.Parameters.Clear()
.Parameters.Add("@Surg", Surg)
.Parameters.Add("@pleg_time", SqlDbType.DateTime)
.Parameters("@Pleg_time").SourceColumn = "Time"
.Parameters.Add("@Type", SqlDbType.VarChar, 50)
.Parameters("@Type").SourceColumn = "Type"
.Parameters.Add("@Route", SqlDbType.VarChar, 50)
.Parameters("@Route").SourceColumn = "Route"
.Parameters.Add("@Temp", SqlDbType.Float, 8)
.Parameters("@Temp").SourceColumn = "Temp"
.Parameters.Add("@K", SqlDbType.VarChar, 10)
.Parameters("@K").SourceColumn = "K+"
.Parameters.Add("@Mg", SqlDbType.VarChar, 10)
.Parameters("@Mg").SourceColumn = "Mg++"
.Parameters.Add("@FlowRate", SqlDbType.VarChar, 10)
.Parameters("@FlowRate").SourceColumn = "Flow Rate"
.Parameters.Add("@Dose", SqlDbType.VarChar, 10)
.Parameters("@Dose").SourceColumn = "Dose cc's"
.Parameters.Add("@Cor", SqlDbType.VarChar, 10)
.Parameters("@Cor").SourceColumn = "Cor. Sinus"
End With
Any Suggestions would be greatly appreciated!
DA.UpdateCommand = New SqlCommand
With DA.UpdateCommand
.Connection = cnn
.CommandType = CommandType.StoredProcedure
.CommandText = "CardioUP"
.Parameters.Clear()
.Parameters.Add("@Surg", Surg)
.Parameters.Add("@pleg_time", SqlDbType.DateTime)
.Parameters("@Pleg_time").SourceColumn = "Time"
.Parameters.Add("@Type", SqlDbType.VarChar, 50)
.Parameters("@Type").SourceColumn = "Type"
.Parameters.Add("@Route", SqlDbType.VarChar, 50)
.Parameters("@Route").SourceColumn = "Route"
.Parameters.Add("@Temp", SqlDbType.Float, 8)
.Parameters("@Temp").SourceColumn = "Temp"
.Parameters.Add("@K", SqlDbType.VarChar, 10)
.Parameters("@K").SourceColumn = "K+"
.Parameters.Add("@Mg", SqlDbType.VarChar, 10)
.Parameters("@Mg").SourceColumn = "Mg++"
.Parameters.Add("@FlowRate", SqlDbType.VarChar, 10)
.Parameters("@FlowRate").SourceColumn = "Flow Rate"
.Parameters.Add("@Dose", SqlDbType.VarChar, 10)
.Parameters("@Dose").SourceColumn = "Dose cc's"
.Parameters.Add("@Cor", SqlDbType.VarChar, 10)
.Parameters("@Cor").SourceColumn = "Cor. Sinus"
End With
Any Suggestions would be greatly appreciated!