²åÈëACCESSÊý¾Ý¿â³ö´í
C# code:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;
namespace DAL
{
public class DBHelp
{
public static int add(string name, string pwd)
{
//Á¬½ÓÊý¾Ý¿â
string connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\WEB\\EasyTree\\Web\\App_Data\\EasyTree.mdb";
OleDbConnection thisconn = new OleDbConnection(connstr);
thisconn.Open();
//²åÈë¼Ç¼
string sql = "INSERT user (name,password) VALUES (@name,@pwd)";
OleDbCommand thiscmd = new OleDbCommand ();
thiscmd.Connection = thisconn;
thiscmd.CommandText = sql;
int n= thiscmd.ExecuteNonQuery();
//¹Ø±ÕÁ¬½Ó
thisconn.Close();
return n;
}
}
}
ÏÖÔÚÖ÷Á÷µÄAccessºÍSQLÔöɾ¸ÄµÄÓï¾äËÓУ¬ÄܸøÁ´½ÓÂð£¿
Ôö¼Ó
INSERT
ɾ³ý
DELETE
ÐÞ¸Ä
UPDATE
Â¥ÉÏÈ˲ţ¬ÎÒÍüÁË˵ÁË£¬ÎÒÕâ¸ö³ÌÐòÓдíÎ󡣡£¡£¡£
string sql = "INSERT user (name,password) VALUES (@name,@pwd)";
д·¨ºÃÏñ²»¶Ô£¬µ÷ÊÔ²»¹ýÈ¥¡£
string sql = "INSERT user (name,password) VALUES ('" + name + "','" + pwd + "')";
Ïà¹ØÎÊ´ð£º
VB+Access×öµÄϵ統£¬
為·½±ã²é閱與´òÓ¡£¬
Ðè導³ö為execl±í¸ñ£¬
help¡£
環¾³£ºAccess±íÊÇAccess 2000£»
ÍøÉϺܶà,°Ù¶ÈÒ»ÏÂ
¹Ø×¢£¡
´°Ìå´úÂë
VB ......
±¾ÈËÔÚ±àдһ¸öСÐÍÍøÕ¾£¬Êý¾Ý¿âÊÇAccessµÄ£¬ÆäÖÐÓÐÒ»¸ö±íÃûΪ:user,×Ö¶ÎΪÈçÏÂ:
USERID(Ö÷¼ü£¬×Ô¶¯±àºÅ),
ID(Îı¾),
password£¨Îı¾£©,
txtEmail(Îı¾)
Àý£ºÖ´ÐÐÒÔÏÂupdateÓï¾ä£¬ÌáʾÎÞ·¨¸ü ......
ÎÒÔÚACCESS²éѯÖн¨Á¢ÁËÒ»¸ö²éѯ,ÐèÒªÊäÈëÒ»¸ö²ÎÊý.
¼´Ë«»÷²éѯʱ,Ìø³ö"ÊäÈë²ÎÊýÖµ",È»ºóÊÖ¶¯ÊäÈëÏàÓ¦×Ö·û,²éѯ³É¹¦.
ÏÖÔÚÎÊÌâÊÇÔÚASPÖÐÖ±½Óµ÷ÓòéѯÏÔʾ"ÖÁÉÙÒ»¸ö²ÎÊýûÓб»Ö¸¶¨Öµ&qu ......
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......