Sun_Blue_Sky

菩提本无树,明镜亦非台,本来无一物,何处惹尘埃 寻求内心的平静
  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

C#数据类型和SQL数据类型对照

Posted on 2010-04-16 16:11  Sun_Blue_Sky  阅读(327)  评论(0编辑  收藏  举报
代码
 C#操作SQL Float类型,数据会多很多小数,原来是C#的float和sql的float类型不一致

        
/// <summary>
        
/// 数据库中与C#中的数据类型对照
        
/// </summary>
        
/// <param name="type"></param>
        
/// <returns></returns>
        private string ChangeToCSharpType(string type)
        {
            
string reval = string.Empty;
            
switch (type.ToLower())
            {
                
case "int":
                    reval 
= "Int32";
                    
break;
                
case "text":
                    reval 
= "String";
                    
break;
                
case "bigint":
                    reval 
= "Int64";
                    
break;
                
case "binary":
                    reval 
= "System.Byte[]";
                    
break;
                
case "bit":
                    reval 
= "Boolean";
                    
break;
                
case "char":
                    reval 
= "String";
                    
break;
                
case "datetime":
                    reval 
= "System.DateTime";
                    
break;
                
case "decimal":
                    reval 
= "System.Decimal";
                    
break;
                
case "float":
                    reval 
= "System.Double";
                    
break;
                
case "image":
                    reval 
= "System.Byte[]";
                    
break;
                
case "money":
                    reval 
= "System.Decimal";
                    
break;
                
case "nchar":
                    reval 
= "String";
                    
break;
                
case "ntext":
                    reval 
= "String";
                    
break;
                
case "numeric":
                    reval 
= "System.Decimal";
                    
break;
                
case "nvarchar":
                    reval 
= "String";
                    
break;
                
case "real":
                    reval 
= "System.Single";
                    
break;
                
case "smalldatetime":
                    reval 
= "System.DateTime";
                    
break;
                
case "smallint":
                    reval 
= "Int16";
                    
break;
                
case "smallmoney":
                    reval 
= "System.Decimal";
                    
break;
                
case "timestamp":
                    reval 
= "System.DateTime";
                    
break;
                
case "tinyint":
                    reval 
= "System.Byte";
                    
break;
                
case "uniqueidentifier":
                    reval 
= "System.Guid";
                    
break;
                
case "varbinary":
                    reval 
= "System.Byte[]";
                    
break;
                
case "varchar":
                    reval 
= "String";
                    
break;
                
case "Variant":
                    reval 
= "Object";
                    
break;
                
default:
                    reval 
= "String";
                    
break;
            }
            
return reval;
        }



本文来自CSDN博客,转载请标明出处:http:
//blog.csdn.net/kong521/archive/2008/10/23/3132069.aspx