同类问题,如果数据集中有两个以上的表,要想进行复杂的查询该怎么办?Dim nn As New SqlClient.SqlConnection nn.ConnectionString = "Data Source=(local);Initial Catalog='数据库名';Integrated Security=SSPI" nn.Open() Dim kz As New SqlClient.SqlDataAdapter(select * from table where 性别='男', nn) Dim da As New DataTable kz.Fill(da) datagridview1.DataSource=da 两个表以上进行复杂查询的话，用它们之间的主键进行联系就可以了！ Dim str As String Dim ds As New DataSet Dim da As SqlDataAdapter str = "data source=localhost;initial catalog=表格名;integrated security=true" Dim con As New SqlConnection(str) con.Open() Dim sql As String = "select * from 表格名" da = New SqlDataAdapter(sql, con) da.Fill(ds) DataGrid1.DataSource = ds.Tables(0) VB.NET code: Dim dv As DataView = dataset1.Tables(0).DefaultView dv.RowFilter = "性别='男'" datagridview1.DataSource=dv
我想把word另存为xml之后，用vb读取这个xml的内容，请问如何实现？ dim f as integer dim b() as byte dim s as string dim L as long f=freefile() open "abc.xml" for binary access read as #f ......
Private Sub Command1_Click() Dim MyString() As String Open "a.xml" For Binary As #1 ' 打开刚创建的文件。 ReDim MyString(LOF(1) - 1) Put #1, , MyRecord ' 读入所有字符到变量中 ......
