/// <summary> /// Loads in defaults from recourses to the dataset upon startup. /// </summary> public void loadDefaultData() { traitsDict = new DataSet1.traitDataTable(); ancestories = new DataSet1.ancestryDataTable(); equipment = new DataSet1.equipmentDataTable(); experiences = new DataSet1.experienceDataTable(); types = new DataSet1.typeDataTable(); sizes = new DataSet1.sizeDataTable(); StringReader stream; stream = new StringReader(Properties.Resources.traits_saf); traitsDict.ReadXml(stream); stream = new StringReader(Properties.Resources.ancestories_saf); ancestories.ReadXml(stream); stream = new StringReader(Properties.Resources.equipment_saf); equipment.ReadXml(stream); stream = new StringReader(Properties.Resources.experiences_saf); experiences.ReadXml(stream); stream = new StringReader(Properties.Resources.types_saf); types.ReadXml(stream); stream = new StringReader(Properties.Resources.sizes_saf); sizes.ReadXml(stream); stream.Close(); }
private void FillFormCombo() { try { //TYPE MATERIEL // DataSet1TableAdapters.typeTableAdapter typeAdaptater = new DataSet1TableAdapters.typeTableAdapter(); DataSet1.typeDataTable tab1 = new DataSet1.typeDataTable(); typeAdaptater.Fill(tab1); List <ListItem> listitem = new List <ListItem>(); foreach (DataSet1.typeRow Row in tab1.Rows) { listitem.Add(new ListItem(Row.nom, Row.id_type)); } formFieldTypeMateriel.DataSource = listitem; //CLIENT // DataSet1TableAdapters.clientTableAdapter clientAdaptater = new DataSet1TableAdapters.clientTableAdapter(); DataSet1.clientDataTable tab2 = new DataSet1.clientDataTable(); clientAdaptater.Fill(tab2); List <ListItem> listitem2 = new List <ListItem>(); foreach (DataSet1.clientRow Row in tab2.Rows) { listitem2.Add(new ListItem(Row.name, Row.id_client)); } formFieldClient.DataSource = listitem2; //SITE// DataSet1TableAdapters.siteTableAdapter siteAdaptater = new DataSet1TableAdapters.siteTableAdapter(); DataSet1.siteDataTable tab3 = new DataSet1.siteDataTable(); siteAdaptater.Fill(tab3); List <ListItem> listitem3 = new List <ListItem>(); foreach (DataSet1.siteRow Row in tab3.Rows) { listitem3.Add(new ListItem(Row.nom, Row.id_site)); } formFieldSite.DataSource = listitem3; } catch (Exception ex) { MessageBox.Show(ex.Message); } // dbConnection.Close(); }
private void FillCombo() { try { DataSet1TableAdapters.typeTableAdapter typeAdaptater = new DataSet1TableAdapters.typeTableAdapter(); DataSet1.typeDataTable tab1 = new DataSet1.typeDataTable(); typeAdaptater.Fill(tab1); List <ListItem> listitem = new List <ListItem>(); listitem.Add(new ListItem("Indifferent", 0)); foreach (DataSet1.typeRow Row in tab1.Rows) { listitem.Add(new ListItem(Row.nom, Row.id_type)); } comboBox1.DataSource = listitem; } catch (Exception ex) { MessageBox.Show(ex.Message); } // dbConnection.Close(); }
/// <summary> /// Loads binary from path, extracts dictionary with xml strings, loads xml strings into fresh databases. /// </summary> /// <param path="import file location"></param> /// TODO: /// Find a way to reuse stream here it must be possible public void importTables(String path) { traitsDict = new DataSet1.traitDataTable(); ancestories = new DataSet1.ancestryDataTable(); equipment = new DataSet1.equipmentDataTable(); experiences = new DataSet1.experienceDataTable(); types = new DataSet1.typeDataTable(); sizes = new DataSet1.sizeDataTable(); units = new DataSet1.unitDataTable(); Dictionary <string, string> xmlStringDict; FileStream s = new FileStream(path, FileMode.Open); BinaryFormatter b = new BinaryFormatter(); xmlStringDict = (Dictionary <string, string>)b.Deserialize(s); StringReader stream; stream = new StringReader(xmlStringDict["ancestories"]); ancestories.ReadXml(stream); stream = new StringReader(xmlStringDict["traitsDict"]); traitsDict.ReadXml(stream); stream = new StringReader(xmlStringDict["equipment"]); equipment.ReadXml(stream); stream = new StringReader(xmlStringDict["experiences"]); experiences.ReadXml(stream); stream = new StringReader(xmlStringDict["types"]); types.ReadXml(stream); stream = new StringReader(xmlStringDict["sizes"]); sizes.ReadXml(stream); stream.Close(); s.Close(); }
private void FillFormCombo() { try { //TYPE MATERIEL // DataSet1TableAdapters.typeTableAdapter typeAdaptater = new DataSet1TableAdapters.typeTableAdapter(); DataSet1.typeDataTable tab1 = new DataSet1.typeDataTable(); typeAdaptater.Fill(tab1); List<ListItem> listitem = new List<ListItem>(); foreach (DataSet1.typeRow Row in tab1.Rows) { listitem.Add(new ListItem(Row.nom, Row.id_type)); } formFieldTypeMateriel.DataSource = listitem; //CLIENT // DataSet1TableAdapters.clientTableAdapter clientAdaptater = new DataSet1TableAdapters.clientTableAdapter(); DataSet1.clientDataTable tab2 = new DataSet1.clientDataTable(); clientAdaptater.Fill(tab2); List<ListItem> listitem2 = new List<ListItem>(); foreach (DataSet1.clientRow Row in tab2.Rows) { listitem2.Add(new ListItem(Row.name, Row.id_client)); } formFieldClient.DataSource = listitem2; //SITE// DataSet1TableAdapters.siteTableAdapter siteAdaptater = new DataSet1TableAdapters.siteTableAdapter(); DataSet1.siteDataTable tab3 = new DataSet1.siteDataTable(); siteAdaptater.Fill(tab3); List<ListItem> listitem3 = new List<ListItem>(); foreach (DataSet1.siteRow Row in tab3.Rows) { listitem3.Add(new ListItem(Row.nom, Row.id_site)); } formFieldSite.DataSource = listitem3; } catch (Exception ex) { MessageBox.Show(ex.Message); } // dbConnection.Close(); }
private void FillCombo() { try { DataSet1TableAdapters.typeTableAdapter typeAdaptater = new DataSet1TableAdapters.typeTableAdapter(); DataSet1.typeDataTable tab1 = new DataSet1.typeDataTable(); typeAdaptater.Fill(tab1); List<ListItem> listitem = new List<ListItem>(); listitem.Add(new ListItem("Indifferent", 0)); foreach (DataSet1.typeRow Row in tab1.Rows) { listitem.Add(new ListItem(Row.nom, Row.id_type)); } comboBox1.DataSource = listitem; } catch (Exception ex) { MessageBox.Show(ex.Message); } // dbConnection.Close(); }