using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using PrjLibrarian.Rule;namespace PrjLibrarian.DB
{
/// <summary>
/// 连接数据库的类 数据库的连接配置
/// </summary>
class DBManage
{
private SqlConnection con;
//数据库连接配置
private string constring = "server=.;database=数据库,名;uid=sa;pwd=;";
public DBManage()
{
con = new SqlConnection(constring);
con.Open();
//打开连接
}
}
}
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using PrjLibrarian.Rule;namespace PrjLibrarian.DB
{
/// <summary>
/// 连接数据库的类 数据库的连接配置
/// </summary>
class DBManage
{
private SqlConnection con;
//数据库连接配置
private string constring = "server=.;database=数据库,名;uid=sa;pwd=;";
public DBManage()
{
con = new SqlConnection(constring);
con.Open();
//打开连接
}
}
}
SqlConnection conn = new SqlConnection("data source=.;uid=sa;pwd=;database=test");
string mysql="select count(*) from test where userName='' and pwd=''";
DataSet ds=new DataSet();
myDapter.Fill(ds);
DataTable dt = ds.Tables[0];
if(dt.Rows.Count >=1)
{
this.Hide();
mainForm mf = new mainForm();
mf.Show();
MessageBox.Show("登录成功");
}
else
{
MessageBox.Show("登录失败");
}
--------------------------------------------------------
得到的是查找出结果的数量,如果〉0说明用户名密码正确,如果不是的话就是错误
返回的是一个int
button click event
get text control value
check from dbSqlConnection
SqlCommand
etc. basic ADO.NET object