How to generate dataset?

[Ook]

I think I'm being bitten by holes in the documentation - documentation that
assumes a certain knowledge of how dotnet works, knowledge that I lack :-)

I downloaded and installed odbc.net. I *finally* figured out how to add the
odbcDataAdaptor and odbcConnection to the toolbox, no thanks to the
documentation. So, now I have component1.cs on webform1.aspx. I have a MySQL
database up and running. I have odbcDataAdapter1 and odbcConnection1 on the
component. I even got my MySQL server added to the server explorer. It
works - I know, because it shows me the tables and fields from my MySQL
database. So far so good.

I'm to the point where I'm supposed to generate a dataset, but the menu
options are disabled. What am I missing, what is required to enable these
menu options? Or better yet, how do you do this manually?

[Ignacio Machin]

Hi,

It may be possible that you need some functionality from the DB backend to
generate the dataset, maybe it does not have the commands to return the
types of the columns of the tables, or the names of the tables or maybe it
does not know how to map the DB types to the .NET types.
You can create a dataset manually, just insert a new item in the project
and select DataSet . the rest must be straightforward.
Just post back if you have any problem

Hope this help,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Ook" <usenet@no****@emberts.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

I think I'm being bitten by holes in the documentation - documentation that assumes a certain knowledge of how dotnet works, knowledge that I lack :-)

I downloaded and installed odbc.net. I *finally* figured out how to add the odbcDataAdaptor and odbcConnection to the toolbox, no thanks to the
documentation. So, now I have component1.cs on webform1.aspx. I have a MySQL database up and running. I have odbcDataAdapter1 and odbcConnection1 on the component. I even got my MySQL server added to the server explorer. It
works - I know, because it shows me the tables and fields from my MySQL
database. So far so good.

I'm to the point where I'm supposed to generate a dataset, but the menu
options are disabled. What am I missing, what is required to enable these
menu options? Or better yet, how do you do this manually?