java recordset转map_将DataTable对象转换为Recordset对象

using System;

using System.Data;

using ADODB;

using System.Reflection;

namespace Tao.Tool

{

///

/// 用于将ado.net的对象转换为ado的对象。

///

public sealed class ADONETtoADO

{

///

/// 将DataTable对象转换为Recordeset对象

///

/// DataTable对象

/// 转换后得到的Recordeset对象

public static Recordset ConvertDataTableToRecordset(DataTable table)

{

Recordset rs=new RecordsetClass();

//DataRow dr;

//DataRow dr;

foreach(DataColumn dc in table.Columns)

{

rs.Fields.Append(dc.ColumnName, GetDataType(dc.DataType), -1, FieldAttributeEnum.adFldIsNullable);

}

rs.Open(Missing.Value, Missing.Value, CursorTypeEnum.adOpenUnspecified,

rs.Open(Missing.Value, Missing.Value, CursorTypeEnum.adOpenUnspecified,

rs.Open(Missing.Value, Missing.Value, CursorTypeEnum.adOpenUnspecified,

LockTypeEnum.adLockUnspecified, -1);

foreach(DataRow dr in table.Rows)

foreach(DataRow dr in table.Rows)

foreach(DataRow dr in table.Rows)

{

rs.AddNew(Missing.Value, Missing.Value);object o;

for(int i=0; i

{

rs.Fields[i].Value=dr[i];

o=rs.Fields[i].Value;

}

}

return rs;

return rs;

return rs;

}

///

///

///

/// 将ADO.NET的数据类型转换为ADO的数据类型

///

/// ADO.NET的数据类型

/// ADO的数据类型

public static DataTypeEnum GetDataType(Type dataType)

{

switch(dataType.ToString())

{

case "System.Boolean":  return DataTypeEnum.adBoolean;

case "System.Byte":              return DataTypeEnum.adUnsignedTinyInt;

case "System.Char":             return DataTypeEnum.adChar;

case "System.DateTime":return DataTypeEnum.adDate;

case "System.Decimal":  return DataTypeEnum.adDecimal;

case "System.Double":   return DataTypeEnum.adDouble;

case "System.Int16":             return DataTypeEnum.adSmallInt;

case "System.Int32":             return DataTypeEnum.adInteger;

case "System.Int64":             return DataTypeEnum.adBigInt;

case "System.SByte":            return DataTypeEnum.adTinyInt;

case "System.Single":     return DataTypeEnum.adSingle;

case "System.String":     return DataTypeEnum.adVarChar;

//case "TimeSpan":return DataTypeEnum.

case "System.UInt16":   return DataTypeEnum.adUnsignedSmallInt;

case "System.UInt32":   return DataTypeEnum.adUnsignedInt;

case "System.UInt64":   return DataTypeEnum.adUnsignedBigInt;

default:throw(new KitsClasses.MyException("没有对应的数据类型"));

}

}

}

}