SqlConnection sqlconn = new SqlConnection("Data Source=(local);Database=ss;Uid=sa;Pwd=123");
sqlconn.Open();
SqlCommand sqlcom = sqlconn.CreateCommand();
sqlcom.CommandText = "select count(*) from Region where name='" + TextBox1.Text
+ "' and password='" + TextBox2.Text + "'";
int count = Convert.ToInt32(sqlcom.ExecuteScalar());//获取SQL语句的值 强制转换成数值类型
sqlconn.Open();
SqlCommand sqlcom = sqlconn.CreateCommand();
sqlcom.CommandText = "select count(*) from Region where name='" + TextBox1.Text
+ "' and password='" + TextBox2.Text + "'";
int count = Convert.ToInt32(sqlcom.ExecuteScalar());//获取SQL语句的值 强制转换成数值类型