sql—在客户从上一页登录后,以一个窗体显示客户详细信息

dwthyt8l  于 2021-07-26  发布在  Java
关注(0)|答案(0)|浏览(226)

我有一个客户登录页面与客户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()`

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题