VB µÇ¼ - VB / ÍøÂç±à³Ì
user_name = Trim(tbname.Text)
pwd = Trim(tbPwd.Text)
If user_name <> "" Then
Adodc1.Recordset.MoveFirst '´ÓµÚÒ»Ìõ¼Ç¼¿ªÊ¼²é¿´
Adodc1.Recordset.Find ("user =" & "'" & user_name & "'")
If user_name = Adodc1.Recordset.Fields(0) And pwd = Adodc1.Recordset.Fields(2) Then
MsgBox "µÇ¼³É¹¦£¡"
USER_FUN.Show
ElseIf user_name <> Adodc1.Recordset.Fields(0) Then
MsgBox "Óû§Ãû´íÎó£¡", vbOKOnly + vbInformation, "Ìáʾ"
tbname.Text = ""
tbPwd.Text = ""
tbname.SetFocus
ElseIf pwd <> Adodc1.Recordset.Fields(2) Then
MsgBox "Óû§Ãû´íÎó£¡", vbOKOnly + vbInformation, "Ìáʾ"
tbPwd.Text = ""
Else
MsgBox "ϵͳ³öÏÖÎÊÌ⣡", vbCritical, "¾¯Ê¾"
End If
End If
ÔËÐÐʱÀϳöÏÖÓû§Ãû´íÎóµÄÌáʾ£¬ÕâÊÇʲôÔÒò£¿
²¹³ä£º
adodc1ÔÚÊôÐÔÖÐÉèÖÃÁËÁ¬½ÓSQL£¬
tbname£¬tbpwd¸úÊý¾Ý¿âuser±íµÄname,pwdÏîÔÚÊôÐÔÖÐÒ²ÉèÖÃÁËÁ¬½Ó
ÎÒ°ÑÃÜÂë´íÎóʱµÄÌáʾ¸ÄÁË£¬µ«»¹ÊÇÌáʾÓû§Ãû´íÎ󣬿ÉÄÜÊÇÊý¾Ý¿âÖеÄÄÚÈÝ´æÔÚ¿Õ¸ñ
Ôõô°ÑÊý¾Ý¿âÖеÄÄÚÈÝ´æÔڵĿոñÈ¥µãÄØ£¬Ò²ÓÃtrimÂð
ÊÇÁËÏ£¬¼ÓÉÏtrimÔËÐÐÍêÈ«ÕýÈ·
Ïà¹ØÎÊ´ð£º
DIM ds as new DataSet
ÎÒÕâÑùÉùÃ÷ ÔõÀÏÊDZ¨ Óû§¶¨ÒåÀàÐÍ䶨Ò壿 Õâ¸öÐèÒªÒýÓÃʲôÂ𣿣¿
ǰÌáÊÇDataSet¶ÔÏóÒª´æÔÚ,¾ÍÊǶÔÏóä¯ÀÀÆ÷ÖÐÓÐËü.ûÓоÍÒªÒýÓÃ.
datasetÊÇADO.NET¶ÔÏó
Èç¹ûÄãÓõÄÊÇvb.net£¬ÄÇôÔÚ´ ......
ÔÚvbÖÐÈçºÎ¶ÁÈ¡WordÄÚÈÝ(°üº¬±í¸ñ£¬Í¼Æ¬£¬µÈ£©
¾¹È»²»ÊÇzero¡£
²»ÖªµÀÔõôʵÏֵIJ»ÒªËµ»°
Õâ¸öÖ»ÄܶÁÎı¾,
VB code:
Private Sub Command1_Click()
Dim WordApp As Object
Set WordApp = CreateObject(& ......
vbÖÐ ÏÖÔÚÎÒÒª°ÑÊý¾Ý¿âÀï´æ´¢µÄÒ»¸ö¸½¼þµÄÄÚÈÝÌæ»»ÁË£¬Ôõô×ö£¬Ö»ÊÇÌæ»»ÎÒÖ¸¶¨µÄλÖ㬲»ÊÇÈ«²¿Ìæ»»
Ç뽫ÎÊÌâ˵Ã÷°×£¬´æ´¢×ֶθñʽ£¬Èç¹ûÊÇBinary¸ñʽµÄ±È½ÏÂé·³£¬Èç¹ûÊÇ×Ö´®£¬Ö±½ÓÌæ»»¡£×îºÃ²»Òª½øÐÐÖ¸¶¨Î»ÖÃÌæ»»¡ ......
ÏÖÔÚÓиöxmlÎļþÊÇ<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xm ......