using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data.SqlClient; using System.Windows.Forms; using System.Data; namespace MyPorject { class SQLServer2000Helper { private string connectString; public string ConnectString { get { return connectString; } set { connectString = value; } } SqlConnection conn ; SqlCommand sqlComm; public SqlDataReader dataReader; public void SelectStat(string stat) { try { sqlComm = new SqlCommand(stat, conn); dataReader = sqlComm.ExecuteReader(); } catch (Exception ex) { MessageBox.Show(ex.Message, "error"); } } public bool Open(string connS) { try { conn = new SqlConnection(connS); conn.Open(); return true; } catch (Exception ex) { MessageBox.Show(ex.Message, "error"); return false; } } public void Close() { conn.Close(); } public bool Read() { return dataReader.Read(); } public string SelectUserPwd(string usrName) { try { conn = new SqlConnection(ConnectString); conn.Open(); sqlComm = new SqlCommand("select top 1 pwd from tb_dealer where NAME='" + usrName + "' and STATUS=1", conn); SqlDataReader dr = sqlComm.ExecuteReader(); if (dr.Read()) { return dr["pwd"].ToString(); } else { return ""; } } catch (Exception ex) { MessageBox.Show(ex.Message, "error"); return null; } finally { conn.Close(); } } public bool SqlNonQuery(string sqlStat) { try { conn = new SqlConnection(connectString); conn.Open(); sqlComm.CommandText = sqlStat; sqlComm.Connection = conn; sqlComm.ExecuteNonQuery(); sqlComm.Dispose(); return true; } catch(Exception ex) { MessageBox.Show(ex.Message, "error"); return false; } finally { conn.Close(); } } } } 调用: SQLServer2000Helper sqlServerHelper = new SQLServer2000Helper(); string sqlConnString = "server=" + server + ";uid=" + usr + ";pwd=" + pwd + ";database=" + database; sqlServerHelper.ConnectString = @"" + sqlConnString; //string sqlStat = "select top 1 pwd from tb_xxx where NAME='" + loginForm.txt_User.Text + "' and STATUS=1"; //SqlDataReader dr = null; //sqlServerHelper.ExecSelectSql(sqlStat, dr); if (loginForm.txt_PWD.Text == sqlServerHelper.SelectUserPwd(loginForm.txt_User.Text)) { sqlServerHelper.SqlNonQuery("update tb_xxx set LASTLOGIN_DATETIME= '" + DateTime.Now + "' where NAME='" + loginForm.txt_User.Text + "' and STATUS=1"); }