我用菜单栏的工具菜单连接到创建的SQL Server数据库,但是调用时出错是用户**没有登录数据库。请帮助一下。我写的代码是:
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient;
namespace _520 { public partial class Form1 : Form { string conStr = "Data Source=SQLServer2005;Initial Catalog=master;Integrated Security=True";//连接字符串 public Form1() { InitializeComponent(); }
private void button1_Click(object sender, EventArgs e) {
SqlConnection conn = new SqlConnection(conStr);
string sql = "select userID,password from user_tab where userID='" + this.textBox1.Text + "' and password='" + this.textBox2.Text + "' "; SqlCommand comm = new SqlCommand(sql,conn); conn.Open(); SqlDataReader myreader = comm.ExecuteReader();
if (myreader.Read()) { MessageBox.Show("成功", "提示"); } }
private void Form1_Load(object sender, EventArgs e) {
} } }