Hi, all i had read many post but none seem can solve my prob. I also not very understand with the use of Convert.ToInt32
here is my code:
Protected Sub gvRedemptionCart_RowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs) Handles gvRedemptionCart.RowDataBound
Dim conn As MySqlConnection
Dim sqlStatement As String
Dim sqlCmd As MySqlCommand
Dim reader As MySqlDataReader
conn = New MySqlConnection("Server=localhost;User id=root;Password=pwd;Database=name;Persist Security Info=True;Allow Zero Datetime=true")
sqlStatement = "SELECT * FROM memberdata WHERE mCardNo = '" & HttpContext.Current.User.Identity.Name & "'"
conn.Open()
sqlCmd = New MySqlCommand(sqlStatement, conn)
reader = sqlC ...
Go to the complete details ...