OleDbParametes怎么用

[czsd]

如提

[czsd]

能不能给个例子

比如sql yu语句怎么写
后面怎么调用

[dahuzizyd]

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

[wacle]

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

[CMIC]

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();

[czsd]

我找了 没有这方面的samples

[雪狼1234567]

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

[雪狼1234567]

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

[czsd]

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

[hfayga]

在函数和过程中传入参数噻