protected static object ExecCmdScalar(string ConnStr, string commandText, CommandType commandType, SqlParameterList parameters)
{
SqlConnection conn = new SqlConnection(ConnStr);
SqlCommand cmd = new SqlCommand(commandText, conn);
cmd.CommandTimeout = 80000;
try
{
cmd.CommandType = commandType;
if (parameters != null)
{
foreach (SqlParameter parm in parameters)
{
cmd.Parameters.Add(parm);
}
}
conn.Open();
return(cmd.ExecuteScalar());
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
conn.Dispose();
cmd.Dispose();
}
}
}
protected static DataSet ExecCmdDataSet(string ConnStr, string commandText, CommandType commandType, SqlParameterList parameters)
{
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
SqlConnection conn = new SqlConnection(ConnStr);
SqlCommand cmd = new SqlCommand(commandText, conn);
cmd.CommandTimeout = 0;
try
{
cmd.CommandType = commandType;
if (parameters != null)
{
foreach (SqlParameter parm in parameters)
{
cmd.Parameters.Add(parm);
}
}
conn.Open();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
return(ds);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
conn.Dispose();
cmd.Dispose();
da.Dispose();
}
}
}