商業源碼熱門下載www.html.org.cn

using system;
using system.data;
using system.configuration;
using system.web;
using system.web.security;
using system.web.ui;
using system.web.ui.webcontrols;
using system.web.ui.webcontrols.webparts;
using system.web.ui.htmlcontrols;
using system.data.sqlclient;
namespace mysqlserver
{
    /// <summary>
    /// sqlserverdatabase 的摘要說明
    /// </summary>
    public class sqlserverdatabase
    {
        private string strerror = null;
        private int intcount = 0;
        public sqlserverdatabase()
        {
            //
            // todo: 在此處添加構造函數邏輯
            //
        }
        /// <summary>
        /// 公開方法dbconn，返回數據庫連接
        /// </summary>
        /// <returns></returns>
        public sqlconnection dbconn()
        {
            string strconn = "server=(local);database=globalmeetings;uid=sa;pwd=";
            try
            {
                return new sqlconnection(strconn);
            }
            catch (exception)
            {
                return null;
            }
        }
        /// <summary>
        /// 公開屬性errormessage，返回錯誤信息
        /// </summary>
        public string errormessage
        {
            get
            {
                return strerror;
            }
        }

        /// <summary>
        /// 根據查詢語句從數據庫檢索數據
        /// </summary>
        /// <param name="strselect">查詢語句</param>
        /// <param name="sqlconn">數據庫連接</param>
        /// <returns>有數據則返回dataset對象，否則返回null</returns>
        public dataset select(string selectstring, sqlconnection sqlconn)
        {
            strerror = "";
            sqlconnection conn;
            if (sqlconn == null)
            {
                conn = dbconn();
            }
            else
            {
                conn = sqlconn;
            }
            try
            {
                //若數據庫連接的當前狀態是關閉的，則打開連接
                if (conn.state == connectionstate.closed)
                {
                    conn.open();
                }
                sqldataadapter mysqldataadapter = new sqldataadapter();
                sqlcommand selectcommand = new sqlcommand(selectstring, conn);
                selectcommand.commandtype = commandtype.text;
                mysqldataadapter.selectcommand = selectcommand;
                dataset myds = new dataset();
                mysqldataadapter.fill(myds);
                return myds;
            }
            catch (exception e)
            {
                strerror = "數據檢索失敗：" + e.message;
                return null;
            }
            finally
            {
                if (conn.state != connectionstate.closed)
                {
                    conn.close();
                }
            }
        }
        /// <summary>
        /// 更新數據庫
        /// </summary>
        /// <param name="updatestring">update sql語句</param>
        /// <param name="sqlconn">數據庫連接</param>
        /// <returns>更新成功返回true</returns>
        public bool update(string updatestring, sqlconnection sqlconn)
        {
            return udidatabase(updatestring, sqlconn);
        }
        /// <summary>
        /// 從數據庫中刪除數據
        /// </summary>
        /// <param name="deletestring">delete sql語句</param>
        /// <param name="sqlconn">數據庫連接</param>
        /// <returns>刪除成功返回true</returns>
        public bool delete(string deletestring, sqlconnection sqlconn)
        {
            return udidatabase(deletestring, sqlconn);
        }
        /// <summary>
        /// 把數據插入數據庫
        /// </summary>
        /// <param name="insertstring">insert sql語句</param>
        /// <param name="sqlconn">數據庫連接</param>
        /// <returns>插入成功返回true</returns>
        public bool insert(string insertstring, sqlconnection sqlconn)
        {
            return udidatabase(insertstring, sqlconn);
        }
        /// <summary>
        /// 根據sql語句更新數據庫
        /// </summary>
        /// <param name="udistring">更新語句</param>
        /// <param name="sqlconn">數據庫連接</param>
        /// <returns>更新成功則返回true</returns>
        public bool udidatabase(string udistring, sqlconnection sqlconn)
        {
            strerror = "";
            sqlconnection conn;
            if (sqlconn == null)
            {
                conn = dbconn();
            }
            else
            {
                conn = sqlconn;
            }
            try
            {
                if (conn.state == connectionstate.closed)
                {
                    conn.open();
                }
                sqlcommand cmd = new sqlcommand(udistring, conn);
                cmd.commandtype = commandtype.text;
                intcount = cmd.executenonquery();
                return !(intcount < 1);
            }
            catch (exception e)
            {
                strerror = "更新數據庫失敗：" + e.message;
                return false;
            }
            finally
            {
                if (conn.state != connectionstate.closed)
                {
                    conn.close();
                }
            }
        }
    }
}
 -----------------------------
兩種調用方法
1、                    string struserpsw = userpsw.text.trim();
                    string userpassword = system.web.security.formsauthentication.hashpasswordforstoringinconfigfile(struserpsw, "md5");//md5加密
                    sqlserverdatabase obj = new sqlserverdatabase();
                    obj.insert("insert into asuserinfo (username,userpassword,question,answer,createtime) values('" + username.text.trim() + "','" + userpassword + "','" + question.text.trim() + "','" + answer.text.trim() + "','" + datetime.now.tostring() + "' )", null);
2、        private bool isusernameexist(string strusername)
        {
            bool bret = true;
            sqlserverdatabase db = new sqlserverdatabase();
            dataset ds = db.select("select * from asuserinfo where username = '" + strusername + "'", null);
            if (ds == null || ds.tables.count == 0 || ds.tables[0].rows.count == 0)
            {
                bret = false;
            }
            else
            {
                bret = true;
            }

            return bret;
        }