登录数据库验证用户,第一次写csharp,头都有点大
//数据库连接函数
public SqlConnection dbConnect(string server, string db, string uid, string pwd)
{
if (server == null)//传默认参数不知道格式怎么写
server = "(local) ";
if (db == null)
db = "DB_CFGL ";
if (uid == null)
uid = "sa ";
if (pwd == null)
pwd = "houyichong ";
string strconn= "server= "+server+ ";database= "+db+ ";integrated security=false;user id= "+uid+ ";password=houyichong ";
SqlConnection conn = new SqlConnection(strconn);
//conn.ConnectionString =strconn;
conn.ConnectionTimeout = 60;
conn.Open();
return conn;
}
//登录按钮的click事件中调用dbConnect
private void btn_login_Click(object sender, EventArgs e)
{
bool check;
check = checkInput(txt_uid.Text.ToString().Trim()) && checkInput(txt_pwd.Text.ToString());//checkInput检查textbox输入是否为空
if(check==ture)
{
string uid=txt_uid.Text.Trim().ToString();
string pwd=txt_pwd.Text.ToString();
SqlConnection conn = new SqlConnection() ;