form1.vb

用vb.net写的基于c/s结构的进销存程序设计源代码

Imports System.Data.SqlClient
Public Class Form1
    Inherits System.Windows.Forms.Form

#Region " Windows 窗体设计器生成的代码 "

    Public Sub New()
        MyBase.New()

        '该调用是 Windows 窗体设计器所必需的。
        InitializeComponent()

        '在 InitializeComponent() 调用之后添加任何初始化

    End Sub

    '窗体重写处置以清理组件列表。
    Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
        If disposing Then
            If Not (components Is Nothing) Then
                components.Dispose()
            End If
        End If
        MyBase.Dispose(disposing)
    End Sub

    'Windows 窗体设计器所必需的
    Private components As System.ComponentModel.IContainer

    '注意：以下过程是 Windows 窗体设计器所必需的
    '可以使用 Windows 窗体设计器修改此过程。
    '不要使用代码编辑器修改它。
    Friend WithEvents SqlConnection1 As System.Data.SqlClient.SqlConnection
    Friend WithEvents SqlCommand1 As System.Data.SqlClient.SqlCommand
    Friend WithEvents Label1 As System.Windows.Forms.Label
    Friend WithEvents Label2 As System.Windows.Forms.Label
    Friend WithEvents TxCategoryName As System.Windows.Forms.TextBox
    Friend WithEvents BnSerch As System.Windows.Forms.Button
    Friend WithEvents TxOrdYear As System.Windows.Forms.TextBox
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
        Me.SqlConnection1 = New System.Data.SqlClient.SqlConnection()
        Me.SqlCommand1 = New System.Data.SqlClient.SqlCommand()
        Me.Label1 = New System.Windows.Forms.Label()
        Me.Label2 = New System.Windows.Forms.Label()
        Me.TxCategoryName = New System.Windows.Forms.TextBox()
        Me.TxOrdYear = New System.Windows.Forms.TextBox()
        Me.BnSerch = New System.Windows.Forms.Button()
        Me.SuspendLayout()
        '
        'SqlConnection1
        '
        Me.SqlConnection1.ConnectionString = "data source=YEXIAOJIAO;initial catalog=Northwind;persist security info=False;user" & _
        " id=sa;workstation id=YEXIAOJIAO;packet size=4096"
        '
        'SqlCommand1
        '
        Me.SqlCommand1.CommandText = "dbo.[SalesByCategory]"
        Me.SqlCommand1.CommandType = System.Data.CommandType.StoredProcedure
        Me.SqlCommand1.Connection = Me.SqlConnection1
        Me.SqlCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, False, CType(10, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))
        Me.SqlCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CategoryName", System.Data.SqlDbType.NVarChar, 15))
        Me.SqlCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@OrdYear", System.Data.SqlDbType.NVarChar, 4))
        '
        'Label1
        '
        Me.Label1.Location = New System.Drawing.Point(32, 16)
        Me.Label1.Name = "Label1"
        Me.Label1.Size = New System.Drawing.Size(80, 24)
        Me.Label1.TabIndex = 0
        Me.Label1.Text = "商品名称"
        '
        'Label2
        '
        Me.Label2.Location = New System.Drawing.Point(32, 56)
        Me.Label2.Name = "Label2"
        Me.Label2.Size = New System.Drawing.Size(80, 24)
        Me.Label2.TabIndex = 1
        Me.Label2.Text = "销售年份"
        '
        'TxCategoryName
        '
        Me.TxCategoryName.Location = New System.Drawing.Point(144, 16)
        Me.TxCategoryName.Name = "TxCategoryName"
        Me.TxCategoryName.Size = New System.Drawing.Size(112, 21)
        Me.TxCategoryName.TabIndex = 2
        Me.TxCategoryName.Text = "TextBox1"
        '
        'TxOrdYear
        '
        Me.TxOrdYear.Location = New System.Drawing.Point(144, 56)
        Me.TxOrdYear.Name = "TxOrdYear"
        Me.TxOrdYear.Size = New System.Drawing.Size(112, 21)
        Me.TxOrdYear.TabIndex = 3
        Me.TxOrdYear.Text = "TextBox2"
        '
        'BnSerch
        '
        Me.BnSerch.Location = New System.Drawing.Point(304, 16)
        Me.BnSerch.Name = "BnSerch"
        Me.BnSerch.Size = New System.Drawing.Size(80, 24)
        Me.BnSerch.TabIndex = 4
        Me.BnSerch.Text = "查询"
        '
        'Form1
        '
        Me.AutoScaleBaseSize = New System.Drawing.Size(6, 14)
        Me.ClientSize = New System.Drawing.Size(400, 117)
        Me.Controls.AddRange(New System.Windows.Forms.Control() {Me.BnSerch, Me.TxOrdYear, Me.TxCategoryName, Me.Label2, Me.Label1})
        Me.Name = "Form1"
        Me.Text = "Form1"
        Me.ResumeLayout(False)

    End Sub

#End Region

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        TxCategoryName.Text = ""
        txOrdYear.Text = ""

    End Sub

    Private Sub BnSerch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BnSerch.Click
        SqlCommand1.Parameters("@CategoryName").Value = TxCategoryName.Text
        SqlCommand1.Parameters("@OrdYear").Value = TxOrdYear.Text
        '开启连接
        SqlConnection1.Open()
        '建立SqlDataReader对象
        Dim dr As SqlDataReader
        '因为传回是一些数据, 故用ExecuteReader
        dr = SqlCommand1.ExecuteReader(CommandBehavior.CloseConnection)
        If dr.Read Then
            MessageBox.Show("商品名称:" & dr.GetString(0) & _
                vbCrLf & "采购金额:" & Str(dr.GetValue(1)))
        Else
            MessageBox.Show("找不到!")
        End If
        '关闭SqlDataReader对象
        dr.Close()

    End Sub
End Class