Merging two DataSets - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Merging two DataSets

Message

From

26/01/2006 12:23:06

Bonnie DeWitt
Geneva Systems Group
Ellensburg, Washington, United States

26/01/2006 06:06:20

Pete Kane
Pjk Solutions Ltd
Surrey, United Kingdom

General information

Forum:

ASP.NET

Category:

ADO.NET

Title:

Re: Merging two DataSets

Miscellaneous

Thread ID:

01090083

Message ID:

01090551

Views:

What double-posting? This is the only post I see. And yes, it's gobbledeygook to me too. <g>

You didn't answer my questions though ... is it a Constraint Exception? Since you're using a Biz object to create your Sqlds DataSet, I don't know if that Biz object puts any constraints on your DataSet. If so, that may be your problem. If you still can't figure it out, I suggest serializing both your datasets to XML and posting the XML here so that I have some concrete data to be able to reproduce this and try it myself.

~~Bonnie

>Hello Bonnie, sorry for the double posting but I thought this extra info might help, below is the output from the immediate window
>
>

>?OleDbds.Tables[0].PrimaryKey
>{Length=1}
>    [0]: {System.Data.DataColumn}
>
>?OleDbds.Tables[0].Columns["ClaimRef"].DataType
>{"System.String"}
>    [System.RuntimeType]: {System.RuntimeType}
>    System.Reflection.MemberInfo: {System.RuntimeType}
>    Assembly: {System.Reflection.Assembly}
>    AssemblyQualifiedName: "System.String, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
>    Attributes: 1057025
>    BaseType: {"System.Object"}
>    DeclaringType: <undefined value>
>    defaultBinder: {System.DefaultBinder}
>    DefaultBinder: {System.DefaultBinder}
>    DefaultLookup: 28
>    Delimiter: 46 '.'
>    EmptyTypes: {Length=0}
>    enumType: {"System.Enum"}
>    FilterAttribute: {System.Reflection.MemberFilter}
>    FilterName: {System.Reflection.MemberFilter}
>    FilterNameIgnoreCase: {System.Reflection.MemberFilter}
>    FullName: "System.String"
>    GUID: {System.Guid}
>    HasElementType: false
>    HasProxyAttribute: false
>    IsAbstract: false
>    IsAnsiClass: true
>    IsArray: false
>    IsAutoClass: false
>    IsAutoLayout: true
>    IsByRef: false
>    IsClass: true
>    IsCOMObject: false
>    IsContextful: false
>    IsEnum: false
>    IsExplicitLayout: false
>    IsGenericCOMObject: false
>    IsImport: false
>    IsInterface: false
>    IsLayoutSequential: false
>    IsMarshalByRef: false
>    IsNestedAssembly: false
>    IsNestedFamANDAssem: false
>    IsNestedFamily: false
>    IsNestedFamORAssem: false
>    IsNestedPrivate: false
>    IsNestedPublic: false
>    IsNotPublic: false
>    IsPointer: false
>    IsPrimitive: false
>    IsPublic: true
>    IsSealed: true
>    IsSerializable: true
>    IsSpecialName: false
>    IsUnicodeClass: false
>    IsValueType: false
>    MemberType: TypeInfo
>    Missing: {System.Reflection.Missing}
>    Module: {System.Reflection.Module}
>    Namespace: "System"
>    objectType: {"System.Object"}
>    ReflectedType: <undefined value>
>    TypeHandle: {System.RuntimeTypeHandle}
>    TypeInitializer: {System.Reflection.RuntimeConstructorInfo}
>    UnderlyingSystemType: {"System.String"}
>    valueType: {"System.ValueType"}
>
>
>
>
>?Sqlds.Tables[0].PrimaryKey
>{Length=1}
>    [0]: {System.Data.DataColumn}
>
>?Sqlds.Tables[0].Columns["ClaimRef"].DataType
>{"System.String"}
>    [System.RuntimeType]: {System.RuntimeType}
>    System.Reflection.MemberInfo: {System.RuntimeType}
>    Assembly: {System.Reflection.Assembly}
>    AssemblyQualifiedName: "System.String, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
>    Attributes: 1057025
>    BaseType: {"System.Object"}
>    DeclaringType: <undefined value>
>    defaultBinder: {System.DefaultBinder}
>    DefaultBinder: {System.DefaultBinder}
>    DefaultLookup: 28
>    Delimiter: 46 '.'
>    EmptyTypes: {Length=0}
>    enumType: {"System.Enum"}
>    FilterAttribute: {System.Reflection.MemberFilter}
>    FilterName: {System.Reflection.MemberFilter}
>    FilterNameIgnoreCase: {System.Reflection.MemberFilter}
>    FullName: "System.String"
>    GUID: {System.Guid}
>    HasElementType: false
>    HasProxyAttribute: false
>    IsAbstract: false
>    IsAnsiClass: true
>    IsArray: false
>    IsAutoClass: false
>    IsAutoLayout: true
>    IsByRef: false
>    IsClass: true
>    IsCOMObject: false
>    IsContextful: false
>    IsEnum: false
>    IsExplicitLayout: false
>    IsGenericCOMObject: false
>    IsImport: false
>    IsInterface: false
>    IsLayoutSequential: false
>    IsMarshalByRef: false
>    IsNestedAssembly: false
>    IsNestedFamANDAssem: false
>    IsNestedFamily: false
>    IsNestedFamORAssem: false
>    IsNestedPrivate: false
>    IsNestedPublic: false
>    IsNotPublic: false
>    IsPointer: false
>    IsPrimitive: false
>    IsPublic: true
>    IsSealed: true
>    IsSerializable: true
>    IsSpecialName: false
>    IsUnicodeClass: false
>    IsValueType: false
>    MemberType: TypeInfo
>    Missing: {System.Reflection.Missing}
>    Module: {System.Reflection.Module}
>    Namespace: "System"
>    objectType: {"System.Object"}
>    ReflectedType: <undefined value>
>    TypeHandle: {System.RuntimeTypeHandle}
>    TypeInitializer: {System.Reflection.RuntimeConstructorInfo}
>    UnderlyingSystemType: {"System.String"}
>    valueType: {"System.ValueType"}
>
>

>
>gobbledeygook to me, thanks

Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com

Map

View

Click here to load this message in the networking platform