private void writeResponseSpectrum(XmlTextWriter xml, ResponseSpectrum spectrum) { float[,] func = spectrum.Function; for (int i = 0; i < func.GetLength(0); i++) { if (i == 0) { xml.WriteStartElement("RS"); xml.WriteAttributeString("Name", spectrum.ToString()); xml.WriteAttributeString("Period", func[i, 0].ToString()); xml.WriteAttributeString("Accel", func[i, 1].ToString()); xml.WriteAttributeString("FuncDamp", "0.05"); xml.WriteEndElement(); } else { xml.WriteStartElement("RS"); xml.WriteAttributeString("Name", spectrum.ToString()); xml.WriteAttributeString("Period", func[i, 0].ToString()); xml.WriteAttributeString("Accel", func[i, 1].ToString()); xml.WriteAttributeString("FuncDamp", "0"); xml.WriteEndElement(); } } }
private void store(OleDbConnection cn, ResponseSpectrum spectrum) { float[,] func = spectrum.Function; string sql; for (int i = 0; i < func.GetLength(0); i++) { if (i == 0) sql = "INSERT INTO [Function - Response Spectrum - User] " + "([Name], Period, Accel, FuncDamp) VALUES " + "(\"" + spectrum.ToString() + "\"," + func[i, 0] + ", " + func[i, 1] + ", 0.05);"; else sql = "INSERT INTO [Function - Response Spectrum - User] " + "([Name], Period, Accel) VALUES " + "(\"" + spectrum.ToString() + "\"," + func[i, 0] + ", " + func[i, 1] + ");"; new OleDbCommand(sql, cn).ExecuteNonQuery(); } }