OleDbParametes怎么用

Question

能不能给个例子 比如sql yu语句怎么写 
后面怎么调用

Answer 1

参考帮助：
.net框架 / 参考 / 类库 /System.Data.OleDb / OleDbPamrater类

Answer 2

一般与OleDbCommand结合在一起用
OleDbCommand cmd=new OleDbCommand(strSQL,cn);
cmd.Parameters.Add("@ID",OleDbType.Int); //type is OleDbParameter
cmd.Parameters["@ID"].Value=2;

Answer 3

OleDbParameter cmicPar=new OleDbParameter("@EditionID",OleDbType.Char,6);
cmicPar.Value=strEditionID;
OleDbCommand cmicCmd=new OleDbCommand("Delete MetalAllEdition " +
" where AllWeekId=0 and EditionID=@EditionID",
tempCn);
cmicCmd.Parameters.Add(cmicPar);
cmicCmd.ExecuteNonQuery();

Answer 4

我找了 没有这方面的samples

Answer 5

OleDbDataAdapter myAdapter = new OleDbDataAdapter("SELECT PropertyID, Name FROM Property", dbConnection);OleDbCommand iCmd = new OleDbCommand("INSERT INTO Property (Name) VALUES (?)", dbConnection);
iCmd.Parameters.Add(new OleDbParameter("Name", OleDbType.Char, 50));
myAdapter.InsertCommand=iCmd;OleDbCommand uCmd = new OleDbCommand("UPDATE Property SET Name=? WHERE PropertyID=?", dbConnection);
uCmd.Parameters.Add(new OleDbParameter("Name", OleDbType.Char, 50));
uCmd.Parameters.Add(new OleDbParameter("PropertyID", OleDbType.Numeric, 0));
myAdapter.UpdateCommand=uCmd;OleDbCommand dCmd = new OleDbCommand("DELETE FROM Property WHERE PropertyID=?", dbConnection);
dCmd.Parameters.Add(new OleDbParameter("PropertyID", OleDbType.Numeric, 0));
myAdapter.DeleteCommand=dCmd;详细看这儿
http://www.c-sharpcorner.com/Database/CustomDataAdapterDT.asp

Answer 6

OleDbDataAdapter myAdapter = new OleDbDataAdapter("SELECT PropertyID, Name FROM Property", dbConnection);OleDbCommand iCmd = new OleDbCommand("INSERT INTO Property (Name) VALUES (?)", dbConnection);
iCmd.Parameters.Add(new OleDbParameter("Name", OleDbType.Char, 50));
myAdapter.InsertCommand=iCmd;OleDbCommand uCmd = new OleDbCommand("UPDATE Property SET Name=? WHERE PropertyID=?", dbConnection);
uCmd.Parameters.Add(new OleDbParameter("Name", OleDbType.Char, 50));
uCmd.Parameters.Add(new OleDbParameter("PropertyID", OleDbType.Numeric, 0));
myAdapter.UpdateCommand=uCmd;OleDbCommand dCmd = new OleDbCommand("DELETE FROM Property WHERE PropertyID=?", dbConnection);
dCmd.Parameters.Add(new OleDbParameter("PropertyID", OleDbType.Numeric, 0));
myAdapter.DeleteCommand=dCmd;详细看这儿
http://www.c-sharpcorner.com/Database/CustomDataAdapterDT.asp

Answer 7

FileStream fs = File.OpenRead( pStrFilepath );

byte[] bytes = new byte[(int)fs.Length];
fs.Read(bytes, 0, bytes.Length);
fs.Close();

OleDbParameter a=new OleDbParameter("@id",OleDbType.Numeric  ,8 );
a.Value =1; OleDbParameter b=new OleDbParameter("@f",OleDbType.Binary ,bytes.Length );
b.Value =bytes;
string str="insert into test(a,b) values( @id,@f )";
OleDbCommand myCommand=new OleDbCommand(str,mConnection);

myCommand.Parameters.Add( a);
myCommand.Parameters.Add( b);
myCommand.ExecuteNonQuery();
我写了这样断代码 不知道错在哪里 
错误提示 An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll