Search data from DataTable object in C#

Lalit Raghav

How search data from DataTable object in C# .suppose we have a DataTable in C# And that DataTable has data .Its Data Column is id ,CustomerName,Age etc.DataTable has id from 1 to 50 with customerName and age then how we search data of id 20 to 25 ???

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pranay Rana11y ago
Check the answer with linq posted by me where you can use Contains method and search data you want...
Pranay Rana11y ago
You can use linq to dataset like this

DataTable Customer= ds.Tables["Customer"];

List ids =new List () {20,21,22,23,24,25};

IEnumerable query =
from cust in Customer.AsEnumerable()
where ids.Contains( Convert.ToInt32(cust.Field("id")))
select cust;
Nanhe Siddique11y ago
use this code to search inside datatable.

var dt1 = new DataTable("Table 1");
dt1.Columns.Add("title", typeof(string));
dt1.Columns.Add("number", typeof(int));
dt1.Columns.Add("subnum1", typeof(int));
dt1.Columns.Add("subnum2", typeof(int));
dt1.Rows.Add(new object[] { "a", 1111, 1, 1 });
dt1.Rows.Add(new object[] { "b", 2222, 1, 1 });
dt1.Rows.Add(new object[] { "b", 2222, 2, 2 });
dt1.Rows.Add(new object[] { "d", 3333, 1, 1 });
dt1.Rows.Add(new object[] { "d", 3333, 1, 2 });
dt1.Rows.Add(new object[] { "d", 3333, 2, 1 });

foreach (DataRow row in dt1.Rows)
{
if (row["subnum1"].ToString() =="1")
{
Console.WriteLine(row["subnum1"]);
Console.WriteLine(row["title"]);
}
}

if this helpful marks answer
Khargesh Rajput11y ago
suppose datatable objectname is dt

then dt.Select("id in(20,25)");

also you can use
Dataview to filter record