Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÈçºÎÔÚÊý¾Ý¼¯ÉÏʹÓÃ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




Ïà¹ØÎÊ´ð£º

vb - VB / »ù´¡Àà

ÔÚvbÖÐÈçºÎ¶ÁÈ¡WordÄÚÈÝ(°üº¬±í¸ñ£¬Í¼Æ¬£¬µÈ£©
¾¹È»²»ÊÇzero¡£

²»ÖªµÀÔõôʵÏֵIJ»ÒªËµ»°

Õâ¸öÖ»ÄܶÁÎı¾,
VB code:
Private Sub Command1_Click()
Dim WordApp As Object
Set WordApp = CreateObject(& ......

vb - VB / »ù´¡Àà

ÎÒÏë°Ñ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
......

vb - VB / »ù´¡Àà

vbÖÐ ÏÖÔÚÎÒÒª°ÑÊý¾Ý¿âÀï´æ´¢µÄÒ»¸ö¸½¼þµÄÄÚÈÝÌæ»»ÁË£¬Ôõô×ö£¬Ö»ÊÇÌæ»»ÎÒÖ¸¶¨µÄλÖ㬲»ÊÇÈ«²¿Ìæ»»
Ç뽫ÎÊÌâ˵Ã÷°×£¬´æ´¢×ֶθñʽ£¬Èç¹ûÊÇBinary¸ñʽµÄ±È½ÏÂé·³£¬Èç¹ûÊÇ×Ö´®£¬Ö±½ÓÌæ»»¡£×îºÃ²»Òª½øÐÐÖ¸¶¨Î»ÖÃÌæ»»¡ ......

sql ÎÊÌâ - MS-SQL Server / »ù´¡Àà

ÐèÇóÈçÏ£º
ѧԺ academy£¨aid,aname£©
°à¼¶ class£¨cid,cname,aid£©
ѧÉú stu(sid,sname,aid,cid)
סËÞÇø region(rid,rname)
ËÞÉáÂ¥ build(bid,rid,bnote) bnoteÊÇ¡®ÄС¯/¡®Å®¡¯
ËÞÉá dorm(did,rid,bid£¬bedn ......

¹ØÓÚSqlµÄÎÊÌâ - .NET¼¼Êõ / ASP.NET

½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡


¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡

Ö±½ÓÖ´ÐоÍÐÐÁË

exec ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ