Comments by Surendra Patil (Top 17 by date)

I am using boundcolumns for all the columns. And i tried to use both but the thing is, the formatting like date formatting and bounding of two values from the database in the same column, and use of webusercontrol can be done with boundcolumn not dynamically. As I am doing enhancement on the client code, so very limited options are available :(

Ok..I agree with you on this. But the thing is, I am using boundcolumn instead of auto generating the column. So boundcolumn will always show the data in specific order not according to user.

Hey Saroj, I can't use this. Because I am using datagrid not datagridview.

I have a view which populates the data. I have provided the modalpopup with datagrid where user will select his context.

I can's set autogeneratecolumns to true bcaz there are some tools like print option, view option which are bounded to the one column. Which will be fixed always. And for the printer option they have used image of the print. So I don't think i can bound those images at code behind.

What i was thinking initially, bound the all the columns to the datagrid and then hide/unhide or change the order by some property of datagrid. Means there are some properties like 'DisplayIndex' in datagridview where we can select the index of the column.

Hi BulletVictim,
Here is the scenario,

I am populating the data from the database. I want have the functionality where user is capable of selecting the columns which user want to see and change the order according to his context/preference. I am able to hide /unhide the column according to the user selection. But I am not able to change the order.

Example:

Let's say, I have Column1,Column2, Column3, Column4, Column5 from the database and I have some icons like 'View', 'Print' in one column which will be fixed at left most side. Now user want to see Column1 Column2 Column3 with tools in the order Column3 Column1 Column2. I can't set the autogeneratecolumns to true. So what should be done on this?

Thanks for your suggestion. Can you explain with some example.

Expression= Expression.or(Student.Aggregate(false, (curr, next)=> curr.or(line=>line.std==next.Std && line.student==next.Student));

Here next is list of students.

This is the code they have used.

HI Matt,

Actually they are building expression tree and later the point they are compiling it.

The tree forming is done with the help of aggregate function. In which each time it's checking for Std && Student combination multiple times (ex. (Std==8 && Student==1) || (Std==8 && Student==2)). But I want to check it only once for Std and once std matches, i want to check for student in it. like(ex. Std==8 && Student IN(1,2)). Here it's checking for std only once and then student in it.

Something like,

Select Name, Age from Studend Where (Std=8 and StudentID In(student1, student2, student3))
OR (Std=9 and StudentID IN (student1, student2, student3))

this won't help. Bcaz, this will only check for 1 student. I wan to check for 3 students with matching std.

I want to build lambda expression tree. Currently the query code is building is very time consuming. Each time it's checking for Std and Student. Actually it should check only once for std and then the student from that std.

Like, currently it is always checking like below:

Std==8th && student==student1
st==8th && student==student 2

I want the logic like,
std==8th && student In(student1, student2).

Means instead of checking std all the time, just check it once then look for student from that std. Same for other std.

Something like,

Select Name, Age from Studend Where (Std=8 and StudentID In(student1, student2, student3))
OR (Std=9 and StudentID IN (student1, student2, student3))