Jump to content

Large Amount of Data Retrieving using XElement in C# Windows Application

Recommended Posts

Hello Everyone,

'm developing software Customer Management System in C# windows application based on XML Database. In my database near by 1,00,000 entries. i have a trouble in retrieving 1,00,000 entries. its take more time to show the data. let me know the fast retrieving solutions as soon as possible.

Its My Coding (Retrieving)

XElement xelement1 = XElement.Load(ZXmlDetails.Path + @"Noti_Payment.hash");                var detailss1 = (from nm in xelement1.Elements("Details")                                 orderby (String)nm.Element("IBillNo")                                 select nm);                if (detailss1.Count() > 0)                {                    foreach (var xEle1 in detailss1.Distinct())                    {                        int x = PaymentLoop.Rows.Add();                        PaymentLoop.Rows[x].Cells[0].Value = xEle1.Element("IBillNo").Value.ToString();                        PaymentLoop.Rows[x].Cells[1].Value = xEle1.Element("CName").Value.ToString() + " -- " + xEle1.Element("CPhoneNo").Value.ToString();                        PaymentLoop.Rows[x].Cells[2].Value = xEle1.Element("NetTotal").Value.ToString();                        PaymentLoop.Rows[x].Cells[3].Value = Convert.ToDouble(xEle1.Element("NetTotal").Value.ToString()) - Convert.ToDouble(xEle1.Element("Payment").Value.ToString());                    }                }

Thanks & Regards

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...