我有一个客户登录页面与客户id和联系电话。在他们登录后,我需要显示在上一页谁登录的客户详细信息,这是customerid,customername,性别,电话,电子邮件。我已经有了一个客户数据库。下面是我的代码
`
Dim connection As New SqlConnection
Dim command As New SqlCommand
Dim reader As SqlDataReader
connection.ConnectionString = "Data Source=LAPTOP-5E4GSPTU;Initial Catalog=VBN Assignment;Integrated Security=True"
connection.Open()
command.Connection = connection
command.CommandText = "select * CustomerID, CustomerName, Gender, PhoneNumber, EmailAddress from CustomerRegistration"
reader = command.ExecuteReader
If reader.HasRows Then
reader.Read()
TextBox1.Text = reader.Item("CustomerID")
TextBox2.Text = reader.Item("CustomerName")
ComboBox1.Text = reader.Item("Gender")
TextBox3.Text = reader.Item("PhoneNumber")
TextBox4.Text = reader.Item("EmailAddress")
reader.Close()
End If
connection.Close()`
暂无答案!
目前还没有任何答案,快来回答吧!