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"
Ïà¹ØÎÊ´ð£º
°ïÎÒ¸Ä¸Ä ÎÒ×ܾõµÃÓÐÎÊÌâ
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 ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......