public class sqlConn
{
public OleDbConnection Conn;
public void SetUpConn(string MdbName)
{
string strConnection ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
strConnection += Application.StartupPath + MdbName;
Conn = new OleDbConnection(strConnection);
Conn.Open();
string sqlstring = "Insert Into Table(Name,Pwd) Values('Test','123456')";
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = Conn;
cmd.CommandText=sqlstring;
}
}偶执行
sqlConn conn = new sqlConn();
conn.SetUpConn("\\text.mdb");
但不知道为什么,数据库没有记录增加,也没提示错误我看了一下strConnection,路径也正确的!
{
public OleDbConnection Conn;
public void SetUpConn(string MdbName)
{
string strConnection ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
strConnection += Application.StartupPath + MdbName;
Conn = new OleDbConnection(strConnection);
Conn.Open();
string sqlstring = "Insert Into Table(Name,Pwd) Values('Test','123456')";
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = Conn;
cmd.CommandText=sqlstring;
}
}偶执行
sqlConn conn = new sqlConn();
conn.SetUpConn("\\text.mdb");
但不知道为什么,数据库没有记录增加,也没提示错误我看了一下strConnection,路径也正确的!
cmd.ExecuteNonQuery(); //执行你的insert 命令