private void fillGrid(String query, int i)
{
dc.openCon();
SqlDataAdapter da = dc.selectTable(query);
DataTable dt = new DataTable();
da.Fill(dt);
if (i == 1)
{
metroGrid1.DataSource = dt;
DataGridViewButtonColumn col = new DataGridViewButtonColumn();
col.UseColumnTextForButtonValue = true;
col.Text = "Delete";
col.Name = "deleteUsr";
metroGrid1.Columns.Add(col);
dc.closeCon();
}
else
{
metroGrid2.DataSource = dt;
DataGridViewButtonColumn col = new DataGridViewButtonColumn();
col.UseColumnTextForButtonValue = true;
col.Text = "Delete";
col.Name = "deleteUsr";
metroGrid2.Columns.Add(col);
dc.closeCon();
}
}
private void metroButton5_Click(object sender, EventArgs e)
{
String command = "RESTORE DATABASE bisdb FROM DISK ='" + metroTextBox1.Text + "' WITH REPLACE";
DataCon dc4 = new DataCon();
dc4.openCon();
SqlCommand cmd = new SqlCommand(command, dc4.getCon());
dc4.closeCon();
dc4.dispCon();
MessageBox.Show("SuccessFully Restored");
}