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(); }