kevinya

先到畫面上拉出一個查詢的按鍵，再拉出一個grid，隨便設定一下，記得把grid放在updatePanel裡面，這樣畫面不會一直閃，比較帥XD

然後在設定一下查詢按鍵code_behind的程式碼，就搞定拉

Protected Sub btnQuery_Click(sender As Object, e As EventArgs) Handles btnQuery.Click
        Dim strSQL As String = ""
        strSQL = " select * from Employees "
        Dim cn As SqlConnection
        Dim da As SqlDataAdapter
        Dim dt As DataTable = New DataTable()
        Try
            cn = New SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings("NorthwindConnectionString").ConnectionString)
            da = New SqlDataAdapter(strSQL, cn)
            da.Fill(dt)

            dtGrid.DataSource = dt
            dtGrid.DataBind()

        Catch ex As Exception

        End Try
    End Sub