SqlCommand cmd;
static string connString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["conn"].ConnectionString;
DbCommand dbcommand;
SqlDatabase db = new SqlDatabase(connString);
public static SqlConnection scon = new SqlConnection(connString);
#region Connection function
public void CreateConnection()
{
if (scon.State != ConnectionState.Open)
{
scon.Open();
}
}
public void CloseConnection()
{
scon.Close();
}
#endregion
#region Common Function
public DataSet GetDataSet(string SQL)
{
DataSet dsInv = new DataSet();
dbcommand = db.GetSqlStringCommand(SQL);
dsInv = db.ExecuteDataSet(dbcommand);
return dsInv;
}
public DataTable GetDataTable(string SQL)
{
DataTable dtInv = new DataTable();
dbcommand = db.GetSqlStringCommand(SQL);
ds = db.ExecuteDataSet(dbcommand);
if (ds.Tables.Count > 0)
{
dtInv = ds.Tables[0];
}
return dtInv;
}
public int ExecuteQuery(string qur)
{
int Retval = 0;
dbcommand = db.GetSqlStringCommand(qur);
Retval = db.ExecuteNonQuery(dbcommand);
return Retval;
}
public int ExecuteScalar(string qur)
{
int Retval = 0;
dbcommand = db.GetSqlStringCommand(qur);
Retval = Convert.ToInt32(db.ExecuteScalar(dbcommand));
return Retval;
}
public int ExecuteIntScalar(string qur)
{
int Retval = 0;
dbcommand = db.GetSqlStringCommand(qur);
Retval = Convert.ToInt32(db.ExecuteScalar(dbcommand));
return Retval;
}
public string ExecuteStringScalar(string qur)
{
string Retval = string.Empty;
dbcommand = db.GetSqlStringCommand(qur);
Retval = Convert.ToString(db.ExecuteScalar(dbcommand));
return Retval;
}
<add name="conn" connectionString="Data Source=; Initial Catalog=;User ID=;Password=;MultipleActiveResultSets=True;Connect TimeOut=100000;Pooling=true;Max Pool Size=250;Min Pool Size=100;"/>
static string connString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["conn"].ConnectionString;
DbCommand dbcommand;
SqlDatabase db = new SqlDatabase(connString);
public static SqlConnection scon = new SqlConnection(connString);
#region Connection function
public void CreateConnection()
{
if (scon.State != ConnectionState.Open)
{
scon.Open();
}
}
public void CloseConnection()
{
scon.Close();
}
#endregion
#region Common Function
public DataSet GetDataSet(string SQL)
{
DataSet dsInv = new DataSet();
dbcommand = db.GetSqlStringCommand(SQL);
dsInv = db.ExecuteDataSet(dbcommand);
return dsInv;
}
public DataTable GetDataTable(string SQL)
{
DataTable dtInv = new DataTable();
dbcommand = db.GetSqlStringCommand(SQL);
ds = db.ExecuteDataSet(dbcommand);
if (ds.Tables.Count > 0)
{
dtInv = ds.Tables[0];
}
return dtInv;
}
public int ExecuteQuery(string qur)
{
int Retval = 0;
dbcommand = db.GetSqlStringCommand(qur);
Retval = db.ExecuteNonQuery(dbcommand);
return Retval;
}
public int ExecuteScalar(string qur)
{
int Retval = 0;
dbcommand = db.GetSqlStringCommand(qur);
Retval = Convert.ToInt32(db.ExecuteScalar(dbcommand));
return Retval;
}
public int ExecuteIntScalar(string qur)
{
int Retval = 0;
dbcommand = db.GetSqlStringCommand(qur);
Retval = Convert.ToInt32(db.ExecuteScalar(dbcommand));
return Retval;
}
public string ExecuteStringScalar(string qur)
{
string Retval = string.Empty;
dbcommand = db.GetSqlStringCommand(qur);
Retval = Convert.ToString(db.ExecuteScalar(dbcommand));
return Retval;
}
<add name="conn" connectionString="Data Source=; Initial Catalog=;User ID=;Password=;MultipleActiveResultSets=True;Connect TimeOut=100000;Pooling=true;Max Pool Size=250;Min Pool Size=100;"/>
0 comments:
Post a Comment