//List<XmlEffect> xmlEffects; //List<XmlRequirement> xmlRequirements; //ExcludedItems ex; // Decided against this - user would have to reload XML after every item added at runtime public SQLtoXML() { // // The InitializeComponent() call is required for Windows Forms designer support. // InitializeComponent(); DataSet ds = new DataSet(); ds.EnforceConstraints = false; items = new DataTable(); ds.Tables.Add(items); effects = new DataTable(); ds.Tables.Add(effects); reqs = new DataTable(); ds.Tables.Add(reqs); try { db = new AODB(); //numItems = Convert.ToInt32(db.ExecuteScalar("SELECT COUNT(aoid) FROM tblAO WHERE (tblAO.type='Armor' or tblAO.type='Weapon' or tblAO.type='Implant' or tblAO.type='Spirit');")); loader = new BackgroundWorker(); loader.DoWork += new DoWorkEventHandler(querySQL); loader.RunWorkerCompleted += new RunWorkerCompletedEventHandler(finishedQuerySQL); loader.ProgressChanged += new ProgressChangedEventHandler(progress); loader.WorkerReportsProgress = true; loader.RunWorkerAsync(); } catch (Exception fail) { MessageBox.Show(fail.ToString()); } }
public void refreshList() { List<string> namesList = new List<string>(); itemsList.DataSource = null; AODB aodb = new AODB(); foreach(int v in ex.ids) { string name = aodb.ExecuteScalar(String.Format("SELECT name FROM tblAO WHERE aoid={0};",v)); if(!String.IsNullOrEmpty(name)) { namesList.Add(String.Format("{0} - {1}",v,name)); } else { namesList.Add(v.ToString()); } } itemsList.DataSource = namesList.ToArray(); }
public void refreshList() { List <string> namesList = new List <string>(); itemsList.DataSource = null; AODB aodb = new AODB(); foreach (int v in ex.ids) { string name = aodb.ExecuteScalar(String.Format("SELECT name FROM tblAO WHERE aoid={0};", v)); if (!String.IsNullOrEmpty(name)) { namesList.Add(String.Format("{0} - {1}", v, name)); } else { namesList.Add(v.ToString()); } } itemsList.DataSource = namesList.ToArray(); }
//List<XmlEffect> xmlEffects; //List<XmlRequirement> xmlRequirements; //ExcludedItems ex; // Decided against this - user would have to reload XML after every item added at runtime public SQLtoXML() { // // The InitializeComponent() call is required for Windows Forms designer support. // InitializeComponent(); DataSet ds = new DataSet(); ds.EnforceConstraints = false; items = new DataTable(); ds.Tables.Add(items); effects = new DataTable(); ds.Tables.Add(effects); reqs = new DataTable(); ds.Tables.Add(reqs); try { db = new AODB(); //numItems = Convert.ToInt32(db.ExecuteScalar("SELECT COUNT(aoid) FROM tblAO WHERE (tblAO.type='Armor' or tblAO.type='Weapon' or tblAO.type='Implant' or tblAO.type='Spirit');")); loader = new BackgroundWorker(); loader.DoWork += new DoWorkEventHandler(querySQL); loader.RunWorkerCompleted += new RunWorkerCompletedEventHandler(finishedQuerySQL); loader.ProgressChanged += new ProgressChangedEventHandler(progress); loader.WorkerReportsProgress = true; loader.RunWorkerAsync(); } catch(Exception fail) { MessageBox.Show(fail.ToString()); } }