Solved

Query Datatable

Posted on 2004-10-04
4
1,013 Views
Last Modified: 2008-01-09
I am loading an xml file into a datatable to display some records.
I am wondering if there is a way to query the datatable using some sort of SQL syntax.

Thanks.
0
Comment
Question by:Smlemieux2k
4 Comments
 
LVL 4

Accepted Solution

by:
gdexter earned 30 total points
ID: 12217623

You can use the Select method of the Datatable object.
It will return an array of DataRow objects.

Dim dr() as DataRow = DataTable.Select("ID=<somevalue>")
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question