C# ±àдSQL SERVER 2005 µÄ´æ´¢¹ý³Ì

ÒÔÏÂÊÇÒ»¸ö²éѯIPµØÖ·¹éÊôµØµÄCLR´æ´¢¹ý³Ì£¬Èý²½£º
1¡¢ÓÃC#À´×öDLL£¬´úÂëÈçÏ£º
//====================================================================
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlTypes;
using System.Data.SqlClient;
using Microsoft.SqlServer.Server;
public class AddrInfo
{
    [Microsoft.SqlServer.Server.SqlProcedure]
    public static void getAddrInfo(SqlString ip, out SqlString info)
    {
        using (SqlConnection connection = new SqlConnection("context connection=true"))
        {
            //IPµØַתΪÊý×Ö
            string[] tmp = ip.Value.Split(new string[]{"."},StringSplitOptions.None);
            Int64 ipn = ToInt(ToBinary(tmp[0]) + ToBinary(tmp[1]) + ToBinary(tmp[2]) + ToBinary(tmp[3]));
            connection.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = connection;
            cmd.CommandType = System.Data.CommandType.Text;
            cmd.CommandText = "select addr_info from CZIP where ipn1<="
                                + ipn.ToString() + " and ipn2>="