string strConn=@"provider=microsoft.jet.oledb.4.0;data source=D:\*.mdb";
string strSql="INSERT INTO DTS(ID,NAME) VAULES('12','WEF');";
OleDbConnection oCn=new OleDbConnection(strConn);
oCn.Open();
OleDbCommand oCmd1=new OleDbCommand(strSql,oCn);
oCmd1.ExecuteNonQuery();
oCn.Close();
在access中不可以直接插入数据么?
在SQL SERVER中插入成功,为什么?谢谢大家给点意见吧?
string strSql="INSERT INTO DTS(ID,NAME) VAULES('12','WEF');";
OleDbConnection oCn=new OleDbConnection(strConn);
oCn.Open();
OleDbCommand oCmd1=new OleDbCommand(strSql,oCn);
oCmd1.ExecuteNonQuery();
oCn.Close();
在access中不可以直接插入数据么?
在SQL SERVER中插入成功,为什么?谢谢大家给点意见吧?
OleDbConnection db=new System.Data.OleDb.OleDbConnection(strcom);
db.Open();
string inserts=" insert into 表 (数据表当中的字段) values (";
inserts+=TextBox1.Text + " , '";
inserts+=TextBox2.Text + "' , '";
inserts+=TextBox3.Text + " ', '";
inserts+=TextBox4.Text + " ',";
inserts+=TextBox5.Text + " ,";
inserts+=TextBox6.Text + " )";
OleDbCommand myCommand=new OleDbCommand (inserts,db);
myCommand.ExecuteNonQuery();
db.Close();
string strSql="INSERT INTO DTS(ID,NAME) VAULES('"+12+"','"+WEF+"');";试试看呢,
错了.....
string strcom="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=*.mdb";Microsoft.Jet.OLEDB.4.0分大小写.....
string strSql="INSERT INTO DTS(ID,Date) VAULES('12','2005/01/02')";WHY???谢谢大家指点!·!