public DataSet ExecuteQuery(string ProcedureName, Struct_Parameters[] ProcedureParameters) { SqlCommand Cmd = new SqlCommand(); SqlDataAdapter Adp = new SqlDataAdapter(); DataSet Ds = new DataSet(); try { Cmd.CommandType = System.Data.CommandType.StoredProcedure; Cmd.CommandText = ProcedureName; Cmd.CommandTimeout = CnsQueryTimeout; if (!Information.IsNothing(ProcedureParameters)) { foreach (Struct_Parameters Inner_Obj in ProcedureParameters) { Cmd.Parameters.AddWithValue(Inner_Obj.Name, Inner_Obj.Value); } } Cmd.Transaction = this.mTransaction; Cmd.Connection = this.mConnection; Adp.SelectCommand = Cmd; Adp.Fill(Ds); } catch { } finally { Cmd.Dispose(); Cmd = null; Adp.Dispose(); Adp = null; } return Ds; }
public int ExecuteNonQuery(string ProcedureName, Struct_Parameters[] ProcedureParameters) { SqlCommand Cmd = new SqlCommand(); int ReturnValue = 0; try { Cmd.CommandType = System.Data.CommandType.StoredProcedure; Cmd.CommandText = ProcedureName; Cmd.CommandTimeout = CnsQueryTimeout; if (!Information.IsNothing(ProcedureParameters)) { foreach (Struct_Parameters Inner_Obj in ProcedureParameters) { Cmd.Parameters.AddWithValue(Inner_Obj.Name, Inner_Obj.Value); } } Cmd.Transaction = this.mTransaction; Cmd.Connection = this.mConnection; ReturnValue = Cmd.ExecuteNonQuery(); } catch { } finally { Cmd.Dispose(); Cmd = null; } return ReturnValue; }