I want to store the reference of customers to database , and when they login , they can view their own reference . but some how i still got some troubles , can you have a look ? and show me the solution , thanks in advance.
Table aspnet_User
Table Userinfo , its a FK of table aspnet_User
Here is my code :
Dim conn As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString2").ToString())
conn.Open()
'Customer Reference
Dim chars As String = "1234ABCD"
Dim orderref As String = ""
Dim r As New Random()
Dim i As Integer
For i = 1 To 8
orderref += chars.Substring(r.Next(chars.Length), 1)
Next
Dim connectionString As String = ConfigurationManager.ConnectionStrings("Co ...
Go to the complete details ...