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