protected void Button1_Click(object sender, EventArgs e)
    {
        int score = int.Parse(ToDBC(this.TextBox1.Text));
        string strsql = "insert into tb values('aa','bb',"+score+")";
        SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=sa;database=pubs");
        SqlDataAdapter ada = new SqlDataAdapter(strsql,con);
        DataSet ds = new DataSet();
        ada.Fill(ds);
    }
    public string ToDBC(string input)
    {
        char[] c = input.ToCharArray();
        for (int i = 0; i < c.Length; i++)
        {
            if (c[i] == 12288)
            {
                c[i] = (char)32;
                continue;
            }
            if (c[i] > 65280 && c[i] < 65375)
                c[i] = (char)(c[i] - 65248);
        }
        return new string(c);
    }

 

 

 /**//// <summary>
        /// 转全角的函数(SBC case)
        /// </summary>
        /// <param name="input">任意字符串</param>
        /// <returns>全角字符串</returns>
        ///<remarks>
        ///全角空格为12288,半角空格为32
        ///其他字符半角(33-126)与全角(65281-65374)的对应关系是:均相差65248
        ///</remarks>       
        public string ToSBC(string input)
        {
            //半角转全角:
            char[] c=input.ToCharArray();
            for (int i = 0; i < c.Length; i++)
            {
                if (c[i]==32)
                {
                    c[i]=(char)12288;
                    continue;
                }
                if (c[i]<127)
                    c[i]=(char)(c[i]+65248);
            }
            return new string(c);               
        }

posted on 2008-10-13 18:23  游子  阅读(932)  评论(0编辑  收藏  举报