zdrakec
unread,Sep 5, 2012, 12:06:26 PM9/5/12You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
Hullo:
I pass a new datatable to SQLDataAdapter.FillSchema, specifying that it use SchemaType.Mapped. The particular select command, hits a table that has only one integer field, the first, which is an identity column and the primary key.
Immediately after calling FillSchema, I call Fill, again passing the datatable.
The call to Fill is failing with this error message:
"Cannot convert object of type 'System.Data.SqlTypes.SqlInt32' to object of type 'System.Int64'."
So I checked, and indeed the datatable's first column is of type SqlInt32. Experimenting, I tried setting it, after the FillSchema call, to be SqlInt64, but got the same result.
What I am doing wrong?
Thanks much,
zdrakec