Comments by mhd.rad - CodeProject

mhd.rad 1-Feb-12 0:27am View

Thanks,I know that. But this is a windows application. I trying too lazy loading with create static Datatable and di .Read() for 10 time. When scroll of GridView come down, I do .Read() for 10 time more and add 10 row to GridView. I get a nice experience :D

mhd.rad 31-Jan-12 9:08am View

Thanks, but I cant. because i use "SQL CE 3.0" and it doesn't support LinqToSql, and "Windows CE 6.0" don't support this namespace too.

mhd.rad 31-Jan-12 9:05am View

thanks. this is a nice idea. I work on it

mhd.rad 2-Jan-12 14:17pm View

:). Yah, its really angry me.
I tried Top at first but, The SQL CE 3.0 does not support "Top" function :(
I use this code:

define @a = 20 --@a is a variable ;)
if(SELECT COUNT(*) FROM table WHERE id BETWEEN 10 AND a<10)
{
-- @a++
}

But there is a problem. How to make a loop in SQL?

mhd.rad 2-Jan-12 9:04am View

Thanks for your answer, but it just count all of my database. I want to get records between two ID. Look at this:

SELECT * FROM table where id between 10 and 20.

I want to select 10 Query from bank and this select query works well. But if I was removed some record from bank it maybe show me 9 records or less.
Exactly I want to use RowCount for Lazy Loading. Thanks

mhd.rad 31-Dec-11 15:10pm View

Realy Thanks.
Ok, I should show this page to my project manager.
But for second answer(for using SQLCE3.0 with visual studio2008): Yes it's as easy as your answer, But when i do this steps, at the last step ask me to update to "SQL Server 3.5". I dont want to do this and use the "SQL Server 3.0"

Comments by mhd.rad (Top 6 by date)