![]() |
#2
asdp262662013-10-17 16:29
|

private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text != "" && textBox2.Text != "")
{
string connsql = "Data Source=.;Initial Catalog=work;Integrated Security=True";
SqlConnection conn = new SqlConnection(connsql);
conn.Open();
string mysql = "select * from t1 where id='" + textBox1.Text + "' and pass='" + textBox2.Text + "'";
SqlCommand cmd = new SqlCommand(mysql, conn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
;
string cmdtext="insert into t2 (id,name,xx) select id,name,xx from t1";
Form2 f2 = new Form2();
f2.Show();
}
conn.Close();
}
else
{
return;
}
{
if (textBox1.Text != "" && textBox2.Text != "")
{
string connsql = "Data Source=.;Initial Catalog=work;Integrated Security=True";
SqlConnection conn = new SqlConnection(connsql);
conn.Open();
string mysql = "select * from t1 where id='" + textBox1.Text + "' and pass='" + textBox2.Text + "'";
SqlCommand cmd = new SqlCommand(mysql, conn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
;
string cmdtext="insert into t2 (id,name,xx) select id,name,xx from t1";
Form2 f2 = new Form2();
f2.Show();
}
conn.Close();
}
else
{
return;
}