求用DataSet绑定DataGridView,实现动态加载数据的代码

本人想写一个用DataSet绑定DataGridView的公共过程,然后在各窗体调用该过程,实现把数据读入到该窗本的DataGridView.

google_ad_width = 250; google_ad_height = 250; google_ad_format = "250x250_as"; google_color_url = "000000";

写了一点代码,但行不通.打开窗体后数据并没有在DataGridview显示,请各位指教

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

subShowDataGridview(DataGridView1, "Select * from table1", "连接数据库字符串")

End Sub

Public Sub subShowDataGridview(ByVal DataGridView As DataGridView, ByVal strCommandText As String, ByVal strConnectionSQLString As String)

Dim SqlConnection1 As New SqlConnection

Dim SqlDataAdapter1 As New SqlDataAdapter

Dim DataSet1 As New DataSet

SqlConnection1.ConnectionString = strConnectionSQLString

SqlDataAdapter1.InsertCommand.Connection = SqlConnection1

SqlConnection1.Open()

SqlDataAdapter1.InsertCommand.CommandText = strCommandText