Row Filter

[anushh]

How to filter top 4 records from a dataset using rowfilter property in codebehind page

[Manas Bhardwaj]

anushh wrote:

How to filter top 4 records from a dataset using rowfilter property in codebehind page

No, the RowFilter property was not designed to do that. It is more analogous to the WHERE clause of an SQL statement. Why dont you do it at the SQL Server itself? Anyways, you may also try to use this approach:

private DataView GetTopDataViewRows(DataView dv, Int32 n)
{
DataTable dt = dv.Table.Clone();

for (int i = 0; i < n-1; i++)
{
	if (i>= dv.Count)
	{
		break;
	}
	dt.ImportRow(dv\[i\].Row); 
}
return new DataView(dt, dv.RowFilter, dv.Sort, dv.RowStateFilter); 

}

Manas Bhardwaj Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

[Abhishek Sur]

hey manas... How about datataable.AsEnumerable().Take(n) //where n is the no of rows from datatable. ;)

Abhishek Sur

---

My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB

**Don't forget to click "Good Answer" if you like to.

[Manas Bhardwaj]

Abhishek Sur wrote:

datataable.AsEnumerable().Take(n)

This is so nice. :thumbsup: I am still living with VS 2005. I must plan to move on to the VS 2010 soon :)

Manas Bhardwaj Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

[Abhishek Sur]

I guess so mate. Few days back... I was in 2005 like you. But after using LINQ.. I always suggest to shift from 2005, and work in 2008. 2010 is far apart. Even I didnt have a chance to work on it.. :-D :-D Cheers. :rose:

Abhishek Sur

---

My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB

**Don't forget to click "Good Answer" if you like to.

[Manas Bhardwaj]

Abhishek Sur wrote:

2010 is far apart

Not that far. Already started the download[^] ;)

Manas Bhardwaj Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

[Abhishek Sur]

Yes Thank you for the link... Already tried the Parallel Extensions in .NET 3.5 .. Excited to see .NET 4.0 with truely multicore support in it. I have already downloaded the 2010 Beta.. Just have to start doing some tests in this 1. Hope you are also enjoying this big release too. ;) :thumbsup:

Abhishek Sur

---

My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB

**Don't forget to click "Good Answer" if you like to.