在insert into 的values里如果是字符变量要怎么写?
如: cmd1=new OleDbCommand(insert into MyTable(Id,UserName,Date)values ('@String_Id','@String_UserName','@String_Date'),conn))不知为什么写不了数据库?!
如: cmd1=new OleDbCommand(insert into MyTable(Id,UserName,Date)values ('@String_Id','@String_UserName','@String_Date'),conn))不知为什么写不了数据库?!
string sqlInsert=@"insert into MyTable(Id, UserName, Date) values (@String_Id, @String_UserName, @String_Date)";
OleDbCommand cmd=new OleDbCommand(sqlInsert,conn);
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" +
@"Data source= E:\April30\Db\TestDb.mdb" ;
conn.Open();
string sqlInsert=@"insert into TestTable(Id,UserName,Date) values (@String_Id,@String_UserName,@String_Date)";
OleDbCommand cmd1=new OleDbCommand(sqlInsert,conn);
Console.WriteLine("Command Created");
cmd1.ExecuteNonQuery();//执行插入
Console.WriteLine("insert end");
conn.Close();
注意:intA是整形,strB是字符型
insert into t1(intA,strB)values(100,'abc')