Generate Dataset not supported in new .net

Hi all,

with earlier version of .net we were able to generate a Dataset with an XML schema Item. We could add the columns we want and generate the class to use when we require.

But with new version this is no longer supported.
I want to have the dataset defined and to use when i require.

The current version support to have a dataset item and create the tables. But this need database connection at the time of creation.
I want to make these independent.

could any one please give help on how to generate the DataSet.cs file

Thanks

Answer this question

Generate Dataset not supported in new .net

Richard Bunce

Ok, I am using Free version of MS VS Express 2005 and the story is as under;

VC# Express 2005 not supports Web applications. You have to use VWD Express 2005 for it and all activities work the same there as I narrated earlier.

When u open ur related form in design view all components are there which one can need for data access ( even its better then VC# express).

Are you using VWD Express 2005 for your web application or some earlier version of VS

Please, Tell us in some more details. May be some one can help you better then.

Regards,
Rivorus

Ok, there are many ways to throw the defined Dataset object on your form. easy way would be;

Grab the Dataset from the Data sources Tab ( if u dont have it then Go to Data manue and Click "Show Data Sources" or use Shift+Alt+D keys combination)

When u throw this object on ur form (in design View) you will have 4 types of objects ready to use;

1. Dataset
2. DatabindingSource
3. DataTableAdaptor
4. BindingNavigator

You can use ToolBox for this reason also but it will be a bit complex for first use.

(a)

If you are interested then u will find ur created objects under
"'your Project Name'+ Componets " objects list. Throw them on ur form and they are ready to use.

(b)

You can use Objects from "Data toolbox" also which is in the same Toolbox.
But you have to configure all the objects one by one accourding to your requeirment.

some times, I saw its a bit mean when you grab and throw the Tables. I select them many times and it works after hundreth selection. I think it could be because of my machine but not the environment.

Did this solve your problem
Kosmosniks
Hi ,

I just tried out your method. But the DataSet in the toolbox is available for only windows applications. but my one is a Web App. :(

Do you know any mothod to proceed

rgds
Cat man
Hi all,

Im using this in a Web Application.

What I need is , already there is a database class which accepts a DataSet Type object .

I need to fill the datasets which i need in this project through this class. For that I need to pass different dataset objects to this method from different classes. Ex : EmployeeDataAccess , DeptDataAccess ...

There for what i thought was to create EmployeeDS and DeptDS with the appropriate tables and columns I need and to get the respective DataSet classes genereated from the IDE . Then I can use those objects to be passed to my Commeon DataAccess class.

could you please help me to get this solved.

in 2005 though i can add tables for a dataset type Item .. I cant use it as a DataSet object.

thnks.
SpurryMoses
Visual Studio 2005 stills supports creating DataSet classes, with no database connection required. Add a new item to your project, select Dataset, and right-click on the designer window to add a new datatable.
Raghavendra_desai25
Hey,

There are better tools available to do the job, specifically for the web world the DataSource controls, and for the windows world, the binding controls. What type of application are you using, and why do you need a dataset specifically

Brian
Generate Dataset not supported in new .net

Answer this question