Tuesday, May 14, 2013

ASP.Net display XML in Grid


        protected void ButtonExtractNow_Click(object sender, EventArgs e)
        {
            try
            {
                using (LoanIqAdapter _adapter = new LoanIqAdapter())
                {

                    string results = _adapter.SendInquiry("ost_tranById('" + DropDownList1.SelectedValue + "')", false);
                    XDocument xDoc = XDocument.Parse(results);
                    IOrganizationService xrmService = GetXrmService("JamesDev");
                    foreach (XElement childElement in xDoc.XPathSelectElements("//osttran/Record"))
                    {
                        //SendToXRM(xrmService, childElement);
                       
                    }

                    StringReader sr = new StringReader(results);
                    DataSet ds = new DataSet();
                    ds.ReadXml(sr);
                    ds.Merge(ds, true);

                    GridView1.DataSource = ds.Tables[0];
                    GridView1.DataBind();

                }
            }
            catch (Exception ex)
            {
                //throw;
            }


No comments:

Post a Comment