How to get the old typed dataset

When I create a new typed dataset on v2 by dragging the tables into a dataset component surface I get a lot of stuff that I don't want like dataadapters, queries, connection strings, etc.  I want a type dataset the way v1.1 used to do since I have my stored procs and I use SqlHelper for for all dataadaptor creation, etc.

How can I get that   I can't work with this new way that seems designed for unskilled users but that makes things more complicated for me.

Thanks,

Luis C. Uribe


Answer this question

How to get the old typed dataset

  • Eric Richter

    Luis,

    You can remove the TableAdapters manually.  Open up the strongly-typed DataSet in the designer.  Right-click on the TableAdapter and select "Delete" from the context menu.  You'll see a dialog asking if you want to delete the DataTable as well.  Click "No".

    I hope this information proves helpful.

    David Sceppa
    ADO.NET Program Manager
    Microsoft

  • MaheshKshirsagar


    That error doesn't ring a bell, Luis.  I wasn't able to cause that problem in the small sample app I created.  If you can provide steps to reproduce the problem, I might be able to figure out the cause of the problem.

    David Sceppa
    ADO.NET Program Manager
    Microsoft

  • David Pritchard

    Thanks David for the reply.  That got me closer by removing the items that I did not want.  However, I still get one error due to a conflict in MySettings:

    Error 14 module 'MySettingsProperty' and module 'MySettingsProperty', declared in 'c:\VS2005\PTF2005\BLptf\My Project\MySettings.Designer.vb', conflict in namespace 'My'. c:\VS2005\PTF2005\BLptf\My Project\Settings.Designer.vb 67 19 BLptf

    Thanks fro any further help,

    Luis C. Uribe


  • heinrich Breedt

    Luis,

    We wrote a little utility program that would connect to the database, execute whatever StoredProc you told it to execute, and then take the result set and do a DataSet.WriteXmlSchema() to create our .xsd files. Pretty easy.



  • Adam Davidson

    This is exactly what I have been doing and gives me a dataset bloated with a lot of stuff like data adapters, queries to update/delete/insert to data tables, connection strings, etc.  The old typed dataset did not have all this stuff.  The data adaptors were an optional item that one could add later but that I do not use since I have all my CRUD stored procedures already made and I use SQLhelper class for data access layer.

    If I configure the resulting dataadapters in the advanced tab I can suppress the queries but still the program does not compile because InitConnection looks for a connection string in the settings that I do not have because I do not need it.

    I wish MS offered two ways of creating a typed dataset:  the old 1.1 way for those who need it and the new heavy dataset for those who like it.

    Thanks,

    Luis C. Uribe


  • rasmasyean

    Hi,



    Create a DataSource, Goto toolbox, Find the Dataset object, drag it into the form, A Add Dataset Dialogbox will appear, Choose typed Dataset and choose your Dataset name in the combobox...






    cheers,


    Paul June A. Domag

  • How to get the old typed dataset