public Common.Item[] GetAllDisplay_Suppliers_Array() { Params.spS_tblSupplier_Display param = new Params.spS_tblSupplier_Display(true); param.SetUpConnection(string.Empty); using (SPs.spS_tblSupplier_Display sp = new SPs.spS_tblSupplier_Display(true)) { System.Collections.ArrayList records = new System.Collections.ArrayList(); System.Data.SqlClient.SqlDataReader sqlDataReader = null; sp.Execute(ref param, out sqlDataReader); while (sqlDataReader.Read()) { records.Add(new Common.Item(sqlDataReader.GetGuid(SPs.spS_tblSupplier_Display.Resultset1.Fields.Column_ID1.ColumnIndex), sqlDataReader.GetString(SPs.spS_tblSupplier_Display.Resultset1.Fields.Column_Display.ColumnIndex))); } sqlDataReader.Close(); if (sp.Connection.State == System.Data.ConnectionState.Open) { sp.Connection.Close(); } sp.Dispose(); param.Dispose(); return((Common.Item[])records.ToArray(typeof(Common.Item))); } }
public System.Data.DataSet GetAllDisplay_Suppliers_DataSet() { Params.spS_tblSupplier_Display param = new Params.spS_tblSupplier_Display(true); param.SetUpConnection(string.Empty); using (SPs.spS_tblSupplier_Display sp = new SPs.spS_tblSupplier_Display(true)) { System.Data.DataSet dataSet = null; sp.Execute(ref param, ref dataSet); param.Dispose(); return(dataSet); } }