Question

C#中SQL查询出错 抛异常 求大神解决

这是点击事件代码
private void btnLogin_Click(object sender, RoutedEventArgs e) { DataTable table = SqlHelper.ExecuteDataTable("select * from T_User where UserName=@UserName",new SqlParameter("@UserName", txtUserName.Text) ); if(table.Rows.Count<=0) { MessageBox.Show("用户名不存在"); return; } if(table.Rows.Count>1) { MessageBox.Show("用户名重复了"); return; } DataRow row = table.Rows[0]; string dbPassword = (string)row["UserPassword"]; if(dbPassword!=pwdPassword.Password) { MessageBox.Show("密码错误"); return; } else { MessageBox.Show("登陆成功"); } }
这是SqlHelper代码





Answer 1

1720406057   远程调试

Answer 2

数据类型冲突了，看看数据库类型是怎么写的，然后看看你传的参数