//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()); }
}
