Davy Li's Weblog

XMQ2Y-4T3V6-XJ48Y-D3K2V-6C4WT
PYHYP-WXB3B-B2CCM-V9DX9-VDY8T

Visual Studio 2008简体中文试用版(90天)变成永久正式版的两种方法：

一、先安装试用版，然后在“添加或删除程序”里找到VS2008，点“更改/删除”就会看到一个输入序列号的地方，把序列号输进去，点“升级”按钮即可，Team Suite和Professional通用。

二、把安装盘下Setupsetup.sdb文件中的[Product Key]项中对应的序列号更改为正式版的序列号后再安装即可。此方法需要重新打包。
因为九十天试用版本已经是rtm版本。所以改变序列号以后的升级或者安装，就会变成正式版，不再有使用期限。

以下是收集的序列号：
1.Visual Studio 2008 Professional Edition:
XMQ2Y-4T3V6-XJ48Y-D3K2V-6C4WT （本人亲自测试，确实可用）

2.Visual Studio 2008 Team Test Load Agent:
WPX3J-BXC3W-BPYWP-PJ8CM-F7M8T

3.Visual Studio 2008 Team System:
PYHYP-WXB3B-B2CCM-V9DX9-VDY8T

4.Visual Studio 2008 Team Foundation Server:
WPDW8-M962C-VJX9M-HQB4Q-JVTDM

ASP.NET(C#)利用QQ的IP数据库QQWry.Dat进行精确IP查询 
  
先下载最新的IP数据库QQWry.Dat
在Google中查找最新的QQWry.Dat
http://www.google.com/search?hl=zh-CN&newwindow=1&q=IP%E6%95%B0%E6%8D%AE+QQWry&btnG=%E6%90%9C%E7%B4%A2&lr=
下载IPLocation.dll
地址：http://www.iwcn.net/attachments/month_0612/g200612161210.rar
在项目中添加引用，引用IPLocation.dll
添加引用：using IPLocation.IPLocation;
关键函数介绍：
IPLocate(Byval StrConn as string,Byval StrIp as string)
其中：StrConn 为数据库连接字符串，如：Server.MapPath("QQWry.Dat")
            StrIP      为查询IP
            返回值是字符串型，是IP的地址
示例：
        将QQWry.Dat放在网站的根目录下
        string conn, ipstr, addstr;
        conn = Server.MapPath("QQWry.Dat");
        ipstr = TextBox1.Text;
        addstr = IPLocation.IPLocation.IPLocate(conn, ipstr);
        Label1.Text = "IP：" + ipstr + " <br> 地址：" + addstr;

using System;
using System.Data;
using System.Data.OleDb;

namespace AccessDAL
{
    /// <summary>
    /// AccessHelper 的摘要说明。
    /// </summary>
    public class AccessHelper
    {
        private AccessHelper()
        {
            //静态构造函数，表示该类不可以被实例化
            //所以的成员都是static类型的
        }
        //<connectionStrings>
  //   <add name="AccessConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\azhou\data\szdsdz.mdb"  
        //        providerName="System.Data.OleDb" />
     //</connectionStrings>
        private static string m_connection = System.Configuration.ConfigurationManager.ConnectionStrings["AccessConnectionString"].ConnectionString;
        /// <summary>
        /// ConnectionString的属性
        /// </summary>
        public static string ConnectionString
        {
            set{ m_connection = value;}
            get{ return m_connection;}
        }

        /// <summary>
        /// 判断OleDbConnection是否已经连接
        /// </summary>
        /// <returns>true 表示OleDbConnection已经连接，或者设置连接成功；
        /// false 表示OleDbConnection尝试连接失败</returns>
        public static string IsConnected()
        {
            OleDbConnection conn = new OleDbConnection(m_connection);
           
            try
            {
                conn.Open();
                return "<div style=\"color:#ff0000;\">连接成功!</div>";
            }
            catch()
            {
                return "<div style=\"color:#ff0000;\">连接失败!</div>"; //return ex.ToString();//调试的时候用
            }
        }

        /// <summary>
        /// 测试能否连接(打开并关闭)
        /// </summary>
        /// <returns></returns>
        public static string IsCanConnected()
        {
            OleDbConnection conn = new OleDbConnection(m_connection);
            string result = "false";
            try
            {
                conn.Open();
                result = "<div style=\"color:#ff0000;\">成功打开数据库!并且成功关闭数据库!</div>";
            }
            catch
            {
                result = "<div style=\"color:#ff0000;\">连接失败!</div>";
            }
            finally
            {
                conn.Close();
            }
            return result;
        }

        /// <summary>
        /// 执行一条Sql命令
        /// </summary>
        /// <param name="cmdText">Sql语句</param>
        /// <returns>表示影响的行数</returns>
        public static int ExecuteText(string cmdText)
        {
            OleDbCommand cmd = new OleDbCommand();
            try
            {
                PrepareCommand(cmd,CommandType.Text,cmdText);
                try
                {
                    return cmd.ExecuteNonQuery();
                }

                catch (OleDbException e)
                {
                    throw (new Exception(e.Message));;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                DisposeCmd(cmd);
            }
        }

        /// <summary>
        /// 执行一条Sql命令（ExecuteScalar），返回一个结果值（int, string, float等类型）。如果不存在记录，返回为null。
        /// </summary>
        /// <param name="cmdText">Sql语句</param>
        /// <returns>返回值（int, string, float等类型）。如果不存在记录，返回为null。</returns>
        public static object ExecuteTextRet(string cmdText)
        {
            OleDbCommand cmd = new OleDbCommand();
            try
            {
                PrepareCommand(cmd, CommandType.Text, cmdText);
                try
                {
                    return cmd.ExecuteScalar();
                }
                catch (OleDbException e)
                {
                    throw (new Exception(e.Message));
                }
            }           
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                DisposeCmd(cmd);
            }
        }

        /// <summary>
        /// 执行一个Sql命令，返回一个DataSet结果集。
        /// </summary>
        /// <param name="cmdText">Sql语句</param>
        /// <param name="TableName">Fill入DataSet中的表名</param>
        /// <returns>DataSet结果集</returns>
        public static DataSet ExecuteTextRet(string cmdText, string TableName)
        {
            DataSet ds = new DataSet();
            OleDbDataAdapter adp = new OleDbDataAdapter();
            OleDbCommand cmd = new OleDbCommand();
            try
            {
                PrepareCommand(cmd, CommandType.Text, cmdText);
                try
                {
                    adp.SelectCommand = cmd;
                    adp.Fill(ds,TableName);
                    return ds;
                }
                catch (OleDbException e)
                {
                    throw (new Exception(e.Message));
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                DisposeCmd(cmd);
            }

        }   

        /// <summary>
        /// 把一个DataSet更新入数据库（可以修改，添加，删除）
        /// 但是，这个表的设计中必须要有主键
        /// </summary>
        /// <param name="cmdText">select语句，和要更新的表对应</param>
        /// <param name="ds">要更新入数据库的DataSet</param>
        /// <param name="TableName">DataSet中的源表名</param>
        /// <returns>影响的行数</returns>
        public static int ExecuteUpdate(string cmdText,DataSet ds,string TableName)
        {
            OleDbDataAdapter adp = new OleDbDataAdapter();
            OleDbCommand cmd = new OleDbCommand();
            try
            {
                PrepareCommand(cmd, CommandType.Text, cmdText);
                adp.SelectCommand = cmd;
                OleDbCommandBuilder builder = new OleDbCommandBuilder(adp);
                return adp.Update(ds,TableName);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                DisposeCmd(cmd);
                adp.Dispose();
            }
        }

        /// <summary>
        /// 设置OleDbCommand的参数
        /// </summary>
        /// <param name="cmd">OleDbCommand对象</param>
        /// <param name="cmdType">类型</param>
        /// <param name="cmdText">Sql语句</param>       
        private static void PrepareCommand(OleDbCommand cmd, CommandType cmdType, string cmdText)
        {   
            OleDbConnection    conn = new OleDbConnection(m_connection);
            try
            {
                conn.Open();
   
                if (cmd != null)
                {
                    cmd.Connection = conn;
                    cmd.CommandText = cmdText;
                    cmd.CommandType = cmdType;
                }               
            }

            catch (OleDbException e)
            {
                throw (new Exception(e.Message));
            }
        }
       

        /// <summary>
        /// 处理OleDbCommand，关闭连接，并且释放内存。
        /// </summary>
        /// <param name="cmd">要处理的OleDbCommand对象</param>
        private static void DisposeCmd(OleDbCommand cmd)
        {
            if (cmd.Connection != null)
            {
                cmd.Connection.Close();
                cmd.Connection.Dispose();
            }
            cmd.Dispose();
        }

        #region 填加段
        /// <summary>
        /// 根据app.config获取连接字符串
        /// </summary>
        /// <returns></returns>
        public static string GetConnectionStringFromConfigFile()
        {
            DataSet ds = new DataSet();
            ds.ReadXml(AppDomain.CurrentDomain.SetupInformation.ConfigurationFile);           
            string result = ds.Tables["appSettings"].Rows[0]["DateSource"].ToString();
            ds.Clear();
            ds.Dispose();

            result = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + result;       
            return result;
        }

        /// <summary>
        /// 根据app.config获取数据源的信息
        /// </summary>
        /// <returns></returns>
        public static string GetDataSourceFromConfigFile()
        {
            DataSet ds = new DataSet();
            ds.ReadXml(AppDomain.CurrentDomain.SetupInformation.ConfigurationFile);           
            string result = ds.Tables["appSettings"].Rows[0]["DateSource"].ToString();
            ds.Clear();
            ds.Dispose();
           
            return result;

        }

        /// <summary>
        /// 设置app.config的数据源信息
        /// </summary>
        /// <param name="dataSource"></param>
        public static void SetDataSourceToConfigFile(string dataSource)
        {
            DataSet ds = new DataSet();
            ds.ReadXml(AppDomain.CurrentDomain.SetupInformation.ConfigurationFile);           
            ds.Tables["appSettings"].Rows[0]["DateSource"]=dataSource;
            ds.AcceptChanges();
            ds.WriteXml(AppDomain.CurrentDomain.SetupInformation.ConfigurationFile);
            ds.Clear();
            ds.Dispose();
        }
        #endregion
    }
}

using System;
using System.Data;
using System.Data.OleDb;

namespace DAL
{
    /**//// <summary>
    /// AccessHelper 的摘要说明。
    /// </summary>
    public class AccessHelper
    {
        private AccessHelper()
        {
            //静态构造函数，表示该类不可以被实例化
            //所以的成员都是static类型的
        }

        private static string m_connection = "";
       
        /**//// <summary>
        /// ConnectionString的属性
        /// </summary>
        public static string ConnectionString
        {
            set
            {
                m_connection = value;
            }
            get
            {
                return m_connection;
            }
        }

        /**//// <summary>
        /// 判断OleDbConnection是否已经连接
        /// </summary>
        /// <returns>true 表示OleDbConnection已经连接，或者设置连接成功；
        /// false 表示OleDbConnection尝试连接失败</returns>
        public static bool IsConnected()
        {
            OleDbConnection conn = new OleDbConnection(m_connection);
           
            try
            {
                conn.Open();
                return true;
            }
            catch
            {
                return false;
            }
        }
   

        /**//// <summary>
        /// 执行一条Sql命令
        /// </summary>
        /// <param name="cmdText">Sql语句</param>
        /// <returns>表示影响的行数</returns>
        public static int ExecuteText(string cmdText)
        {
            OleDbCommand cmd = new OleDbCommand();
            try
            {
                PrepareCommand(cmd,CommandType.Text,cmdText);
                try
                {
                    return cmd.ExecuteNonQuery();
                }

                catch (OleDbException e)
                {
                    throw (new Exception(e.Message));;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                DisposeCmd(cmd);
            }
        }

        /**//// <summary>
        /// 执行一条Sql命令（ExecuteScalar），返回一个结果值（int, string, float等类型）。如果不存在记录，返回为null。
        /// </summary>
        /// <param name="cmdText">Sql语句</param>
        /// <returns>返回值（int, string, float等类型）。如果不存在记录，返回为null。</returns>
        public static object ExecuteTextRet(string cmdText)
        {
            OleDbCommand cmd = new OleDbCommand();
            try
            {
                PrepareCommand(cmd, CommandType.Text, cmdText);
                try
                {
                    return cmd.ExecuteScalar();
                }
                catch (OleDbException e)
                {
                    throw (new Exception(e.Message));
                }
            }           
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                DisposeCmd(cmd);
            }
        }

        /**//// <summary>
        /// 执行一个Sql命令，返回一个DataSet结果集。
        /// </summary>
        /// <param name="cmdText">Sql语句</param>
        /// <param name="TableName">Fill入DataSet中的表名</param>
        /// <returns>DataSet结果集</returns>
        public static DataSet ExecuteTextRet(string cmdText, string TableName)
        {
            DataSet ds = new DataSet();
            OleDbDataAdapter adp = new OleDbDataAdapter();
            OleDbCommand cmd = new OleDbCommand();
            try
            {
                PrepareCommand(cmd, CommandType.Text, cmdText);
                try
                {
                    adp.SelectCommand = cmd;
                    adp.Fill(ds,TableName);
                    return ds;
                }
                catch (OleDbException e)
                {
                    throw (new Exception(e.Message));
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                DisposeCmd(cmd);
            }

        }   

        /**//// <summary>
        /// 把一个DataSet更新入数据库（可以修改，添加，删除）
        /// 但是，这个表的设计中必须要有主键
        /// </summary>
        /// <param name="cmdText">select语句，和要更新的表对应</param>
        /// <param name="ds">要更新入数据库的DataSet</param>
        /// <param name="TableName">DataSet中的源表名</param>
        /// <returns>影响的行数</returns>
        public static int ExecuteUpdate(string cmdText,DataSet ds,string TableName)
        {
            OleDbDataAdapter adp = new OleDbDataAdapter();
            OleDbCommand cmd = new OleDbCommand();
            try
            {
                PrepareCommand(cmd, CommandType.Text, cmdText);
                adp.SelectCommand = cmd;
                OleDbCommandBuilder builder = new OleDbCommandBuilder(adp);
                return adp.Update(ds,TableName);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                DisposeCmd(cmd);
                adp.Dispose();
            }
        }

        /**//// <summary>
        /// 设置OleDbCommand的参数
        /// </summary>
        /// <param name="cmd">OleDbCommand对象</param>
        /// <param name="cmdType">类型</param>
        /// <param name="cmdText">Sql语句</param>       
        private static void PrepareCommand(OleDbCommand cmd, CommandType cmdType, string cmdText)
        {   
            OleDbConnection    conn = new OleDbConnection(m_connection);
            try
            {
                conn.Open();
   
                if (cmd != null)
                {
                    cmd.Connection = conn;
                    cmd.CommandText = cmdText;
                    cmd.CommandType = cmdType;
                }               
            }

            catch (OleDbException e)
            {
                throw (new Exception(e.Message));
            }
        }
       

        /**//// <summary>
        /// 处理OleDbCommand，关闭连接，并且释放内存。
        /// </summary>
        /// <param name="cmd">要处理的OleDbCommand对象</param>
        private static void DisposeCmd(OleDbCommand cmd)
        {
            if (cmd.Connection != null)
            {
                cmd.Connection.Close();
                cmd.Connection.Dispose();
            }
            cmd.Dispose();
        }

        填加段#region 填加段
        /**//// <summary>
        /// 根据app.config获取连接字符串
        /// </summary>
        /// <returns></returns>
        public static string GetConnectionStringFromConfigFile()
        {
            DataSet ds = new DataSet();
            ds.ReadXml(AppDomain.CurrentDomain.SetupInformation.ConfigurationFile);           
            string result = ds.Tables["appSettings"].Rows[0]["DateSource"].ToString();
            ds.Clear();
            ds.Dispose();

            result = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + result;       
            return result;
        }

        /**//// <summary>
        /// 根据app.config获取数据源的信息
        /// </summary>
        /// <returns></returns>
        public static string GetDataSourceFromConfigFile()
        {
            DataSet ds = new DataSet();
            ds.ReadXml(AppDomain.CurrentDomain.SetupInformation.ConfigurationFile);           
            string result = ds.Tables["appSettings"].Rows[0]["DateSource"].ToString();
            ds.Clear();
            ds.Dispose();
           
            return result;

        }

        /**//// <summary>
        /// 设置app.config的数据源信息
        /// </summary>
        /// <param name="dataSource"></param>
        public static void SetDataSourceToConfigFile(string dataSource)
        {
            DataSet ds = new DataSet();
            ds.ReadXml(AppDomain.CurrentDomain.SetupInformation.ConfigurationFile);           
            ds.Tables["appSettings"].Rows[0]["DateSource"]=dataSource;
            ds.AcceptChanges();
            ds.WriteXml(AppDomain.CurrentDomain.SetupInformation.ConfigurationFile);
            ds.Clear();
            ds.Dispose();
        }

        /**//// <summary>
        /// 测试能否连接(打开并关闭)
        /// </summary>
        /// <returns></returns>
        public static bool IsCanConnected()
        {
            OleDbConnection conn = new OleDbConnection(m_connection);
            bool result = false;
            try
            {
                conn.Open();
                result = true;
            }
            catch
            {
                result = false;
            }
            finally
            {
                conn.Close();
            }
            return result;
        }
        #endregion
    }
}
配置文件必须是表结构的.这样:
<appSettings>
<Connection>access</Connection>
<Version>Server</Version>
</appSettings>

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.OleDb;

/// <summary>
/// DataAccess 的摘要说明
/// </summary>
public class DataAccess
{
    protected static OleDbConnection conn = new OleDbConnection();
    protected static OleDbCommand comm = new OleDbCommand();
 public DataAccess()
 {
  //init
 }
    private static void openConnection()
    {
        if (conn.State == ConnectionState.Closed)
        {
            conn.ConnectionString = @"Provider=Microsoft.Jet.OleDb.4.0;Data Source="+ConfigurationManager.AppSettings["myconn"];//web.config文件里设定。
            comm.Connection = conn;
            try
            {
                conn.Open();
            }
            catch (Exception e)
            { throw new Exception(e.Message); }

        }
      
    }//打开数据库
 
    private static void closeConnection()
    {
        if (conn.State == ConnectionState.Open)
        {
            conn.Close();
            conn.Dispose();
            comm.Dispose();
        }
    }//关闭数据库

    public static void excuteSql(string sqlstr)
    {
        try
        {
            openConnection();
            comm.CommandType = CommandType.Text;
            comm.CommandText = sqlstr;
            comm.ExecuteNonQuery();
        }
        catch (Exception e)
        {
            throw new Exception(e.Message);
        }
        finally
        { closeConnection(); }
    }//执行sql语句

    public static OleDbDataReader dataReader(string sqlstr)
    {
        OleDbDataReader dr = null;
        try
        {
            openConnection();
            comm.CommandText = sqlstr;
            comm.CommandType = CommandType.Text;

            dr = comm.ExecuteReader(CommandBehavior.CloseConnection);
        }
        catch
        {
            try
            {
                dr.Close();
                closeConnection();
            }
            catch { }
        }
            return dr;
        }//返回指定sql语句的OleDbDataReader对象，使用时请注意关闭这个对象。
    public static void dataReader(string sqlstr, ref OleDbDataReader dr)
    {
        try
        {
            openConnection();
            comm.CommandText = sqlstr;
            comm.CommandType = CommandType.Text;
            dr=comm.ExecuteReader(CommandBehavior.CloseConnection);
        }
        catch
        {
            try
            {
                if (dr != null && !dr.IsClosed)
                    dr.Close();
            }
            catch
            {
            }
            finally
            {
                closeConnection();
            }
        }
    }//返回指定sql语句的OleDbDataReader对象,使用时请注意关闭

    public static DataSet dataSet(string sqlstr)
    {
        DataSet ds = new DataSet();
        OleDbDataAdapter da = new OleDbDataAdapter();
        try
        {
            openConnection();
            comm.CommandType = CommandType.Text;
            comm.CommandText = sqlstr;
            da.SelectCommand = comm;
            da.Fill(ds);
 
        }
        catch (Exception e)
        {
            throw new Exception(e.Message);
        }
        finally
        {
            closeConnection();
        }
        return ds;
    }//返回指定sql语句的dataset

    public static void dataSet(string sqlstr, ref DataSet ds)
    {
        OleDbDataAdapter da = new OleDbDataAdapter();
        try
        {
            openConnection();
            comm.CommandType = CommandType.Text;
            comm.CommandText = sqlstr;
            da.SelectCommand = comm;
            da.Fill(ds);
        }
        catch (Exception e)
        {
            throw new Exception(e.Message);
        }
        finally
        {
            closeConnection();
        }
    }//返回指定sql语句的dataset

    public static DataTable dataTable(string sqlstr)
    {
        DataTable dt = new DataTable();
        OleDbDataAdapter da = new OleDbDataAdapter();
        try
        {
            openConnection();
            comm.CommandType = CommandType.Text;
            comm.CommandText = sqlstr;
            da.SelectCommand = comm;
            da.Fill(dt);
        }
        catch (Exception e)
        {
            throw new Exception(e.Message);
        }
        finally
        {
            closeConnection();
        }
        return dt;
    }//返回指定sql语句的datatable
    public static void dataTable(string sqlstr, ref DataTable dt)
    {
        OleDbDataAdapter da = new OleDbDataAdapter();
        try
        {
            openConnection();
            comm.CommandType = CommandType.Text;
            comm.CommandText = sqlstr;
            da.SelectCommand = comm;
            da.Fill(dt);
        }
        catch (Exception e)
        {
            throw new Exception(e.Message);
        }
        finally
        {
            closeConnection();
        }
    }//返回指定sql语句的datatable

    public static DataView dataView(string sqlstr)
    {
        OleDbDataAdapter da = new OleDbDataAdapter();
        DataView dv = new DataView();
        DataSet ds = new DataSet();
        try
        {
            openConnection();
            comm.CommandType = CommandType.Text;
            comm.CommandText = sqlstr;
            da.SelectCommand = comm;
            da.Fill(ds);
            dv = ds.Tables[0].DefaultView;
        }
        catch (Exception e)
        {
            throw new Exception(e.Message);
        }
        finally
        {
            closeConnection();
        }
        return dv;
    }
//返回指定sql语句的dataview

}