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 WindowsFormsApplication1{ public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { string connstr = "server=.\\sql2005;database=mytest; uid=sa;pwd=sa"; using (SqlConnection conn = new SqlConnection(connstr)) { SqlCommand cmd = new SqlCommand(); string sqlstr = "select * from user_login where username='" textBox1.Text "'"; cmd.Connection = conn; cmd.CommandText = sqlstr; conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { if(textBox2 .Text ==(string)dr["password"]) { MessageBox.Show("登录成功"); this.DialogResult = DialogResult.OK; //Form2 f2 = new Form2(); //this.Hide(); //f2.username =(string)dr["username"]; //f2.Show(); } else { MessageBox.Show("密码错误"); } } else { MessageBox.Show("用户名错误"); } } } }}
评论