插入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 + "')";