读书人

GetTopRecord解决方法

发布时间: 2012-04-28 11:49:53 作者: rapoo

GetTopRecord
public static string[] GetTopRecord(OracleConnection conn, OracleTransaction trans, CommandType cmdType, string cmdText, params OracleParameter[] cmdParms)
{
string[] strArray = null;
OracleCommand cmd = new OracleCommand();
PrepareCommand(cmd, conn, trans, cmdType, cmdText, cmdParms);
OracleDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
strArray = new string[reader.FieldCount];
for (int i = 0; i < reader.FieldCount; i++)
{
strArray[i] = reader.IsDBNull(i) ? string.Empty : reader.GetValue(i).ToString();
}
}
reader.Close();
return strArray;
}






[解决办法]
不知道你想说你的错误是什么

但是你的代码有问题的

C# code
public static string[] GetTopRecord(OracleConnection conn, OracleTransaction trans, CommandType cmdType, string cmdText, params OracleParameter[] cmdParms)    {        OracleCommand cmd = null;        OracleDataReader reader = null;        try        {            string[] strArray = null;            cmd = new OracleCommand();            //绑定cmd参数,链接,并且打开数据库链接            PrepareCommand(cmd, conn, trans, cmdType, cmdText, cmdParms);            reader = cmd.ExecuteReader();            if (reader.Read())            {                strArray = new string[reader.FieldCount];                for (int i = 0; i < reader.FieldCount; i++)                {                    strArray[i] = reader.IsDBNull(i) ? string.Empty : reader.GetValue(i).ToString();                }            }            return strArray;        }        finally        {            if (!reader.IsClosed)            {                reader.Close();                reader.Dispose();                reader = null;            }            cmd.Dispose();            if (conn != null && conn.State != ConnectionState.Closed)            {                conn.Close();                conn.Dispose();                conn = null;            }        }    } 

读书人网 >C#

热点推荐