void createXMLFile() { using (this.con) using (StreamWriter sw = System.IO.File.CreateText(string.Format("./Loads{0:ddMMyy}.xml", DateTime.Now))) { if (con.State == ConnectionState.Closed) { con.Open(); } string sqlAccounts = @"select distinct ACCNO, ACCNAME from View_Kite_LoadReport_ACCNO"; SqlDataAdapter adp = new SqlDataAdapter(sqlAccounts, con); DataSet dst = new DataSet(); adp.Fill(dst, "ACCOUNTS"); LoadsXMLCreator loads = new LoadsXMLCreator(dst.Tables["ACCOUNTS"]); string xml = loads.HeaderFields("ACCNO", "ACCNAME").DetailFields("CORTEXDATE", "CRDPRODUCT", "PROGRAMID", "ACCTYPE", "DESCRIPTION", "AMTBILL").Create(); sw.Write(xml); sw.Close(); } }
void createXMLFile() { using(this.con) using (StreamWriter sw = System.IO.File.CreateText(string.Format("./Loads{0:ddMMyy}.xml", DateTime.Now))) { if (con.State==ConnectionState.Closed) con.Open(); string sqlAccounts = @"select distinct ACCNO, ACCNAME from View_Kite_LoadReport_ACCNO"; SqlDataAdapter adp = new SqlDataAdapter(sqlAccounts, con); DataSet dst = new DataSet(); adp.Fill(dst, "ACCOUNTS"); LoadsXMLCreator loads = new LoadsXMLCreator(dst.Tables["ACCOUNTS"]); string xml = loads.HeaderFields("ACCNO", "ACCNAME").DetailFields("CORTEXDATE", "CRDPRODUCT", "PROGRAMID", "ACCTYPE", "DESCRIPTION", "AMTBILL").Create(); sw.Write(xml); sw.Close(); } }