如何在数据集上使用sql查询语句? - .NET技术 / VB.NET

如有数据集dataset1,添充了一个人员信息表table1(ID,姓名,性别)

我想在这个表上查询姓名为男的记录,并把他们添加到datagridview1上该怎么办,有点乱了,实在想不起来了.

同类问题,如果数据集中有两个以上的表,要想进行复杂的查询该怎么办?

---

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

---