what data provider are you using? seehttp://www.ondotnet.com/pub/a/dotnet/2002/12/16/multiresultsets_1202.html?page=2
解决方案 »
- StringBuilder 拼接 对防止sql注入有帮助么?
- SOS!!aspxgridView 控件获取点击单元格的列名与行名
- IE8浏览器下使用Ajax的AutoCompleteExtention控件做模糊查询下拉菜单匹配,没有显示下拉菜单!
- 如何在sql语句中格式化时间
- iis7 如何开启目录浏览
- hashtable和sortedlist的每一行纪录,都只能储存两个值,一个是key,一个是value,有没有其它的数组,在一行中可以储存更多的值?
- ASP.NET WebForm的一个奇怪问题
- VS.net 做的Asp.net程序,发布后,再使用记事本修改xxx.aspx.cs文件后,可不可以自动重新编译呀
- 高分请教数据库建表
- 想在公司自己的网站上开网上商店,怎么着手会较快较好,大家给点建议?
- 我在CSS定义了样式,想对一个NET控件设置其CSS样式怎么写?代码如下,结果不对
- 强烈推荐:Crystal Decisions 官方示例程序——Underground Office Supply(搜集:海波.NET)
{
OracleDataReader myDataReader;
Object my_DBNull; try {
my_DBNull = Convert.DBNull; //**************************************************************
//Get List of Specials by calling Procedure
//LISTBYSUBJECT_SAMPLE
//**************************************************************
//Procedure LISTBYSUBJECT_SAMPLE
// ( P_CURSOR OUT NILE_TYPES.NILE_CURSOR,
// SUBJECTIDIN INTEGER
// )
// AS
// BEGIN
// OPEN P_CURSOR FOR
// SELECT BOOKID, BOOKTITLE, AUTHOR, PRICE, RETAIL
// FROM PRODUCTS
// WHERE SUBJECTID = SUBJECTIDIN
// AND ROWNUM <= 5;
// END LISTBYSUBJECT_SAMPLE;
//**************************************************************
OracleDataReader myReader;
int subjectidin = 21;
OracleCommand myCommand = new OracleCommand();
myCommand.Connection = currentConnection;
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.CommandText = "LISTBYSUBJECT_SAMPLE";
//Oracle Procedure Requires RefCursor output parameter
myCommand.Parameters.Add(new OracleParameter("P_CURSOR",
OracleType.Cursor, 2000, ParameterDirection.Output,
true,0,0,"",DataRowVersion.Default, my_DBNull) );
myCommand.Parameters.Add(new OracleParameter("SUBJECTIDIN",
OracleType.Int32, 0, ParameterDirection.Input,
true,0,0,"",DataRowVersion.Default, my_DBNull) );
//set SUBJECTIDIN parameter value to 21 (Specials)
myCommand.Parameters[1].Value = subjectidin;
myDataReader = myCommand.ExecuteReader(); return (myDataReader);
}
catch (OracleException e) {
throw e;
}
}
SqlCommand oCmd = new SqlCommand();
oCmd.CommandType=CommandType.StoredProcedure;
oCmd.CommandText="ProName";
SqlParameter oPara=oCmd.Parameters.Add("@RecordCount",SqlType.Int);
oPara.Value=条件字符串;
oCmd.Connection=oConn;oConn.Open();
SqlDataAdapter oDa=new SqlDataAdapter(oCmd);
oDs.Fill(oDs);