private void загрузитьЗадачуToolStripMenuItem_Click(object sender, EventArgs e) { OpenFileDialog openFileDialog = new OpenFileDialog(); openFileDialog.Filter = "txt files (*.txt)|*.txt|All files (*.*)|*.*"; openFileDialog.FilterIndex = 2; openFileDialog.RestoreDirectory = true; if (openFileDialog.ShowDialog() != DialogResult.OK) { return; } StreamReader SR = new StreamReader(openFileDialog.OpenFile()); textBoxEqvNum.Text = SR.ReadLine();; textBoxVarNum.Text = SR.ReadLine(); int i = 0, j = 0; for (i = 0; i < DataGridMain.ColumnCount; i++) { for (j = 0; j < DataGridMain.RowCount - 1; j++) { DataGridMain[i, j].Value = SR.ReadLine(); } } DataGridMain.Refresh(); SR.Close(); }
private void экспортИзБазыДанныхToolStripMenuItem_Click(object sender, EventArgs e) { Database databaseSQLite = new Database(); LoadMenu loadMenu = new LoadMenu(); loadMenu.indexSave = 3; loadMenu.ShowDialog(); //OpenFileDialog openFileDialog = new OpenFileDialog(); //openFileDialog.Filter = "txt files (*.txt)|*.txt|All files (*.*)|*.*"; //openFileDialog.FilterIndex = 2; //openFileDialog.RestoreDirectory = true; //if (openFileDialog.ShowDialog() != DialogResult.OK) return; if (loadMenu.fileName != null) { string query = "select File from SaveLinearSystemTask where Name=" + "\"" + loadMenu.fileName + "\""; databaseSQLite.OpenConnection(); SQLiteCommand myCommand = new SQLiteCommand(query, databaseSQLite.myConnection); using (SQLiteDataReader reader = myCommand.ExecuteReader()) { if (reader.HasRows) // если есть данные { while (reader.Read()) // построчно считываем данные { string data = (string)reader.GetValue(0); File.WriteAllText("temp.txt", data); } } } databaseSQLite.CloseConnection(); StreamReader SR = new StreamReader("temp.txt"); textBoxEqvNum.Text = SR.ReadLine();; textBoxVarNum.Text = SR.ReadLine(); int i = 0, j = 0; for (i = 0; i < DataGridMain.ColumnCount; i++) { for (j = 0; j < DataGridMain.RowCount - 1; j++) { DataGridMain[i, j].Value = SR.ReadLine(); } } DataGridMain.Refresh(); SR.Close(); } }