I am developing an import program dat imports data into the database. When I want to get a brand new set of data, i run the following script
which deletes about everything :)

delete from nop_picture
delete from nop_category
delete from nop_manufacturer
delete from nop_product
delete from nop_productvariant
delete from nop_productvariantattributevalue

Unfortunately, when I run the website, it still shows the old products. I know of a workaround, by changing the connectionstring, and making the login fail, and then change it back to the way it was

Surely there must be an easyer way to achieve this....

By the way: adding a space to the connectionstrings.config and saving it also does the job

Did you try recycling the application pool?  If you're on a hosted provider that doesnt allow you to do this directly, you can make a change to web.config like adding a space which should force a recycle.  That may be what is happening when you add a space to the connectionsstrings.config file but I thought it was only web.config that had that behaviour.

Go to admin area and click "clear cache" button

I added a space to connectionstrings.config and it worked...
Thanks for the answers guys

a.m. wrote:

hii

i am using sqldatasource where some records are updating database but i cannot see those records untill i click clear cache

so is there any another way ???

or i have to write the code which is on the clear cache link click after updating records??