2007年6月所有随笔

6月19

赵堡太极拳 75 式今天大功告成

分类：杂记|评论：0 条|阅读：1727 次|posted @ 2007年6月19日 15:47:27

4月19日开学的第一天，时至今天6月19日，整整两个月的时间终于学完赵堡太极拳 75 式，老师说这套拳我算是比较顺的，学的也比较快，从明天开始进入加固阶段，每天坚持练拳，力争去除亚健康。

6月18

SQL SERVER 与 C# 中数据类型的对应关系

分类：C#|评论：0 条|阅读：2076 次|posted @ 2007年6月18日 21:45:35
private string ChangeToCSharpType(string type)
{
            string reval = string.Empty;
            switch (type.ToLower())
            {
                case "int":
                    reval = "Int32";    // int
                    break;
                case "text":
                    reval = "String";   // string
                    break;
                case "bigint":
                    reval = "Int64";    // long
                    break;
                case "binary":
                    reval = "System.Byte[]";    // byte[]
                    break;
                case "bit":
                    reval = "Boolean";  // bool
                    break;
                case "char":
                    reval = "String";   // string
                    break;
                case "datetime":
                    reval = "System.DateTime";
                    break;
                case "decimal":
                    reval = "System.Decimal";   // decimal
                    break;
                case "float":
                    reval = "System.Double";    // double
                    break;
                case "image":
                    reval = "System.Byte[]";    // byte[]
                    break;
                case "money":
                    reval = "System.Decimal";   // decimal
                    break;
                case "nchar":
                    reval = "String";
                    break;
                case "ntext":
                    reval = "String";
                    break;
                case "numeric":
                    reval = "System.Decimal";   // decimal
                    break;
                case "nvarchar":
                    reval = "String";
                    break;
                case "real":
                    reval = "System.Single";    // float
                    break;
                case "smalldatetime":
                    reval = "System.DateTime";
                    break;
                case "smallint":
                    reval = "Int16";    // short
                    break;
                case "smallmoney":
                    reval = "System.Decimal";   // decimal
                    break;
                case "timestamp":
                    reval = "System.DateTime";
                    break;
                case "tinyint":
                    reval = "System.Byte";  // byte
                    break;
                case "uniqueidentifier":
                    reval = "System.Guid";
                    break;
                case "varbinary":
                    reval = "System.Byte[]";    // byte[]
                    break;
                case "varchar":
                    reval = "String";   // string
                    break;
                case "Variant":
                    reval = "Object";   // object
                    break;
                default:
                    reval = "String";   // string
                    break;
            }
            return reval;
}