Re: Typed DataSet and Stored Procedure

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Mythran (kip_potter_at_hotmail.com)
Date: 08/25/04


Date: Wed, 25 Aug 2004 10:10:11 -0700

One way to "test" and find out what the difference is between the two datasets
which is causing the typed dataset to fail is to export the schema of the
un-typed dataset and then compare it to the typed dataset's schema xmlschema
(check out WriteXmlSchema for both datasets).

Anywho, what is the exception you are getting when you fill the typed dataset?

Mythran

"Andrew" <Andrew@discussions.microsoft.com> wrote in message
news:C6FEE810-0D74-48B2-BF2B-EC4AE440CD91@microsoft.com...
> I am using a Typed Recordset which won't populate using a SqlDataAdapter.Fill
> method. I am passing in the dataset and the Stored procedure name.
>
> I can pass in an untyped dataset and that get's populated, I can then
> populated the typed dataset from this one. I guess I feel this an unnecessay
> double update. Some of the fields returned by the stored proc are null, but i
> don't see why this should make any difference.
>
> To complicate things I am using a separate component to assess the database
> and run the stored procs, but it doesn't do anything special.
>
> I am only returning the contents os one table. Does any one have any ideas
> what is actually failing, because I really cna't see what is going wrong.
>
> Many Thanks Andy



Relevant Pages

  • Re: Dataset VS DataReader - Performance
    ... Using a Typed Dataset - dataadapter to populate the t-dataset. ... Using a Custom defined dataobject - use datareader to populate it. ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Dataset VS DataReader - Performance
    ... Using a Typed Dataset - dataadapter to populate the t-dataset. ... Using a Custom defined dataobject - use datareader to populate it. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Typed Dataset with multiple tables
    ... I show a custom dataset example here: ... db call, multiple tables populated. ... I have generated a typed dataset containing two tables in vs2005. ... I would like to populate both the tables ...
    (microsoft.public.dotnet.languages.csharp)
  • typed dataset and datagrid
    ... I have a datagrid on a webform that is being populated by a typed dataset ... It populate just fine but I need to know how to update the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: convert untyped datatable/dataset into strongly typed
    ... Since your stored proc returns you various schemas there is no way you could ... You'll have to create a strong typed dataset per result at design time. ... > I am trying to create a strongly typed datatable/dataset from an untyped ...
    (microsoft.public.dotnet.languages.csharp)