查询.vb

银行帐户管理系统

Public Class 查询
    Inherits System.Windows.Forms.Form
    Dim strconn As String = "data source=.;initial catalog=weboy;user id=sa;password=;"
    Dim objds As New Data.DataSet
    Dim objda As SqlClient.SqlDataAdapter
    Dim bingpage As BindingManagerBase
    Dim strsql As String
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        objds.Clear()
        If ComboBox1.Text = "" Or TextBox1.Text = "" Then
            MessageBox.Show("请输入查询条件!")
            Exit Sub
        Else
            strsql = "select  CConsumers.ID as 帐号,CConsumers.userName as 姓名,CConsumers.userStationID as 开户人身份证号,CConsumers.userAddress as 开户人地址,CConsumers.userPhone as 开户人电话,CConsumers.money as 金额 from CConsumers where " & Trim(ComboBox1.Text) & "=" & "'" & Trim(TextBox1.Text) & "'"
            objda = New SqlClient.SqlDataAdapter(strsql, strconn)
            objda.Fill(objds, "CConsumers")
            DataGridView1.DataSource = objds.Tables("CConsumers")
        End If
    End Sub

    Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
        Me.Close()

    End Sub

    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        objds.Clear()
        strsql = "select * from CConsumers"
        objda = New SqlClient.SqlDataAdapter(strsql, strconn)
        objda.Fill(objds, "CConsumers")
        DataGridView1.DataSource = objds.Tables("CConsumers")

    End Sub
End Class