Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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>="
                            


Ïà¹ØÎĵµ£º

Ó¦ÓÃIDS·ÀÖ¹SQL×¢Èë¹¥»÷

Ó¦ÓÃIDS·ÀÖ¹SQL×¢Èë¹¥»÷
http://www.cnhacker.com/Hacker/Skills/200807/t20080731_6187.html
Ŀǰ£¬Õë¶ÔÓ¦Óü°Æäºǫ́Êý¾Ý¿âµÄÓ¦Óü¶ÈëÇÖÒѾ­±äµÃÔ½À´Ô½²þâ±£¬ÈçSQL×¢Èë¡¢¿çÕ¾µã½Å±¾¹¥»÷ºÍδ¾­ÊÚȨµÄÓû§·ÃÎʵȡ£ËùÓÐÕâЩÈëÇÖ¶¼ÓпÉÄÜÈÆ¹ýǰ̨°²È«ÏµÍ³²¢¶ÔÊý¾ÝÀ´Ô´·¢Æð¹¥»÷¡£
ΪÁ˶Ը¶ÕâÀàÍþв£¬ÐÂÒ»¼¶±ðµÄ°²È«ÍÑÓ±¶ø³ö£ ......

ºÚ¿Í¹¥ÆÆSQL·þÎñÆ÷ϵͳµÄÊ®ÖÖ·½·¨

ÎÞÂÛÊÇʹÓÃÊÖ¹¤ÊÔ̽»¹ÊÇʹÓð²È«²âÊÔ¹¤¾ß£¬¶ñÒâ¹¥»÷Õß×ÜÊÇʹÓø÷ÖÖ¹î¼Æ´ÓÄãµÄ·À»ðǽÄÚ²¿ºÍÍⲿ¹¥ÆÆÄãµÄSQL·þÎñÆ÷ϵͳ¡£¼ÈÈ»ºÚ¿ÍÔÚ×öÕâÑùµÄÊÂÇé¡£ÄãÒ²ÐèҪʵʩͬÑùµÄ¹¥»÷À´¼ìÑéÄãµÄϵͳµÄ°²È«ÊµÁ¦¡£ÕâÊÇÀíËùµ±È»µÄ¡£ÏÂÃæÊǺڿͷÃÎʺ͹¥ÆÆÔËÐÐSQL·þÎñÆ÷µÄϵͳµÄÊ®ÖÖ¹î¼Æ¡£
1.ͨ¹ý»¥ÁªÍøÖ±½ÓÁ¬½Ó
ÕâЩÁ¬½Ó¿ÉÒÔÓÃÀ´¹¥»÷ûÓзÀ ......

SQL´æ´¢¹ý³Ì»ù´¡Óï·¨

Ò».×¢ÊÍ
-- µ¥ÐÐ×¢ÊÍ£¬´ÓÕâµ½±¾ÐнáÊøÎª×¢ÊÍsql Óï·¨£¬ÀàËÆC++£¬c#ÖÐ//
/* … */ ¶àÐÐ×¢ÊÍ£¬ÀàËÆC++£¬C#ÖÐ/* … */
¶þ.±äÁ¿£¨int£¬ smallint£¬ tinyint£¬ decimal£¬float£¬real£¬ money £¬smallmoneysql Óï·¨£¬ text £¬image£¬ char£¬ varchar¡£¡£¡£¡£¡£¡££©
Óï·¨£º
DECLARE
{
{@local_variable data_t ......

¸ù¾Ý¿í¶ÈÀ´¾ö¶¨ÏÔʾµÄ×Ö·û´®³¤¶È(C#)

¸ù¾Ý¿í¶ÈÀ´¾ö¶¨ÏÔʾµÄ×Ö·û´®³¤¶È (C#,VS2005)
Èç¹û lable³¤¶È¹Ì¶¨µ«×Ö·û´®³¤¶È¿É±ä£¬Èç¹û³¬¹ýÁËlableÏÔʾµÄ³¤¶Èʱ£¬Ï£ÍûÓà ...´úÌæÊ£ÏµÄ×Ö·û£¬ÕâʱÐèÒªÒ»¸öº¯Êý
Graphics.MeasureString
¾ßÌå´úÂëÈçÏÂ
  public string Abbreviation(string str)
        {
  &nbs ......

c#3.0 ÐÂÌØÐÔÖ®Òþº¬ÀàÐÍVAR

ÔÚC#3.0ÖÐÔö¼ÓÁËÒ»¸ö±äÁ¿ÉùÃ÷var£¬Õâ¸öÉùÃ÷ºÍJavaScriptµÄvarÀàËÆ£¬µ°Ò²²»Í¬¡£(*^__^*) ÎûÎû……
1.Ïàͬµã£¬Ëü¿ÉÒÔÓÃvarÀ´ÉùÃ÷ÈκÎÀàÐ͵ľֲ¿±äÁ¿¡£
2.²»Í¬µã Ëü½ö½ö¸æËß±àÒëÆ÷£¬¸Ã±äÁ¿ÐèÒª¸ù¾Ý³õʼ»¯±í´ïʽÀ´È·¶¨±äÁ¿µÄÀàÐÍ£¬¶øÇÒÖ»ÄÜÊǾֲ¿±äÁ¿¡£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ