Problem with SQLCacheDependency

I am using a grid to display the data on my webpage, and I have 3 projects in my solution (UI, BLL, DAL). When I load the webpage I am creating the instance of a class written n my BLL project to populate the data, and in BLL I'm creating the object for the class in DAL and returning the datatable.

Now when I refresh the page using F5, the SQLDependency is working fine. But, when I use the Paging or Sorting option's on my grid I see in SQL Profiler that the query is posted back to the SQLServer to get the data.

If this is the senario then how can I make use of the cache object in .NET 2.0.

Please advice,
Ravi

I've posted a blog article that tries to explain some of the misteries behind Query Notifications here: http://blogs.msdn.com/remusrusanu/archive/2006/06/17/635608.aspx, maybe it can help you troubleshoot the issue.

I'm relly no expert in the SqlDependnecy functionality, but the explanation you give seems way too short to understand what the problem is.

HTH,
~ Remus

sql

problem with reordering of rows

I am using MSSQL 2000, I need to display a cv page in which a person projects are displayed the way he enters them into the database and he should be able to reorder the projects according to the proirity. I have no clue how to do this ? I am a newbie in asp.net,C# field.

I searched info on google and forums but didn't find anything related to my understanding. I'am displaying all his projects using a Projects table in which i have four columns ProjectID, ProjTitle, ProjDirector, ProjDescription. i want the user to be able to reorder the
projects row by moving a task up or down based on priority.Any help will be greatly appreciated .. I am really stuck and frustated with this task ..please help me friends..

Thank you very much

can you please help me friends in the above problem...

Thank you

|||

Can two projects have the same Title? I would immagine that would be confusing -- if Title is supposed to be unique, then make it the PK. Also, your column names contain the prefix "Proj" -- unecessary.

To answer your question, though, simply add a column called Display_Sequence. Then your insert statement would be

INSERT INTO Projects
(Title, Director, Description, Display_Seq)
SELECT 'My Project', 'Jim Jones', 'This is my project', MAX(Display_Seq)
FROM Projects