private void setColumnList(CheckedListBox list, string filename) { DataSet dataSet = new DataSet(); FilePath = Path.GetDirectoryName(filename); string file = Path.GetFileName(filename); string Sql = "SELECT TOP 1 t1.* FROM " + file + " t1"; DBFreader.Get(Sql, ref dataSet, FilePath, "MONOKD"); foreach (DataColumn column in dataSet.Tables[0].Columns) { list.Items.Add(column.ColumnName); } }
private void button3_Click(object sender, EventArgs e) { if (!f1IsLoaded || !f2IsLoaded) { MessageBox.Show("Ви не завантажили обидва файла!"); return; } DataSet dataSet = new DataSet(); try { string Sql = "SELECT "; foreach (object Item in checkedListBox1.CheckedItems) { Sql += "t1." + Item.ToString() + ", "; } foreach (object Item in checkedListBox2.CheckedItems) { Sql += "t2." + Item.ToString() + ", "; } Sql = Sql.Remove(Sql.Length - 2); Sql += " FROM " + f1 + " t1 INNER JOIN " + f2 + " t2 ON t1.KDMO=t2.KDMO"; DBFreader.Get(Sql, ref dataSet, FilePath, "result"); dataGridView1.DataSource = dataSet.Tables[0]; saveFileDialog1.Filter = "Excel Files (*.xls)|*.xls"; saveFileDialog1.DefaultExt = "xls"; if (saveFileDialog1.ShowDialog() == DialogResult.OK) { MyExtensions.ExportToExcel(dataSet.Tables[0], saveFileDialog1.FileName); } } catch (Exception ex) { DialogResult dialogResult = MessageBox.Show(ex.Message, "Помилка", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }