这是昨天我自己写的,没有一个函数,全部是一条思路理下来。
有点乱,有时间的童鞋可以给点意见,功能都是可以实现的!
(以下是基于winform开发的)
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
{
int i;
DateTime datetime;
public Form1()
{
InitializeComponent();
}
private void btn_Login_Click(object sender, EventArgs e)
{
if (this.txt_UserName.Text == "")
{
MessageBox.Show("请输入正确的账号!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
if (this.txt_UserWord.Text == "")
{
MessageBox.Show("请输入密码!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
SqlConnection sqlCnn = new SqlConnection();
sqlCnn.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=E:\优快云大二下\作业\2012.02.20\LoginTest\WindowsFormsApplication1\Database1.mdf;Integrated Security=True;User Instance=True";
SqlCommand sqlCmm = new SqlCommand("select * from T_Users where UserName='" + this.txt_UserName.Text + "' and Userword='"+ this.txt_UserWord.Text + "'" , sqlCnn);//"and Userword=" + this.txt_UserWord.Text, sqlCnn);
sqlCnn.Open();
#region
//SqlDataReader reader = sqlCmm.ExecuteReader();
//if (reader.Read())
//{
// if (this.txt_UserWord.Text == reader["Userword"].ToString())
// {
// MessageBox.Show("登陆成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// }
// else
// {
// MessageBox.Show("账号/密码错误!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// }
//}
//else
//{
// MessageBox.Show("账号/密码错误!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
//}
//sqlCnn.Close();
#endregion
#region
SqlDataAdapter adapter = new SqlDataAdapter(sqlCmm);
DataTable table = new DataTable();
adapter.Fill(table);
if (table.Rows.Count <= 0)