Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Datagrid Update Problem

Status
Not open for further replies.

bigmelon

MIS
Sep 25, 2003
114
US
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top