Question

system.data.sqlclient.sqlexception类型的未经处理的异常出现在system.data.dll

贴上源代码
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace 宾馆客房管理系统
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{
if (IsUserIdentify() == true)
{
Form2 form1 = new Form2();
form1.Show();
this.Visible = false;
}
else
{

MessageBox.Show("用户名或密码错误");
}

}

private bool IsUserIdentify()
{

SqlConnection Conn = new SqlConnection("Data Source=.;Initial Catalog=客房管理系统;Integrated Security=True");

Conn.Open();

string sql = "SELECT Name,PassWord FROM Admin WHERE Name='" + this.textBox1.Text + "'and PassWord='" + this.textBox2.Text + "'";
SqlCommand Cmd = new SqlCommand(sql, Conn);
SqlDataReader reader = Cmd.ExecuteReader();

if (reader.Read())
{
return true;
}
else
{
return false;
}
Conn.Close();
}

private void label1_Click(object sender, EventArgs e)
{

}

private void Form1_Load(object sender, EventArgs e)
{

}

}
}

Answer 1

SqlConnection Conn = new SqlConnection("Data Source=.;Initial Catalog=客房管理系统;Integrated Security=True");
检查下连接字符串

还有IsUserIdentify()这个方法里的
Conn.Close(); 这句，永远不会被执行，因为你上面都返回return了

Answer 2

SqlConnection Conn = new SqlConnection("Data Source=.;Initial Catalog=客房管理系统;Integrated Security=True");

添加.\\SqlExpress
SqlConnection Conn = new SqlConnection("Data Source=.\\SqlExpress;Initial Catalog=客房管理系统;Integrated Security=True");