query dataset using LINQ

Question

Possible Duplicate:
Not displaying data in gridview when applying filter to a dataset

I am having a Dataset ds with contents of table emp with ename , pass , status as attributes .

I want to query the Dataset uing LINQ such that it returns records whose status is "out"

it worked when used on datatable when i use dataset data is not displayed

Please tell me how can i achieve this.Thanks in Advance

score 2 · Answer 1 · edited May 23 '17 at 12:12

2

Simple use this and convert result to list:
First add a reference to System.Data.Extensions.dll (where LINQ over DataSet support is implemented)

// Fill the DataSet.
DataSet ds = new DataSet();
ds.Locale = CultureInfo.InvariantCulture;
FillDataSet(ds);

DataTable orders = ds.Tables["SalesOrderHeader"];

var query =
    from order in orders.AsEnumerable()
    where order.Field<string>("status") == "out"
    select order;

yourGridView.DataSource= query.ToList();
yourGridView.DataBind();

You can check this also:
Binding LINQ query to DataGridView

edited May 23 '17 at 12:12

Community

1
1

answered Jan 18 '12 at 05:30

Niranjan Singh

18,017
2
42
75

data not displayed while using the above query – Vinod Jan 18 '12 at 05:53
can you share your code to understand the problem.. this should work if you doing everything in correct way.. – Niranjan Singh Jan 18 '12 at 06:10
check your gridview markup for problem. if your code behind is written correct at particule event of asp.net page life cycle.. – Niranjan Singh Jan 18 '12 at 06:46
Hi Niranjan i want to use dataset only.please see the code i had added and suggest me how can i use attributes directly like r.status or r.empname .Thank you – Vinod Jan 19 '12 at 04:46
try to add `.ToList()` to `datasouce`.. and before this check result IEnumerableList contain values or not?? – Niranjan Singh Jan 19 '12 at 06:24

score 0 · Answer 2 · answered Jan 18 '12 at 04:57

0

   var query = from e in DS1.emp

            where e.status == "out"


            select e;



dataGridView1.DataSource = query.AsDataView();

answered Jan 18 '12 at 04:57

Neha

2,933
3
19
23

It will give compilation error "DS1.emp", you can not use Dataset as Datacontext. Instead AsEnumerable() Method will work here. – Pankaj Tiwari Jan 18 '12 at 05:57

score 0 · Answer 3 · answered Jan 19 '12 at 04:26

OleDbDataAdapter da = new OleDbDataAdapter("select empname,pass,status from employees", conn);
        DataSet ds1=new DataSet();
        da.Fill(ds1,"emp");
            var datasource = from r in ds1.Tables["emp"].AsEnumerable()
                             where r.Field<string>("status")=="out"
                             select new{empname=r.Field<String>("empname"),status=r.Field<string>("status")};
            GridView1.DataSource = datasource;
            GridView1.DataBind();

query dataset using LINQ

3 Answers3