public static DataRowCollection getLoadsDetails(string ACCNO) { Config c = new Config(); SqlConnection con; if(c.Database.IS_BUILTIN) con = new SqlConnection(String.Format("database={0};server={1};integrated security={2}",c.Database.DB,c.Database.HOST,c.Database.IntegratedSecurity)); else con = new SqlConnection(String.Format("database={0};server={1};UID={2};pwd={3};", c.Database.DB, c.Database.HOST, c.Database.UID,c.Database.PWD)); using (con) { con.Open(); string sql = string.Format(@"select CORTEXDATE,CRDPRODUCT,PROGRAMID,ACCTYPE,DESCRIPTION,AMTBILL from View_Kite_LoadReport_ACCNO where ACCNO='{0}' order by CORTEXDATE,CRDPRODUCT,PROGRAMID,ACCTYPE", ACCNO); //Console.WriteLine(sql); //Console.ReadLine(); SqlDataAdapter adp = new SqlDataAdapter(sql, con); DataSet dst = new DataSet(); adp.Fill(dst, "LOADS"); return dst.Tables["LOADS"].Rows; } }
public Program() { try{ this.c = new Config(); }catch(FileNotFoundException f){ Console.WriteLine(f.Message); Console.ReadLine(); } if(c.Database.IS_BUILTIN) this.con = new SqlConnection(String.Format("database={0};server={1};integrated security={2}",this.c.Database.DB,this.c.Database.HOST,this.c.Database.IntegratedSecurity)); else this.con = new SqlConnection(String.Format("database={0};server={1};UID={2};pwd={3};", this.c.Database.DB, this.c.Database.HOST, this.c.Database.UID,this.c.Database.PWD)); this.con.Open(); }