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

VB.NetÖÐSQLµÄÁ¬½ÓÎÊÌ⣿

ÏÂÃæ´úÂëÁ¬½Ó³ö´í£¡ÔõÑùÔÚËüµÄ»ù´¡ÉÏÐ޸ģ¬Ê¹³ÌÐòÄÜÕý³£ÔËÐÐÄØ£¿
Âé·³´óÏÀÁË£¡
×Ô¼º¶¨ÒåµÄÈ«¾ÖÄ£¿é
Imports System.Data
Imports System.DBNull
Imports System.Data.SqlClient
Module Module1
    Public UserName As String
    Public pepdom As Integer
    Public CL As Integer
    Public M As Integer
    Public c_id As String = ""
    Public m_id As String = ""
    Public EN As Boolean
    Public o_id As String
    Public SU As Double
    '¶¨ÒåϵͳµÄ¹«¹²±äÁ¿'
    Public objDataSet As DataSet
    '¶¨ÒåÒ»¸öÊý¾Ý¼¯¶ÔÏó'
    Public objDataView As DataView
    '¶¨ÒåÒ»¸öÊý¾ÝÊÓͼ¶ÔÏó'
    Public objDataAdpter As SqlDataAdapter
    '¶¨ÒåÒ»¸öÊý¾ÝÊÊÅäÆ÷¶ÔÏó'
    Public objSqlConnection As SqlConnection = New SqlConnection("data source=(local);initial catalog=FoodSvc;" & "intergrated security=SSPI;user id=sa")
    '¶¨ÒåÒ»¸öÊý¾ÝÁ¬½Ó¶ÔÏ󣬲¢³õʼ»¯'
    Public objCurrencyManager As CurrencyManager
    '¶¨ÒåÒ»¸öµ±Ç°µÄ°ó¶¨¹ÜÀí¶ÔÏó'
    Public UserSqlstr As String = "SELECT *from UserInfo"


Ïà¹ØÎÊ´ð£º

°ïÎҸĸÄÕâVBÌâ - VB / »ù´¡Àà

°ïÎÒ¸Ä¸Ä ÎÒ×ܾõµÃÓÐÎÊÌâ
Type ID
  number As Single
  score As Integer
  name As String * 6
End Type
Dim personl As ID, i%
Private Sub Command1_Click()
 i = 0
&nbs ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

SQLÈçºÎÓÅ»¯ÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì   »·¾³ÊÇSQL2000Êý¾Ý¿â  
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
        Ñ­»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)  
        ......

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ