class YC
{
private string Message;
public YC()
{
this.Message = "输入有误,请重新输入";
}
public override string ToString()
{
return Message;
}
}
public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
try
{
string a = textBox1.Text;
int result;
bool bl = int.TryParse(textBox2.Text, out result);
if (!bl)
{
throw new YC();
}
else
{
int b = int.Parse(textBox2.Text);
bool bl1 = ceshi(a, b);
if (bl1)
{
MessageBox.Show("CHENGONG");
}
else
{
MessageBox.Show("SH");
}
}
}
catch (YC yc)
{
MessageBox.Show(yc.Message);
}
//string a = textBox1.Text;
//int b= int.Parse(textBox2.Text);
//bool bl = ceshi(a, b);
//if (bl)
//{
// MessageBox.Show("CHENGGONG");
//}
//else
//{
// MessageBox.Show("SHIBAI");
//}
finally
{
}
}
public bool ceshi(string a, int b)
{
string connectionstring = "server=localhost;database=ceshi;integrated security=SSPI";
SqlConnection con = new SqlConnection(connectionstring);
con.Open();
//string commandtext = "select * from Table_1 where name='" + a + "'and passward=" + b;
//string @name;
//string @passward;
string commandtext = "select * from Table_1 where name=@nameand passward = @passward";
SqlCommand cmd = new SqlCommand(commandtext, con);
//cmd.Parameters.Add("@name", SqlDbType.VarChar);
//cmd.Parameters["@name"].Value = "a";
cmd.Parameters.AddWithValue("@name", a);
cmd.Parameters.Add("@passward", SqlDbType.Int);
cmd.Parameters["@passward"].Value = b;
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
return true;
}
else
{
return false;
}
con.Close();
}
}设置了断点,按F5后无法正常逐行运行,直接显示最终结果。