private void Form2_Load(object sender, EventArgs e)
{
kontrol = x.XmlOku(4);
if (kontrol == "true")
{
x.connectionstring = x.XmlOku(2);
cn = new SqlConnection(x.connectionstring);
this.th1 = new Thread(new ThreadStart(this.calistir));
this.th2 = new Thread(new ThreadStart(this.calistir));
th1.Start();
timer1.Start();
}
}
private void FormBoyut_Load(object sender, EventArgs e)
{
cn = new SqlConnection(x.XmlOku(3));
cn.Open();
getsize();
cn.Close();
logicalNameRead();
}
private void timer1_Tick(object sender, EventArgs e)
{
//Thread.Sleep(200);
cn = new SqlConnection(x.XmlOku(2));
SqlCommand cmd2 = new SqlCommand("select * from SqlTask_Clients", cn);
SqlDataAdapter dr2 = new SqlDataAdapter(cmd2);
DataSet ds2 = new DataSet();
dr2.Fill(ds2, "SqlTask_Clients");
dataGridView1.DataSource = ds2.Tables["SqlTask_Clients"];
}
private void FormSorgu_Load(object sender, EventArgs e)
{
try
{
x.connectionstring = x.XmlOku(1);
cn = new SqlConnection(x.connectionstring);
timer1.Interval = 1000;
timer1.Start();
}
catch
{
MessageBox.Show("Veri Tabanı ismi boş olamaz", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void FormYedekleme_Load(object sender, EventArgs e)
{
cn = new SqlConnection(x.XmlOku(3));
string query = "SELECT name FROM master.sys.databases where name<>'Program' and name<>'DB_Task_Manager' and name<>'master' and name<>'model'and name<>'msdb' and name<>'tempdb'";
cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandText = query;
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
cmbBoxVeriTabanı.Items.Add(dr["name"]);
}
cn.Close();
}
private void FormIndex_Load(object sender, EventArgs e)
{
cn = new SqlConnection(x.XmlOku(3));
FindDb();
}