I've run across other forums that are not so dominated by "rules tyrants" like here. I'd suggest asking in those forums. I've gotten polite responses from folks at www.dbforums.com Sorry I can't help you myself. I don't know anything about the subject. David --------- Empirical studies indicate that 20% of the people drink 80% of the beer. With C++ developers, the rule is that 80% of the developers understand at most 20% of the language. It is not the same 20% for different people, so don't count on them to understand each other's code. http://yosefk.com/c++fqa/picture.html#fqa-6.6 ---------

let me give u some detail, you might have an idea that some companies develop the page, an activeX, and made a CD along with a .dat and .idx file. Now the end users install the application on their machines, use that page to validate some data e.g. some company name against the CD, the page uses the activeX control to validate information entered by the user against the idx file on the CD and show results, if any, on the page. All this is done through the activeX control which reads from the idx file on the CD. I want to know how to validate/read the information from the IDX file? hope you understand my question now. -----

well I have posted it SQL/ADO section, but as per my understanding it falls in .net section because I want show the data on the web page using either vb or c#. Anyhow, thanks for your tip -----

Thanks Sean. But this is not the problem, please see this for complete details. -----

What kind of firewall is that? What is the purpose of blocking traffic like that? The firewall can't be access directly with an unauthorised request, can it? Is the protection (?) something that the "firewall guys" have come up with themselves? --- "Anything that is in the world when you're born is normal and ordinary and is just a natural part of the way the world works. Anything that's invented between when you're fifteen and thirty-five is new and exciting and revolutionary and you can probably get a career in it. Anything invented after you're thirty-five is against the natural order of things." -- Douglas Adams

See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1590647&SiteID=1[^]. "Throughout human history, we have been dependent on machines to survive. Fate, it seems, is not without a sense of irony. " - Morpheus "Real men use mspaint for writing code and notepad for designing graphics." - Anna-Jayne Metcalfe

Thank you Paul. The problem fixed after updating the ODBC driver on the machine, it had old ODBC driver. Anyway I appreciate your response. -----

I think your first guess might be true. Your second is wrong because it is not updating all panels, it only updates the panel which I call panel.update or which have triggers. So updating is working fine only flickering of page is a problem that happens randomly. Most of the time it is working just as expected. Thanx for your response. WELL: I just tested in firefox and it is working just fine in firefox. So I quess it is IE stupid stuff.. -----

well :-D i thought if I catch thi then I can validate the data and replace the textbox with dropdownlist... but it won't help because in itemcreated... you cannot get values of datagrid items.. these are only accessible after itembound... so I may have to go for someother approach.. to retain the dropdownlist after next postback.. ;P -----

Ok, question: you repeat the same result for every textbox / dropdown after the search? If that's the case, you can keep your search text in a session variable or some other mean, and make that search and textbox / dropdown filling in the ItemCreated event. Does this help you? Are you using the ItemCreated event?

Thanks.. but it works now.. Instead of opening the C# project/file from the client (href) I used server.transfer from a VB project/file and I can access all session variables in C# file...:-D -----

well I did start the aspstate and even have set it to start utomatically.. here is what I did in both projects (VB and C#) but when I open a c# page from vb (main project), it gives null value for the session variables.. -----

thanx Minhcpc_bk, that's really so nice of microsoft..:-D -----

Oh nice catch SABhatti, that explained why my sample code (in C#) didn't have any problem while running ;P , but surely I still want to dig into this clue when I have a time.

Well I really wonder How it works on your system? did you uncheck the option for the file type which you downloading?:-D because there are lot of file types and one has to set the confirm option for each type individually. Anyhow thanks for your help, I have used the \r\n at end of file, but it did not work for contenttype application/vnd.ms-excel, but if I change the content type to unknown like xxx/xxx or application/x-msdownload then it works with \r\n at the end of file:laugh:, but in this case I faced another problem, -- IE show the file type as unknown -- does not open optin (just give save and cancel option which is good) -- in save dialog set the aspx file name as default name without ext (i want it to set the origianl excel filename as default) -- on clicking ok, save the file as unknow file type -- but on double clicking the saved file, file opens in excel ;P:confused: I am working on it to set the default name and type, lets c if i get any success. further help is highly appreciated:-D -----

I would assume that the opening behavior is a browser setting. Try looking at the file association settings on your work computer. There is no way to force a client machine to save the file because of security concerns. You can only do what you are doing and let the user decide what to do with your file. You can have some text on the previous page describing what they should do. Dirk Watkins

This can be caused by one of two issues; 1 - Your maximum connections have been passed programatically, this is not very common. 2 - The more normal reason is that your close connection + dispose is not being called, this leads to the same sort of error. IMO the best way to handle this is to keep the scope local and ensure correct handling of errors etc guaraantees that your connection is always closed and disposed of when it is no longer needed and then the connections goes out of scope as your function or sub is released to the garbage collector.