Hi Navaneeth,
If you want to get sql data in xml format then refer below link this might be helpful to you to convert your table data in xml format.
http://www.aspdotnet-suresh.com/2014/10/sql-server-convert-table-data-to-xml-format-using-xml-auto-xml-path-xml-raw.html
and after convert into xml you want to show the xml data in gridview, for that the below link will helpful to you,.
http://stackoverflow.com/questions/20245229/gridview-displaying-xml-file-data
--------------------------------------------------------------------------------
Give respect to your work, Instead of trying to impress your boss.
N@veen
Blog : http://naveens-dotnet.blogspot.in/