form1.vb

编程之道VB.NETt程序设计入门-589M.zip

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 DataGrid1 As System.Windows.Forms.DataGrid
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
        Me.DataGrid1 = New System.Windows.Forms.DataGrid()
        CType(Me.DataGrid1, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.SuspendLayout()
        '
        'DataGrid1
        '
        Me.DataGrid1.DataMember = ""
        Me.DataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText
        Me.DataGrid1.Location = New System.Drawing.Point(8, 8)
        Me.DataGrid1.Name = "DataGrid1"
        Me.DataGrid1.Size = New System.Drawing.Size(520, 256)
        Me.DataGrid1.TabIndex = 0
        '
        'Form1
        '
        Me.AutoScaleBaseSize = New System.Drawing.Size(6, 14)
        Me.ClientSize = New System.Drawing.Size(536, 270)
        Me.Controls.AddRange(New System.Windows.Forms.Control() {Me.DataGrid1})
        Me.Name = "Form1"
        Me.Text = "Form1"
        CType(Me.DataGrid1, System.ComponentModel.ISupportInitialize).EndInit()
        Me.ResumeLayout(False)

    End Sub

#End Region

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

        '一个SqlConnection对象
        Dim objConn As New SqlClient.SqlConnection()

        '一个SqlCommand对象
        Dim objComm As New SqlClient.SqlCommand()

        '一个SqlDataAdapter对象
        Dim objDa As New SqlClient.SqlDataAdapter()

        '一个数据集DataSet对象
        Dim objDs As New DataSet()

        '设置连接字符串，告诉程序应当如何连接到数据库
        objConn.ConnectionString = "Data Source=(local);Initial Catalog=Northwind;Integrated Security=SSPI"

        '设置SQL命令，告诉程序应当如何取数据
        objComm.CommandText = "Select * From Products"

        '把objConn设置为objComm的数据库连接
        '相当于告诉“卡车”：应该走objConn这座“桥”
        objComm.Connection = objConn
        objDa.SelectCommand = objComm

        '打开数据库连接
        '相当于把桥造好
        objConn.Open()

        '与Case7_2中的Fill相同，填充数据集
        objDa.Fill(objDs)

        '关闭数据库连接
        '相当于填充完毕，可以把桥拆掉了
        objConn.Close()

        '把DataGrid1的DataSource属性设置为刚刚取到的数据表
        '这样就可以显示数据了
        DataGrid1.DataSource = objDs.Tables(0)

    End Sub
End Class