定期查询.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 objdr As SqlClient.SqlDataReader
    Dim strsql As String
    Dim objcommand As SqlClient.SqlCommand
    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        objds.Clear()
        strsql = "select FConsumers.ID as 帐号,FConsumers.name as 姓名,FConsumers.stationID as 身份证号码,FConsumers.money as 金额,FConsumers.passTime as 存期,FConsumers.FAccrual as 定期利率,FConsumers.FetchDate as 开户时间 from FConsumers"
        objda = New SqlClient.SqlDataAdapter(strsql, strconn)
        objda.Fill(objds, "FConsumers")
        DataGridView1.DataSource = objds.Tables("FConsumers")
    End Sub
    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  FConsumers.ID as 帐号,FConsumers.name as 姓名,FConsumers.stationID as 身份证号码,FConsumers.money as 金额,FConsumers.passTime as 存期,FConsumers.FAccrual as 定期利率,FConsumers.FetchDate as 开户时间 from FConsumers where " & Trim(ComboBox1.Text) & "='" & Trim(TextBox1.Text) & "'"
            objda = New SqlClient.SqlDataAdapter(strsql, strconn)
            objda.Fill(objds, "FConsumers")
            DataGridView1.DataSource = objds.Tables("FConsumers")
        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
End Class