private void Form1_Load(object sender, EventArgs e)
{
DataTable data = db.FetchAllSql("SELECT `1`,`2`,`3`,`4`,`5`,`6`,`10` FROM conf");
this.textBox1.Text = data.Rows[0][0].ToString();
this.textBox2.Text = data.Rows[0][1].ToString();
this.textBox6.Text = data.Rows[0][3].ToString();
this.textBox7.Text = data.Rows[0][4].ToString();
this.textBox8.Text = data.Rows[0][5].ToString();
this.textBox10.Text = data.Rows[0][6].ToString();
string[] time = data.Rows[0][2].ToString().Split(':');
this.textBox3.Text = time[0];
this.textBox4.Text = time[1];
data = db.FetchAllSql("SELECT `id`,`title`,`x`,`y`,`w`,`h` FROM `data`");
foreach (DataRow rr in data.Rows)
{
dataGridView1.Rows.Add(rr[0].ToString(), rr[1].ToString(), rr[2].ToString(), rr[3].ToString(), rr[4].ToString(), rr[5].ToString());
}
data = db.FetchAllSql("SELECT `id` FROM pass");
this.textBox5.Text = data.Rows[0][0].ToString();
pass p = new pass(textBox5.Text);
if (p.ShowDialog() != System.Windows.Forms.DialogResult.Yes)
this.Close();
}
private void Form1_Load(object sender, EventArgs e)
{
DataTable data = db.FetchAllSql("SELECT `1`,`2`,`3`,`4`,`5`,`6`,`10`,`w1`,`w2`,`w3`,`w4`,`w5`,`w6`,`type`,`style`,`res` FROM conf");
this.textBox1.Text = data.Rows[0][0].ToString();
this.textBox2.Text = data.Rows[0][1].ToString();
this.textBox6.Text = data.Rows[0][3].ToString();
this.textBox7.Text = data.Rows[0][4].ToString();
this.textBox8.Text = data.Rows[0][5].ToString();
this.textBox10.Text = data.Rows[0][6].ToString();
string[] time = data.Rows[0][2].ToString().Split(':');
this.textBox3.Text = time[0];
this.textBox4.Text = time[1];
this.textBoxW1.Text = data.Rows[0][7].ToString();
this.textBoxW2.Text = data.Rows[0][8].ToString();
this.textBoxW3.Text = data.Rows[0][9].ToString();
this.textBoxW4.Text = data.Rows[0][10].ToString();
this.textBoxW5.Text = data.Rows[0][11].ToString();
this.textBoxW6.Text = data.Rows[0][12].ToString();
this.textBox900.Text = data.Rows[0][15].ToString();
if (data.Rows[0][13].ToString().Equals("1")) this.radioButton2.Checked = true;
else this.radioButton1.Checked = true;
if (data.Rows[0][14].ToString().Equals("1")) this.checkBox1.Checked = true;
data = db.FetchAllSql("SELECT `id`,`title`,`x`,`y`,`w`,`h` FROM `data`");
foreach (DataRow rr in data.Rows)
{
dataGridView1.Rows.Add(rr[0].ToString(), rr[1].ToString(), rr[2].ToString(), rr[3].ToString(), rr[4].ToString(), rr[5].ToString());
}
data = db.FetchAllSql("SELECT `id` FROM pass");
this.textBox5.Text = data.Rows[0][0].ToString();
if (textBox5.Text.Trim().Length > 0)
{
pass p = new pass(textBox5.Text);
if (p.ShowDialog() != System.Windows.Forms.DialogResult.Yes)
this.Close();
}
}
