Submit My Question - Recent Questions - Recent Answer

Msdn Tech >> .NET Development >> .NET Framework Data Access and Storage

Typed Dataset - How To Generate from XSD

VS 2003 was simple.

Create xml data, right click generate schema, right click and generated typed dataset.

How do I do this in 2005?

Dave

[145 byte] By [Webbert] at [2007-12-16]

«« Office Web Components: axSpreadSheet issue
»» determine if toolstrip is overflowing

# 1

Hi,

How to: Create a Typed Dataset

Regards,
Vikram

Vikram at 2007-9-9 >

top of Msdn Tech,.NET Development,.NET Framework Data Access and Storage...

# 2

Right click->Open With...->Dataset Designer
and also set "Custom Tool" property to "MSDataSetGenerator"

TheXMLMan at 2007-9-9 >

# 3

Just do Add New Item from your project and select DataSet. It is now typed by default so as you drag tables from your server explorer and drop them on the designer canvas the code is generated into a partial class in DataSet1.Designer.cs.

ChrisLovett at 2007-9-9 >

# 4

Thanks for all the replies, but I don't have a database I want to drag and drop tables and such from. I want to created a typed dataset based on nothing and then use it to store information.

I am now going to be REQUIRED to use the designer?
I'm more of a notepad kinda guy. I want to be able to type the
fields, right click and go.

Any thoughts are appreciated.

Dave

Webbert at 2007-9-9 >

# 5

I am in a similar situation. I have a large, detailed XML schema from a legacy application that I need to use to create a typed dataset. It would be a major effort to recreate this from scratch in the designer. VS2003 had this kind of capability. What happened to it in VS2005?

Lowell at 2007-9-9 >

# 6

I'm in the same boat. The online docs refer to a "Generate Dataset" command on the Schema menu, as was the case in VS 2003. I see no such command on the Schema menu in VS 2005 Beta 2. Any suggestions would be greatly appreciated.

JeffT at 2007-9-9 >

# 7

Chris Lovett wrote:
Just do Add New Item from your project and select DataSet. It is now typed by default so as you drag tables from your server explorer and drop them on the designer canvas the code is generated into a partial class in DataSet1.Designer.cs.

This works in "non-website"-projects. But how to generate a DS in a website-project? The only way i found is to do this in a temporary project (whit the same connection-configuration etc.)

Dr.MartinLuckow at 2007-9-9 >

# 8

I'm also having this problem in VS 05. It was or used to be simple to generate a dataset from an *.xsd file.

I'm finding this a real problem in 05. I've imported an xsd file and would like to generate a typed dataset from it but it doesn't work with what has been suggested in this thread (designing in the dataset editor does not work or I'm missing something, which you to be simple in VS03). Any ideas?

Is this by design or has MS developers over looked this important functionality? From what I've experienced so far it is a step backwards for the software and is an extremely frustrating problem.

pugs at 2007-9-9 >

# 9

pugs wrote:
I'm also having this problem in VS 05. It was or used to be simple to generate a dataset from an *.xsd file.
I'm finding this a real problem in 05. I've imported an xsd file and would like to generate a typed dataset from it but it doesn't work with what has been suggested in this thread (designing in the dataset editor does not work or I'm missing something, which you to be simple in VS03). Any ideas?
Is this by design or has MS developers over looked this important functionality? From what I've experienced so far it is a step backwards for the software and is an extremely frustrating problem.

Seems i was too fast: Put the xsd in the App_Code-Folder and "imagine it has been compiled" :)
It works. When writing code, simply type in the name of the DS and intellisense will show the rest (adapters, methods,...).
But: you will never see the compiled files (....Designer.cs) - they are in the asp.net-temps.

Dr.MartinLuckow at 2007-9-9 >

# 10

When you have XSD file you can create Typed DataSet by using XSD.exe utility.

It is a part of Framework SDK.

SergeyDubinets-MSFT at 2007-9-9 >

.NET Development

.NET Framework Data Access and Storage

.NET Development Hot Topic

.NET Development New Topic

.NET Development

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech