SQL2000操作类

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"); }