ÈçºÎÔÚÊý¾Ý¼¯ÉÏʹÓÃsql²éѯÓï¾ä? - .NET¼¼Êõ / VB.NET

ÈçÓÐÊý¾Ý¼¯dataset1,Ìí³äÁËÒ»¸öÈËÔ±ÐÅÏ¢±ítable1(ID,ÐÕÃû,ÐÔ±ð)

ÎÒÏëÔÚÕâ¸ö±íÉϲéѯÐÕÃûΪÄеļǼ,²¢°ÑËûÃÇÌí¼Óµ½datagridview1ÉϸÃÔõô°ì,ÓеãÂÒÁË,ʵÔÚÏë²»ÆðÀ´ÁË.

ͬÀàÎÊÌâ,Èç¹ûÊý¾Ý¼¯ÖÐÓÐÁ½¸öÒÔÉϵıí,ÒªÏë½øÐи´ÔӵIJéѯ¸ÃÔõô°ì?

---

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

---