連接任何數據庫
来源:互联网 发布:淘宝商城男装t恤阿玛尼 编辑:程序博客网 时间:2024/04/30 12:41
using System;
using System.Data;
using System.Data.Common;
using System.Data.OleDb;
using System.Data.SqlClient;
namespace DBSpaceName
{
/**//// <summary>
///數據庫操作
/// </summary>
public class ExecuteDB : Connection
{
private System.Data.IDbCommand _command;
private System.Data.IDataAdapter _dataAdaper;
public ExecuteDB(){}
Execute Sql#region Execute Sql
/**//// <summary>
/// Execute the Sql
/// </summary>
/// <param name="sqlString">String for Sql</param>
/// <returns>Succeed</returns>
public static bool ExecuteSql(string sqlString)
{
try
{
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
Conn.Open();
command.CommandText = sqlString;
command.ExecuteNonQuery();
command.Dispose();
Conn.Close();
Conn.Dispose();
return true;
}
catch(Exception exc)
{
Connection.ErrorInfo =exc.ToString();
return false;
}
}
/**//// <summary>
/// Execute the Sql
/// </summary>
/// <param name="sqlString">String for Sql</param>
/// <returns>IDataReader</returns>
public static IDataReader ExecuteSqlDataReader(string sqlString)
{
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
Conn.Open();
IDataReader dataReader;
command.CommandText = sqlString;
dataReader = command.ExecuteReader(CommandBehavior.CloseConnection);
return dataReader;
}
/**//// <summary>
/// Execute the Sql
/// </summary>
/// <param name="sqlString">String for Sql</param>
/// <returns>DataSet</returns>
public static DataSet ExcuteSqlDataSet(string sqlString)
{
DataSet ds = new DataSet();
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
Conn.Open();
command.CommandText = sqlString;
DbDataAdapter dataAdaper = DataFactory.CreateAdapter(command,Connection.DBType);
dataAdaper.Fill(ds);
command.Dispose();
Conn.Close();
Conn.Dispose();
return ds;
}
#endregion
Execute Procedure#region Execute Procedure
/**//// <summary>
/// Excecute Procedure for not return value
/// </summary>
/// <param name="proName">the name of the procedure</param>
public static void ExecutePro_void(string proName)
{
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
Conn.Open();
command.CommandText = proName;
command.CommandType = CommandType.StoredProcedure;
command.ExecuteNonQuery();
command.Dispose();
Conn.Close();
Conn.Dispose();
}
/**//// <summary>
/// Excecute Procedure for not return value
/// </summary>
/// <param name="proName">the name of the Procudure</param>
/// <param name="parameterName">the name for the Parameter</param>
/// <param name="parameterValue"></param>
public static void ExecutePro_void(string proName,string parameterName,string parameterValue)
{
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
Conn.Open();
command.CommandText = proName;
command.CommandType = CommandType.StoredProcedure;
IDataParameter parameter = DataFactory.CreateParameter(parameterName,parameterValue,ParameterDirection.Input,Connection.DBType);
command = DataFactory.CreateCommand(command,parameter);
command.ExecuteNonQuery();
command.Dispose();
Conn.Close();
Conn.Dispose();
}
/**//// <summary>
/// Excecute Procedure for not return value
/// </summary>
/// <param name="proName">the name of the Procudure</param>
/// <param name="parameterName">the names for the Parameter</param>
/// <param name="parameterValue">the values for the Parameter</param>
public static void ExecutePro_void(string proName,string[] parameterName,object[] parameterValue)
{
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
Conn.Open();
command.CommandText = proName;
command.CommandType = CommandType.StoredProcedure;
IDataParameter[] parameter = new IDataParameter[parameterName.Length];
for(int i=0; i<parameterName.Length; i++)
{
parameter[i] = DataFactory.CreateParameter(parameterName[i],parameterValue[i],ParameterDirection.Input,Connection.DBType);
}
command = DataFactory.CreateCommand(command,parameter);
command.ExecuteNonQuery();
command.Dispose();
Conn.Close();
Conn.Dispose();
}
/**//// <summary>
/// Excecute Procedure
/// </summary>
/// <param name="proName">the name of the procedure</param>
/// <returns>object</returns>
public static object ExecutePro_object(string proName)
{
object returnValue = null;
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
Conn.Open();
command.CommandText = proName;
command.CommandType = CommandType.StoredProcedure;
IDataReader rs = command.ExecuteReader();
if(rs.Read()) returnValue = rs[0].ToString();
rs.Close();
rs.Dispose();
command.Dispose();
Conn.Close();
Conn.Dispose();
return returnValue;
}
/**//// <summary>
/// Excecute Procedure
/// </summary>
/// <param name="proName">the name of the Procedure</param>
/// <param name="parameterName">the name for parameter</param>
/// <param name="parameterValue">the value for parameter</param>
/// <returns>object</returns>
public static object ExecutePro_object(string proName,string parameterName,object parameterValue)
{
object returnValue = null;
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
Conn.Open();
command.CommandText = proName;
command.CommandType = CommandType.StoredProcedure;
IDataParameter parameter = DataFactory.CreateParameter(parameterName,parameterValue,ParameterDirection.Input,Connection.DBType);
command = DataFactory.CreateCommand(command,parameter);
IDataReader rs = command.ExecuteReader();
if(rs.Read()) returnValue = rs[0].ToString();
rs.Close();
rs.Dispose();
command.Dispose();
Conn.Close();
Conn.Dispose();
return returnValue;
}
/**//// <summary>
/// Excecute Procedure
/// </summary>
/// <param name="proName">the name of the Procedure</param>
/// <param name="parameterName">the names for parameter</param>
/// <param name="parameterValue">the values for parameter</param>
/// <returns>object</returns>
public static object ExecutePro_object(string proName,string[] parameterName,object[] parameterValue)
{
object returnValue = null;
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
Conn.Open();
command.CommandText = proName;
command.CommandType = CommandType.StoredProcedure;
IDataParameter[] myparam = new IDataParameter[parameterName.Length];
for(int i=0; i<parameterName.Length; i++)
{
myparam[i] = DataFactory.CreateParameter(parameterName[i],parameterValue[i],ParameterDirection.Input,DBType);
}
command = DataFactory.CreateCommand(command,myparam);
IDataReader rs = command.ExecuteReader();
if(rs.Read()) returnValue = rs[0].ToString();
rs.Close();
rs.Dispose();
command.Dispose();
Conn.Close();
Conn.Dispose();
return returnValue;
}
/**//// <summary>
/// Excecute Procedure
/// </summary>
/// <param name="proName">the name of the procedure</param>
/// <returns>IDataReader</returns>
public static IDataReader ExecutePro_DataReader(string proName)
{
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
Conn.Open();
command.CommandText = proName;
command.CommandType = CommandType.StoredProcedure;
return command.ExecuteReader(CommandBehavior.CloseConnection);
}
/**//// <summary>
/// Excecute Procedure
/// </summary>
/// <param name="proName">the name of the procedure</param>
/// <param name="parameterName">the name for parameter</param>
/// <param name="parameterValue">the value for parameter</param>
/// <returns>IDataReader</returns>
public static IDataReader ExecutePro_DataReader(string proName, string parameterName, string parameterValue)
{
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
Conn.Open();
command.CommandText = proName;
command.CommandType = CommandType.StoredProcedure;
IDataParameter parameter = DataFactory.CreateParameter(parameterName,parameterValue,ParameterDirection.Input,Connection.DBType);
command = DataFactory.CreateCommand(command,parameter);
return command.ExecuteReader(CommandBehavior.CloseConnection);
}
/**//// <summary>
/// Excecute Procedure
/// </summary>
/// <param name="proName">the name of the procedure</param>
/// <param name="parameterName">the names for parameter</param>
/// <param name="parameterValue">the values for parameter</param>
/// <returns>IDataReader</returns>
public static IDataReader ExecutePro_DataReader(string proName, string[] parameterName, string[] parameterValue)
{
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
Conn.Open();
command.CommandText = proName;
command.CommandType = CommandType.StoredProcedure;
IDataParameter[] parameter = new IDataParameter[parameterName.Length];
for(int i=0; i<parameterName.Length; i++)
{
parameter[i] = DataFactory.CreateParameter(parameterName[i],parameterValue[i],ParameterDirection.Input,Connection.DBType);
}
command = DataFactory.CreateCommand(command,parameter);
return command.ExecuteReader(CommandBehavior.CloseConnection);
}
/**//// <summary>
/// Execute Procedure
/// </summary>
/// <param name="proName">the name for procedure</param>
/// <returns>DataSet</returns>
public static DataSet ExecutePro_DataSet(string proName)
{
DataSet ds = new DataSet();
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
command.CommandText = proName;
command.CommandType = CommandType.StoredProcedure;
DbDataAdapter dataAdaper = DataFactory.CreateAdapter(command,Connection.DBType);
dataAdaper.Fill(ds);
command.Dispose();
Conn.Close();
Conn.Dispose();
return ds;
}
/**//// <summary>
/// Execute Procedure
/// </summary>
/// <param name="proName">the name for procedure</param>
/// <param name="parameterName">the name of the parameter</param>
/// <param name="parameterValue">the value of the parameter</param>
/// <returns>DataSet</returns>
public static DataSet ExecutePro_DataSet(string proName, string parameterName, object parameterValue)
{
DataSet ds = new DataSet();
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
command.CommandText = proName;
command.CommandType = CommandType.StoredProcedure;
IDataParameter parameter = DataFactory.CreateParameter(parameterName,parameterValue,ParameterDirection.Input,Connection.DBType);
command = DataFactory.CreateCommand(command,parameter);
DbDataAdapter dataAdaper = DataFactory.CreateAdapter(command,Connection.DBType);
dataAdaper.Fill(ds);
command.Dispose();
Conn.Close();
Conn.Dispose();
return ds;
}
/**//// <summary>
/// Execute Procedure
/// </summary>
/// <param name="proName">the name for procedure</param>
/// <param name="parameterName">the name of the parameter</param>
/// <param name="parameterValue">the value of the parameter</param>
/// <returns>DataSet</returns>
public static DataSet ExecutePro_DataSet(string proName,string[] parameterName,object[] parameterValue)
{
DataSet ds = new DataSet();
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
command.CommandText = proName;
command.CommandType = CommandType.StoredProcedure;
IDataParameter[] myparam = new IDataParameter[parameterName.Length];
for(int i=0; i<parameterName.Length; i++)
{
myparam[i] = DataFactory.CreateParameter(parameterName[i],parameterValue[i],ParameterDirection.Input,DBType);
}
command = DataFactory.CreateCommand(command,myparam);
DbDataAdapter dataAdaper = DataFactory.CreateAdapter(command,Connection.DBType);
dataAdaper.Fill(ds);
command.Dispose();
Conn.Close();
Conn.Dispose();
return ds;
}
#endregion
}
}
using System.Data;
using System.Data.Common;
using System.Data.OleDb;
using System.Data.SqlClient;
namespace DBSpaceName
{
/**//// <summary>
///數據庫操作
/// </summary>
public class ExecuteDB : Connection
{
private System.Data.IDbCommand _command;
private System.Data.IDataAdapter _dataAdaper;
public ExecuteDB(){}
Execute Sql#region Execute Sql
/**//// <summary>
/// Execute the Sql
/// </summary>
/// <param name="sqlString">String for Sql</param>
/// <returns>Succeed</returns>
public static bool ExecuteSql(string sqlString)
{
try
{
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
Conn.Open();
command.CommandText = sqlString;
command.ExecuteNonQuery();
command.Dispose();
Conn.Close();
Conn.Dispose();
return true;
}
catch(Exception exc)
{
Connection.ErrorInfo =exc.ToString();
return false;
}
}
/**//// <summary>
/// Execute the Sql
/// </summary>
/// <param name="sqlString">String for Sql</param>
/// <returns>IDataReader</returns>
public static IDataReader ExecuteSqlDataReader(string sqlString)
{
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
Conn.Open();
IDataReader dataReader;
command.CommandText = sqlString;
dataReader = command.ExecuteReader(CommandBehavior.CloseConnection);
return dataReader;
}
/**//// <summary>
/// Execute the Sql
/// </summary>
/// <param name="sqlString">String for Sql</param>
/// <returns>DataSet</returns>
public static DataSet ExcuteSqlDataSet(string sqlString)
{
DataSet ds = new DataSet();
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
Conn.Open();
command.CommandText = sqlString;
DbDataAdapter dataAdaper = DataFactory.CreateAdapter(command,Connection.DBType);
dataAdaper.Fill(ds);
command.Dispose();
Conn.Close();
Conn.Dispose();
return ds;
}
#endregion
Execute Procedure#region Execute Procedure
/**//// <summary>
/// Excecute Procedure for not return value
/// </summary>
/// <param name="proName">the name of the procedure</param>
public static void ExecutePro_void(string proName)
{
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
Conn.Open();
command.CommandText = proName;
command.CommandType = CommandType.StoredProcedure;
command.ExecuteNonQuery();
command.Dispose();
Conn.Close();
Conn.Dispose();
}
/**//// <summary>
/// Excecute Procedure for not return value
/// </summary>
/// <param name="proName">the name of the Procudure</param>
/// <param name="parameterName">the name for the Parameter</param>
/// <param name="parameterValue"></param>
public static void ExecutePro_void(string proName,string parameterName,string parameterValue)
{
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
Conn.Open();
command.CommandText = proName;
command.CommandType = CommandType.StoredProcedure;
IDataParameter parameter = DataFactory.CreateParameter(parameterName,parameterValue,ParameterDirection.Input,Connection.DBType);
command = DataFactory.CreateCommand(command,parameter);
command.ExecuteNonQuery();
command.Dispose();
Conn.Close();
Conn.Dispose();
}
/**//// <summary>
/// Excecute Procedure for not return value
/// </summary>
/// <param name="proName">the name of the Procudure</param>
/// <param name="parameterName">the names for the Parameter</param>
/// <param name="parameterValue">the values for the Parameter</param>
public static void ExecutePro_void(string proName,string[] parameterName,object[] parameterValue)
{
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
Conn.Open();
command.CommandText = proName;
command.CommandType = CommandType.StoredProcedure;
IDataParameter[] parameter = new IDataParameter[parameterName.Length];
for(int i=0; i<parameterName.Length; i++)
{
parameter[i] = DataFactory.CreateParameter(parameterName[i],parameterValue[i],ParameterDirection.Input,Connection.DBType);
}
command = DataFactory.CreateCommand(command,parameter);
command.ExecuteNonQuery();
command.Dispose();
Conn.Close();
Conn.Dispose();
}
/**//// <summary>
/// Excecute Procedure
/// </summary>
/// <param name="proName">the name of the procedure</param>
/// <returns>object</returns>
public static object ExecutePro_object(string proName)
{
object returnValue = null;
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
Conn.Open();
command.CommandText = proName;
command.CommandType = CommandType.StoredProcedure;
IDataReader rs = command.ExecuteReader();
if(rs.Read()) returnValue = rs[0].ToString();
rs.Close();
rs.Dispose();
command.Dispose();
Conn.Close();
Conn.Dispose();
return returnValue;
}
/**//// <summary>
/// Excecute Procedure
/// </summary>
/// <param name="proName">the name of the Procedure</param>
/// <param name="parameterName">the name for parameter</param>
/// <param name="parameterValue">the value for parameter</param>
/// <returns>object</returns>
public static object ExecutePro_object(string proName,string parameterName,object parameterValue)
{
object returnValue = null;
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
Conn.Open();
command.CommandText = proName;
command.CommandType = CommandType.StoredProcedure;
IDataParameter parameter = DataFactory.CreateParameter(parameterName,parameterValue,ParameterDirection.Input,Connection.DBType);
command = DataFactory.CreateCommand(command,parameter);
IDataReader rs = command.ExecuteReader();
if(rs.Read()) returnValue = rs[0].ToString();
rs.Close();
rs.Dispose();
command.Dispose();
Conn.Close();
Conn.Dispose();
return returnValue;
}
/**//// <summary>
/// Excecute Procedure
/// </summary>
/// <param name="proName">the name of the Procedure</param>
/// <param name="parameterName">the names for parameter</param>
/// <param name="parameterValue">the values for parameter</param>
/// <returns>object</returns>
public static object ExecutePro_object(string proName,string[] parameterName,object[] parameterValue)
{
object returnValue = null;
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
Conn.Open();
command.CommandText = proName;
command.CommandType = CommandType.StoredProcedure;
IDataParameter[] myparam = new IDataParameter[parameterName.Length];
for(int i=0; i<parameterName.Length; i++)
{
myparam[i] = DataFactory.CreateParameter(parameterName[i],parameterValue[i],ParameterDirection.Input,DBType);
}
command = DataFactory.CreateCommand(command,myparam);
IDataReader rs = command.ExecuteReader();
if(rs.Read()) returnValue = rs[0].ToString();
rs.Close();
rs.Dispose();
command.Dispose();
Conn.Close();
Conn.Dispose();
return returnValue;
}
/**//// <summary>
/// Excecute Procedure
/// </summary>
/// <param name="proName">the name of the procedure</param>
/// <returns>IDataReader</returns>
public static IDataReader ExecutePro_DataReader(string proName)
{
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
Conn.Open();
command.CommandText = proName;
command.CommandType = CommandType.StoredProcedure;
return command.ExecuteReader(CommandBehavior.CloseConnection);
}
/**//// <summary>
/// Excecute Procedure
/// </summary>
/// <param name="proName">the name of the procedure</param>
/// <param name="parameterName">the name for parameter</param>
/// <param name="parameterValue">the value for parameter</param>
/// <returns>IDataReader</returns>
public static IDataReader ExecutePro_DataReader(string proName, string parameterName, string parameterValue)
{
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
Conn.Open();
command.CommandText = proName;
command.CommandType = CommandType.StoredProcedure;
IDataParameter parameter = DataFactory.CreateParameter(parameterName,parameterValue,ParameterDirection.Input,Connection.DBType);
command = DataFactory.CreateCommand(command,parameter);
return command.ExecuteReader(CommandBehavior.CloseConnection);
}
/**//// <summary>
/// Excecute Procedure
/// </summary>
/// <param name="proName">the name of the procedure</param>
/// <param name="parameterName">the names for parameter</param>
/// <param name="parameterValue">the values for parameter</param>
/// <returns>IDataReader</returns>
public static IDataReader ExecutePro_DataReader(string proName, string[] parameterName, string[] parameterValue)
{
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
Conn.Open();
command.CommandText = proName;
command.CommandType = CommandType.StoredProcedure;
IDataParameter[] parameter = new IDataParameter[parameterName.Length];
for(int i=0; i<parameterName.Length; i++)
{
parameter[i] = DataFactory.CreateParameter(parameterName[i],parameterValue[i],ParameterDirection.Input,Connection.DBType);
}
command = DataFactory.CreateCommand(command,parameter);
return command.ExecuteReader(CommandBehavior.CloseConnection);
}
/**//// <summary>
/// Execute Procedure
/// </summary>
/// <param name="proName">the name for procedure</param>
/// <returns>DataSet</returns>
public static DataSet ExecutePro_DataSet(string proName)
{
DataSet ds = new DataSet();
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
command.CommandText = proName;
command.CommandType = CommandType.StoredProcedure;
DbDataAdapter dataAdaper = DataFactory.CreateAdapter(command,Connection.DBType);
dataAdaper.Fill(ds);
command.Dispose();
Conn.Close();
Conn.Dispose();
return ds;
}
/**//// <summary>
/// Execute Procedure
/// </summary>
/// <param name="proName">the name for procedure</param>
/// <param name="parameterName">the name of the parameter</param>
/// <param name="parameterValue">the value of the parameter</param>
/// <returns>DataSet</returns>
public static DataSet ExecutePro_DataSet(string proName, string parameterName, object parameterValue)
{
DataSet ds = new DataSet();
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
command.CommandText = proName;
command.CommandType = CommandType.StoredProcedure;
IDataParameter parameter = DataFactory.CreateParameter(parameterName,parameterValue,ParameterDirection.Input,Connection.DBType);
command = DataFactory.CreateCommand(command,parameter);
DbDataAdapter dataAdaper = DataFactory.CreateAdapter(command,Connection.DBType);
dataAdaper.Fill(ds);
command.Dispose();
Conn.Close();
Conn.Dispose();
return ds;
}
/**//// <summary>
/// Execute Procedure
/// </summary>
/// <param name="proName">the name for procedure</param>
/// <param name="parameterName">the name of the parameter</param>
/// <param name="parameterValue">the value of the parameter</param>
/// <returns>DataSet</returns>
public static DataSet ExecutePro_DataSet(string proName,string[] parameterName,object[] parameterValue)
{
DataSet ds = new DataSet();
IDbConnection Conn = DataFactory.CreateConnection(Connection.ConnectionString,Connection.DBType);
IDbCommand command = DataFactory.CreateCommand(Connection.DBType,Conn);
command.CommandText = proName;
command.CommandType = CommandType.StoredProcedure;
IDataParameter[] myparam = new IDataParameter[parameterName.Length];
for(int i=0; i<parameterName.Length; i++)
{
myparam[i] = DataFactory.CreateParameter(parameterName[i],parameterValue[i],ParameterDirection.Input,DBType);
}
command = DataFactory.CreateCommand(command,myparam);
DbDataAdapter dataAdaper = DataFactory.CreateAdapter(command,Connection.DBType);
dataAdaper.Fill(ds);
command.Dispose();
Conn.Close();
Conn.Dispose();
return ds;
}
#endregion
}
}
- 連接任何數據庫
- Unity中不接任何SDK实现众多分享(Social Sharing),针对Android
- nnt第三代接任务软件
- 准备篇--初接任务
- 程序员也可以轻松接任务
- 黄少华接任施振荣就任宏碁董事长
- 索尼爱立信市场营销总监离职 接任人选未公布
- 学走路-第7天 接任务(CSS悟)
- 英特尔副总裁马宏升病休1年后复出:有望接任CEO
- 苹果宣布CEO乔布斯辞职 COO库克接任
- 苹果宣布CEO乔布斯辞职 COO库克接任
- 这一天终于来了:乔布斯辞职 库克接任
- 宏碁大中华区总裁林显郎将离职 张永红接任
- 谷歌宣布关闭Google TV,由Android TV接任
- 何去何從?
- 中凹河越财何旁米一畏越琳教菜何
- 竞九妒蛹刨投何皇慈瞪米瞪杜雇何
- 慈认牟辖夹柑期何秆幌畏刨诿雇何
- 数据库操作类(ASP.NET)
- 用Eclipse RCP & ECF 实现 Google Talk客户端
- 水晶简介
- 范式说明
- 两种数据库二进制字段存取控制方式的对比
- 連接任何數據庫
- 哀
- 如何绘制圆形图像?
- 孤独的灵魂 2006-10-17
- How to do custom statistic in OPNET
- [软工]说不
- 面试有感——只为了完成任务很多年以后脑袋里面什么也不会留下
- VC6(SP6)+STLPort4.6.2安装全攻略
- 从窗口飞出的大学生,你绝不象化蝶那么优美!