C#与sql,数据类型对应关系
/// <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; }