public DataSet ExecuteQuerySentence(string strSQL, string dbName, SqlParameter[] paramArr)
{
string xcGameConnString = XCGameDBService.GetConnString(sqlConnString, dbName);
SqlConnection conn = new SqlConnection(xcGameConnString);
try
{
conn.Open();
}
catch
{
throw;
}
SqlTransaction trans = conn.BeginTransaction();
DataSet ds = new DataSet();
try
{
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand(strSQL, conn, trans);
da.SelectCommand.CommandTimeout = 120;
if (paramArr != null && paramArr.Length > 0)
{
foreach (SqlParameter param in paramArr)
{
da.SelectCommand.Parameters.Add(param);
}
}
da.Fill(ds);
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
finally
{
conn.Close();
}
return(ds);
}
public void ExecuteStoredProcedureSentence(string strSQL, string dbName, SqlParameter[] paramArr)
{
string xcGameConnString = XCGameDBService.GetConnString(sqlConnString, dbName);
SqlConnection conn = new SqlConnection(xcGameConnString);
try
{
conn.Open();
}
catch
{
throw;
}
SqlTransaction trans = conn.BeginTransaction();
DataSet ds = new DataSet();
try
{
SqlCommand cmd = new SqlCommand(strSQL, conn, trans);
cmd.CommandType = CommandType.StoredProcedure;
if (paramArr != null && paramArr.Length > 0)
{
foreach (SqlParameter param in paramArr)
{
cmd.Parameters.Add(param);
}
}
cmd.ExecuteNonQuery();
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
finally
{
}
}
