Dataset Creation Using Programmatically

[CypherDrive]

Hi friends,

I wish to create a dataset programmatically with it's columns and rows be
able to view it graphically using the xsd file. Is this possible? If
possible will you please give me a few instructions How to do it.

Thanks,


Cypher Drive

 

[Jialiang Ge [MSFT]]

Hello Cypher Drive

Would you please explain the need "to create a dataset programmatically
with it's columns and rows be able to view it graphically using the xsd
file" with an example? I'm sorry that I cannot understand the request. If
you meant to programmatically generate a Typed Dataset, you may consider
programmatically calling XSD.exe
http://msdn.microsoft.com/en-us/library/wha85tzb(VS.80).aspx

and Brent Gardner's Blog may also help you:
http://blogs.orcsweb.com/brent/archive/2007/04/17/programmatically-generate-
typed-datasets.aspx

Regards,
Jialiang Ge ([email protected], remove 'online.')
Microsoft Online Community Support

=================================================
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

This posting is provided "AS IS" with no warranties, and confers no rights.
=================================================

 

[Cor Ligthert[MVP]]

Cupherdrive is it not more easy to create a non strongly typed dataset. As
you create an XSD first is that for sure then creaded loosely typed.


It is as well easy as you tell in these code question what language you use,
it does not botter for me which one, but to show twice how simple it is to
creade a dataset is in my idea a little bit overdone.

Cor

 

[CypherDrive]

Ge,

My developers are using VB.Net 2005 Express Edition and they wanted to
create a datasets programmatically and be able to display them graphically.
They say they always have to go back to the Dataset Configuration Wizard if
there Are Changes in the Table.

I believe they need to programmatically update the Graphical Datasets in
case they alter the table in the SQL. They want to update it by not using
the Dataset Configuration Wizard.

Being able to configure the Dataset programmatically and Dynamically
updating the Graphical representation Helps during the Development
Process.

Thanks,


I believe what they want to do is to be able to sychronize their dataset

 

[CypherDrive]

Dear Cor,

Thanks so much for your advice.

Regards,

Cypher Drive

 

[Jialiang Ge [MSFT]]

Hello Cypher Drive,

Thanks for the information and I understand the need now. However, this is
indeed one of the weaknesses of typed datasets, or the VS designer, that
it's not easy to refresh the dataset after the DB schema is changed.
Configuring the dataset with the wizard or re-creating the dataset in the
VS designer are the solutions that I can imagine, but they cannot be
quickly done with a single click. However, there are some open-source
solutions supporting schema-sync. For example:

SubSonic - It has the built-in command to refresh the DAL according to the
new DB schema.
http://www.codeplex.com/subsonic

Regards,
Jialiang Ge ([email protected], remove 'online.')
Microsoft Online Community Support

=================================================
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

This posting is provided "AS IS" with no warranties, and confers no rights.
=================================================

 

[Cypher Drive]

Dear Ge,

Thanks for the information

Regards,

CypDrv