Ok - I have tried this....
I receive the Message:Code:Dim Prac_Req As New System.Data.SqlClient.SqlCommand(("Select prac_no, prac_enabled From dbo.TblPracExclude"), conn) Try Using Autoreader As System.Data.SqlClient.SqlDataReader = Prac_Req.ExecuteReader() While Autoreader.Read() prac_no = Autoreader.GetValue(0) prac_enabled = Autoreader.GetValue(1) For irow = 0 To DgvPracExcl.Rows.Count - 1 If prac_no = DgvPracExcl.Rows(irow).Cells(0).Value Then If prac_enabled = DgvPracExcl.Rows(irow).Cells(3).Value Then MsgBox("No Practice need Update", MsgBoxStyle.Information, "VeriSIS") strFlag = "Ignore" Exit For Else MsgBox("Practice need Update", MsgBoxStyle.Information, "VeriSIS") strFlag = "Update" Exit For End If End If Next irow End While End Using Catch ex As Exception MsgBox(ex.Message, MsgBoxStyle.Information, "VeriSIS") End Try
No Practice need Update.
When I click OK, I do receive another similar message and so on.
When I changed - DgvPracExcl.Rows(irow).Cells(3).Value from True to False.
I still received the same message - No Practice need Update..
My expectation is to show message - Practice need Update and call the UpdatePracEnabled() function..
Please help me to fix this..
Many thanks




Reply With Quote