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

²åÈë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 + "')";



Ïà¹ØÎÊ´ð£º

Access導³öExecl

VB+Access×öµÄϵ統£¬
為·½±ã²é閱與´òÓ¡£¬
Ðè導³ö為execl±í¸ñ£¬
help¡£
環¾³£ºAccess±íÊÇAccess 2000£»

ÍøÉϺܶà,°Ù¶ÈÒ»ÏÂ

¹Ø×¢£¡

´°Ìå´úÂë
VB ......

ΪʲôÔÚaccessÀ¸üÐÂupdate£¬É¾³ýdelete²»ÐÐ?

±¾ÈËÔÚ±àдһ¸öСÐÍÍøÕ¾£¬Êý¾Ý¿âÊÇAccessµÄ£¬ÆäÖÐÓÐÒ»¸ö±íÃûΪ:user,×Ö¶ÎΪÈçÏÂ:

USERID(Ö÷¼ü£¬×Ô¶¯±àºÅ),
ID(Îı¾),
password£¨Îı¾£©,
txtEmail(Îı¾)

Àý£ºÖ´ÐÐÒÔÏÂupdateÓï¾ä£¬ÌáʾÎÞ·¨¸ü ......

Á¬½ÓACCESSÊý¾Ý¿â²ÎÊýÎÊÌâ

ÎÒÔÚACCESS²éѯÖн¨Á¢ÁËÒ»¸ö²éѯ,ÐèÒªÊäÈëÒ»¸ö²ÎÊý.

¼´Ë«»÷²éѯʱ,Ìø³ö"ÊäÈë²ÎÊýÖµ",È»ºóÊÖ¶¯ÊäÈëÏàÓ¦×Ö·û,²éѯ³É¹¦.

ÏÖÔÚÎÊÌâÊÇÔÚASPÖÐÖ±½Óµ÷ÓòéѯÏÔʾ"ÖÁÉÙÒ»¸ö²ÎÊýûÓб»Ö¸¶¨Öµ&qu ......

Access²éÕÒÖØ¸´ÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ