Convert Dataset to Recordset with C#

最新推荐文章于 2015-05-23 10:15:25 发布

chrisyue

最新推荐文章于 2015-05-23 10:15:25 发布

阅读量1k

点赞数

文章标签： dataset c# interop database service string

本文链接：https://blog.csdn.net/chrisyue/article/details/1545683

版权

Web Service in C#, it is easy to operate database with dataset, it is necessary to convert dataset to recordset:

static public ADODB.Recordset ConvertToRecordset(DataTable inTable)
    {
        ADODB.Recordset result = new ADODB.Recordset();
        result.CursorLocation = ADODB.CursorLocationEnum.adUseClient;

ADODB.Fields resultFields = result.Fields;
System.Data.DataColumnCollection inColumns = inTable.Columns;

        foreach (DataColumn inColumn in inColumns)
        {
            resultFields.Append(inColumn.ColumnName
                , TranslateType(inColumn.DataType)
                , inColumn.MaxLength
                , inColumn.AllowDBNull ? ADODB.FieldAttributeEnum.adFldIsNullable :
                                         ADODB.FieldAttributeEnum.adFldUnspecified
                , null);
        }

        result.Open(System.Reflection.Missing.Value
                , System.Reflection.Missing.Value
                , ADODB.CursorTypeEnum.adOpenStatic
                , ADODB.LockTypeEnum.adLockOptimistic, 0);

        foreach (DataRow dr in inTable.Rows)
        {
            result.AddNew(System.Reflection.Missing.Value,
                          System.Reflection.Missing.Value);

            for (int columnIndex = 0; columnIndex < inColumns.Count; columnIndex++)
            {
                resultFields[columnIndex].Value = dr[columnIndex];
            }
        }

return result;
}

    static ADODB.DataTypeEnum TranslateType(Type columnType)
    {
        switch (columnType.UnderlyingSystemType.ToString())
        {
            case "System.Boolean":
                return ADODB.DataTypeEnum.adBoolean;

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

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

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

case "System.Decimal":
return ADODB.DataTypeEnum.adCurrency;

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

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

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

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

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

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

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

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