Hi,

I have these 3 update statements - how can incoroprate them to one please;

Code:
query = "UPDATE dbo.TblPracExclude SET prac_enabled  ='" & _
                          DgvPracExcl.Rows(e.RowIndex).Cells(4).Value & "' where Prac_No=" & _
                          DgvPracExcl.Rows(e.RowIndex).Cells(0).Value & ""
                cmd = New SqlCommand(query, conn)
                cmd.ExecuteNonQuery()

                query = "UPDATE dbo.TblPracExclude SET Notes = '" & _
                          Nz(Replace(DgvPracExcl.Rows(e.RowIndex).Cells(5).Value, "'", "''")) & "' where Prac_No=" & _
                          DgvPracExcl.Rows(e.RowIndex).Cells(0).Value & ""
                cmd = New SqlCommand(query, conn)
                cmd.ExecuteNonQuery()


                query = "UPDATE dbo.TblPracExclude SET SysDatetime ='" & _
                          DateTime.Now.ToString("dd\-MMMM\-yyyy HH:mm:ss") & "' where Prac_No=" & _
                          DgvPracExcl.Rows(e.RowIndex).Cells(0).Value & ""
                cmd = New SqlCommand(query, conn)
                cmd.ExecuteNonQuery()

Thanks