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 { } }