Friday, May 28, 2010

How to bind CRM Data to GridView on custom ASP.Net page for Microsoft Dynamics CRM

I have seen this article one of my colleague Hassan Hussain. I've decided to use other approach to bind data to GridView on custom ASP.Net page - instead BusinessEntitiesCollection I used Fetch.

string fetch = @"   <fetch mapping=""logical"">
<entity name=""account"">
<attribute name=""accountid""/>
<attribute name=""name""/>
<attribute name=""address1_line1""/>
<attribute name=""address1_line2""/>
<attribute name=""address1_country""/>
<attribute name=""address1_city""/>

string result = service.Fetch(fetch);

XmlDocument doc = new XmlDocument();

StringReader sr = new StringReader(doc.OuterXml);
DataSet ds = new DataSet();

GridView1.DataSource = ds;

And the result: