XML - SQL

Question

Hi How to create xml/xsd file in vs and fill it from sql database?I need create xml /xsd file not programmatically.From designer I need. Thanks in advance

Mahesh Chand · Answer

Here is one way to do it. http://www.c-sharpcorner.com/uploadfile/4d56e1/how-to-create-a-strongly-typed-dataset/ A lso here is a complete example of how to create typed DataSet and use it http://support.microsoft.com/kb/320714

Mahesh Chand · Answer

Visual Studio creates XSD from a database. You need to Add a new Item Select Item as DataSet and it follow the steps. It will ask you details about your database table columns etc.