private void ReadDatabase() { try { DataClasses1DataContext dc = Dataclass1Singlon.getSinglon(); var stress_input = from i in dc.StressInput where i.Id == 0 select i; textBox11.Text = stress_input.First().kc11.ToString(); textBox12.Text = stress_input.First().kc12.ToString(); textBox13.Text = stress_input.First().kc13.ToString(); textBox14.Text = stress_input.First().kc14.ToString(); textBox21.Text = stress_input.First().kc21.ToString(); textBox22.Text = stress_input.First().kc22.ToString(); textBox23.Text = stress_input.First().kc23.ToString(); textBox24.Text = stress_input.First().kc24.ToString(); textBox31.Text = stress_input.First().kc31.ToString(); textBox32.Text = stress_input.First().kc32.ToString(); textBox4.Text = stress_input.First().kc4.ToString(); textBox51.Text = stress_input.First().kc51.ToString(); textBox52.Text = stress_input.First().kc52.ToString(); } catch (Exception E) { ; } }
private void SaveDatabase() { DataClasses1DataContext dc = Dataclass1Singlon.getSinglon(); StressInput stress_input = dc.StressInput.FirstOrDefault(); try { dc.StressInput.DeleteOnSubmit(stress_input); dc.SubmitChanges(); }catch (Exception E) { ; } try { stress_input = new StressInput() { kc11 = Convert.ToDouble(textBox11.Text), kc12 = Convert.ToDouble(textBox12.Text), kc13 = Convert.ToDouble(textBox13.Text), kc14 = Convert.ToDouble(textBox14.Text), kc21 = Convert.ToDouble(textBox21.Text), kc22 = Convert.ToDouble(textBox22.Text), kc23 = Convert.ToDouble(textBox23.Text), kc24 = Convert.ToDouble(textBox24.Text), kc31 = Convert.ToDouble(textBox31.Text), kc32 = Convert.ToDouble(textBox32.Text), kc4 = Convert.ToDouble(textBox4.Text), kc51 = Convert.ToDouble(textBox51.Text), kc52 = Convert.ToDouble(textBox52.Text) }; dc.StressInput.InsertOnSubmit(stress_input); dc.SubmitChanges(); }catch (Exception E) { ; } }