Hi sumit,

I suppose the problem with your code is You are not checking any condition before executing the insert script.You can do two things Here.If you are using a different page for updating database then don't stay on the same page after updating the database and redirect the page to previouse page from where user has come and show him the latest record.
Otherwise check for request.ServerV ariables("HTTP_ REFERER")...

Hi,
Thanks For ur reply.I am using ie6 and ie7.0.
I tried using css to fix the position of header and footer.It works for me if the total pages to print is equal to one.Other wise footer overlaps with data.
Has anyone anymore solutions....

Hi,
You can do it using AJAX.It is very fast and effiecient .In place of drop down take a text box and onkeypress event call the server page through ajax script which will filter out records from the recordset based on the string present in textbox.It works like google suggestion box in google search.
Thanks,
Santosh

Hi All,
I want to make a printer friendly version of a asp page.The Data is comming from a sql table.I can not pridict what will be length of the whole document.But client wants to put customised header and footer on every pages.can it be possible?
Is there any way if i export it to .doc or excel file?

Thanks in advance