怎么样才能把查到的数据加载DATAGRID中??

[zz0596]

Dim mydate As String
mydate = TxtYear.Text & "-" & CmbMonth.Text & " -" & TxtDay.Text
Dim cmb As New SqlCommand("select * from 销售表 where 日期 = '" & mydate & "'")
cmb.Connection = SqlConn1
SqlConn1.Open()
cmb.ExecuteNonQuery()
SqlConn1.Close()
要把查找到的数据加载到DATAGRID中,怎么样做?谢谢

[机器人]

Dim mydate As String
mydate = TxtYear.Text & "-" & CmbMonth.Text & " -" & TxtDay.Text
Dim cmb As New SqlCommand("select * from 销售表 where 日期 = '" & mydate & "'")
cmb.Connection = SqlConn1
Dim dataAdapter As SqlDataAdapter = New SqlDataAdapter
dataAdapter.SelectCommand = cmb
Dim dt As DataTable = New DataTable
dataAdapter.Fill(dt)
Me.DataGrid1.DataSource = dt

建议楼主，好好看看MSDN

[zz0596]

谢谢,会的