DataColumn 与Xml data type转换。

下面代码通过反射System.Data程序集得到

internal static string XmlDataTypeName(Type type)
{
if (type == typeof(char))
{
return "_";
}
if ((type == typeof(byte[])) || (type == typeof(SqlBytes)))
{
return "base64Binary";
}
if ((type == typeof(DateTime)) || (type == typeof(SqlDateTime)))
{
return "dateTime";
}
if (type == typeof(TimeSpan))
{
return "duration";
}
if (((type == typeof(decimal)) || (type == typeof(SqlDecimal))) || (type == typeof(SqlMoney)))
{
return "decimal";
}
if (type == typeof(int))
{
return "int";
}
if ((type == typeof(bool)) || (type == typeof(SqlBoolean)))
{
return "boolean";
}
if ((type == typeof(float)) || (type == typeof(SqlSingle)))
{
return "float";
}
if ((type == typeof(double)) || (type == typeof(SqlDouble)))
{
return "double";
}
if ((type == typeof(sbyte)) || (type == typeof(SqlByte)))
{
return "byte";
}
if (type == typeof(byte))
{
return "unsignedByte";
}
if ((type == typeof(short)) || (type == typeof(SqlInt16)))
{
return "short";
}
if ((type == typeof(int)) || (type == typeof(SqlInt32)))
{
return "int";
}
if ((type == typeof(long)) || (type == typeof(SqlInt64)))
{
return "long";
}
if (type == typeof(ushort))
{
return "unsignedShort";
}
if (type == typeof(uint))
{
return "unsignedInt";
}
if (type == typeof(ulong))
{
return "unsignedLong";
}
if (type == typeof(Uri))
{
return "anyURI";
}
if (type == typeof(SqlBinary))
{
return "hexBinary";
}
if (((type == typeof(string)) || (type == typeof(SqlGuid))) || ((type == typeof(SqlString)) || (type == typeof(SqlChars))))
{
return "string";
}
if ((type != typeof(object)) && (type != typeof(SqlXml)))
{
return string.Empty;
}
return "anyType";
}
 
 
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值