111,104
社区成员
发帖
与我相关
我的任务
分享在c#组件中怎么读及赋值oracle的clob字段的内容？
我要在组件中，通过OLEDBCommand的ExecuteScalar()方法返回一个CLOB字段值，
总报超出范围的错，各位有什么好办法加以实现吗?(不通过存储过程写)
strReturn = cmdOle.ExecuteScalar();
objReturn = (object)strReturn;
总报超出范围的错，各位有什么好办法加以实现吗?(不通过存储过程写)
strReturn = cmdOle.ExecuteScalar();
objReturn = (object)strReturn;
...全文
请发表友善的回复…
发表回复
GiantHard 2002-12-31
- 打赏
- 举报
是不是你的cmdOle检索到的数据集里没有记录啊？
或者换种方法
public void CreateMyOleDbDataReader(string mySelectQuery,string myConnectionString)
{
OleDbConnection myConnection = new OleDbConnection(myConnectionString);
OleDbCommand myCommand = new OleDbCommand(mySelectQuery, myConnection);
myCommand.Connection.Open();
OleDbDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
while(myReader.Read())
{
Console.WriteLine(myReader.GetString(0));
}
myReader.Close();
myConnection.Close();
}
或者换种方法
public void CreateMyOleDbDataReader(string mySelectQuery,string myConnectionString)
{
OleDbConnection myConnection = new OleDbConnection(myConnectionString);
OleDbCommand myCommand = new OleDbCommand(mySelectQuery, myConnection);
myCommand.Connection.Open();
OleDbDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
while(myReader.Read())
{
Console.WriteLine(myReader.GetString(0));
}
myReader.Close();
myConnection.Close();
}
