Hi Sairam,

If you want to do this programatically you can use SQLDMO to read SQL Server
table properties
including column names and types, unique/primary/foreign key contraints,
etc.

Then use the .NET XmlSchema class to generate a schema matching the manually
generated typed dataset in VS.

Once you have this dataset schema you can load it into an new empty DataSet
object instance or use the xsd to generate a code class using xsd.exe.

The nice part is that you can do a better job than VS and include all keys
automatically as well as naming them according to their name in SQL Server
unlike the auto-generated names VS creates.

Hopefully this will get you started. Good luck.

Regards,
John

Show quoteHide quote

Deserialize from SelectSingleNode
Error using XMLTextReader to read XMLDocument
XML file vs Windows Registry
XmlSerializer
Date Formate when using ds.WriteXml