110,538
社区成员
发帖
与我相关
我的任务
分享
public int DbExecuteNonQueryByte(string _strConn, string strSql, string fid,string fname,string fdir_id,Byte[] fvalue,string fuse)
{
Database db = DatabaseFactory.CreateDatabase(_strConn);
DbCommand dbCommand = db.GetSqlStringCommand(strSql);
db.AddInParameter(dbCommand, "@fid", DbType.String, fid);
db.AddInParameter(dbCommand, "@fname", DbType.String, fname);
db.AddInParameter(dbCommand, "@fdir_id", DbType.String, fdir_id);
db.AddInParameter(dbCommand, "@fvalue", DbType.Binary, fvalue);
db.AddInParameter(dbCommand, "@fuse", DbType.String, fuse);
return db.ExecuteNonQuery(dbCommand);
}
INSERT INTO [table](id1, id2) values(@ID1, @ID2)
db.AddInParameter(dbCommand, "@ID1", DbType.String, id1);