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];
}
}
}
}
