我用的是OleDB方式,道理是一样的
Form 上就一个DataGridView1控件
在Form的Load事件中写上这些就工作正常
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim con As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\我的文档\Visual Studio 2005\Projects\ValveDesigner\ValveDesigner\bin\Debug\ValveDataBase.mdb")
con.Open()
Dim cmd As New OleDb.OleDbCommand("select * from 阀门类型表 where 阀门编号 ='" & "ZF001" & "'", con)
Dim ds As New DataSet
Dim da As New OleDb.OleDbDataAdapter
da.SelectCommand = cmd
da.Fill(ds)
Me.DataGridView1.DataSource = ds.Tables(0)
con.Close()
我想在DATAGRID 中显示数据库中数据集
Dim con As New SqlConnection("workstation id=AFEN;packet size=4096;integrated security=SSPI;data source=AFEN;persist security info=False;initial catalog=图书馆系统")
con.Open()
Dim a As String
a = TextBox1.Modified
Dim cmd As New SqlCommand("select * from 读者信息 where 类型 ='“& textbox1.text &'", con)
Dim ds As New DataSet
Dim da As New SqlDataAdapter
da.SelectCommand = cmd
da.Fill(ds)
但是只显示出表格,没有显示出类容