c#公共类直接调方法
C# codeusing System;
using System.Collections.Generic;
using System.Data;
using System.Data.OracleClient;
using System.Web.UI.WebControls;
namespace DBClass
{
public class DBClass
{
#region -- 获取数据库的连接 GetOracleConnection()
/// <summary>
/// 获取数据库的连接
/// </summary>
/// <returns></returns>
public OracleConnection GetOracleConnection()
{
string strCon = System.Configuration.ConfigurationManager.AppSettings["strConnect"].ToString();
try
{
OracleConnection myConn = new OracleConnection(strCon);
myConn.Open();
return myConn;
}
catch (Exception ex)
{
string error = ex.Message;
return null;
}
}
#endregion
#region -- 获取第一行的第一列 GetFistString(string strSql)
/// <summary>
/// 获取第一行的第一列
/// </summary>
/// <param name="strSql"></param>
/// <returns></returns>
public string GetFistString(string strSql)
{
OracleConnection conn = GetOracleConnection();
OracleCommand myComm = new OracleCommand(strSql, conn);
try
{
return myComm.ExecuteScalar().ToString();
}
catch (Exception ex)
{
string error = ex.Message;
r