private void btn_run_Click(object sender, EventArgs e) { lbl_Message.ForeColor = Color.Red; lbl_Message.Text = ""; ds = AccessDBLoader.LoadFromFile(openFilePath); ds = SQLDBLoader.RunQuery(textBox3.Text, ds); if (ds == null) { lbl_Message.Text = "Query doesn't run correctly!"; } else { lbl_Message.ForeColor = Color.Blue; lbl_Message.Text = "Loading..."; saveFileDialog1.ShowDialog(); CopyFile(openFilePath, saveFilePath); if (!AccessDBLoader.UploadToFile(saveFilePath, ds)) { lbl_Message.ForeColor = Color.Red; lbl_Message.Text = "Records of Access template not matched by query! \n OR \n Access template isn't empty!"; } else { if (lbl_Message.Text == "Loading...") { lbl_Message.ForeColor = Color.Green; lbl_Message.Text = "Program run successfully"; } } } }
private void btn_browse_Click(object sender, EventArgs e) { openFilePath = OpenFile(); textBox1.Text = openFilePath; lbl_Message.ForeColor = Color.Red; if (!File.Exists(openFilePath)) { lbl_Message.Text = "File path is incorrect!"; } else { ds = AccessDBLoader.LoadFromFile(openFilePath); if (ds == null) { lbl_Message.Text = "Can't open your Database!"; } else { if (ds.Tables.Count == 0) { lbl_Message.Text = "Your Database is empty,\n please select an other file."; } else { dataGridView1.DataSource = ds.Tables[0]; } } } }