I'll check them, thanks raja.

It happens for every action. So it is a general problem, not related with any specific query or code. Same code performs much faster in development environment. So - what I'm looking for is any tool(s) that can help investigate the issue. Thanks.

Hello Shameel, It's ASP .NET (.NET Framework 4.0) and Entity Framework V5 in combination with WCF web services. SQL Server 2008 R2 back end. Hope that helps. Thanks.

I've this production site that's performing very slow for every action. We've checked database side and database is tuned and queries, when they reach the SQL Server - performs fine. There's little bit of time difference when it runs in query analyzer and when it comes from the web - say 2 seconds. But that doesn't explain why it takes 30 seconds just to login. So we are trying to troubleshoot it. Is Fiddler or any other tool might be helpful here? Thanks.

Ah, sorry - I thought bugs and performance is a general topic..

I've this production site that's performing very slow for every action. We've checked database side and database is tuned and queries, when they reach the SQL Server - performs fine. There's little bit of time difference when it runs in query analyzer and when it comes from the web - say 2 seconds. But that doesn't explain why it takes 30 seconds just to login. So we are trying to troubleshoot it. Is Fiddler or any other tool might be helpful here? Thanks.

I've this production site that's performing very slow for every action. We've checked database side and database is tuned and queries, when they reach the SQL Server - performs fine. There's little bit of time difference when it runs in query analyzer and when it comes from the web - say 2 seconds. But that doesn't explain why it takes 30 seconds just to login. So we are trying to troubleshoot it. Is Fiddler or any other tool might be helpful here? Thanks.

Hi Gray, Yes I tried outputting all of them, and some are not being passed to the asp.net. Thats why I can't retrieve them. When I did that - I used the same case wording. I could try the Session sharing technique you pointed to, but it looks like overkill. I'll go back and dig further - and let you know. Thanks.

I have an application built using classic asp. I built a page using asp .net (C#) and need to retrieve parameter values passed from the asp page. Some of them are working - when I use code like MyControl = Request.Form["cmbDepartmentID"]; But for unknown reason - the others are not working. So, I tried to create a Session object in the asp page, and retrieve it in the asp.net. In the asp for example - Session("Param") = value And in the asp.net - MyParam = Session["Param"].ToStrng(); But it doesn't recognize the session object. What is the way to do it? The asp page is a huge mumbo-jumbo of vbscript, javascript, html etc. that I don't follow the flow clearly. But I know querystring is not an option here. Thanks.

Hey...guys, where is my help? Thanks.

Hi, Here's the situation: We've some Crystal XI reports that are being called from an ASP page. Here's the code: [CODE] <OBJECT ID="CRViewer" <% If AEMSFEATURE_CRYSTALREPORTSVERSION = 11 Then Response.Write "CLASSID='CLSID:460324E8-CFB4-4357-85EF-CE3EBFE23A62' " _ & "CODEBASE='../../cgi-bin/crystalreportviewers11/ActiveXControls/ActiveXViewer.cab#Version=11,0,0,893' VIEWASTEXT " End If %> WIDTH="100%" HEIGHT="99%"> <PARAM NAME="EnableRefreshButton" VALUE=0> <% If Request.QueryString("print") Then %> <PARAM NAME="EnableToolbar" VALUE=0> <% End If 'print %> </OBJECT> [/CODE] It was a working solution - until we installed it on Windows 7 when the Viewer came up with grey screen, but allowed saving the report as pdf etc. correctly. Anyways, we decided to switch to Crystal 2008 (12), but don't know the ClassID. Anybody knows how to fix the problem with Crystal 11 on Windows 7 (Viewer greyed out) or knows the ClassID for Crystal 12 ActiveXViewer? Thanks, Ekjon

Basically, my concern is - to create a database with 30/40 tables with some data in some of them - the sql statements would be large. What would be the best approach to deal with it?

I need to deploy a .NET 2.0 windows application so if no SQL Server found on the network, it will allow them to install SQL Express. If there is SQL Server, then it will allow them to create a database with some baseline data. Really need help on this, Thanks, Ekjon

Thanks d@nish and Dambod - it was very helpful.

Hi, In my application - I need to search for installed SQL Server instances on the wotkstation or network; so I can create the appropriate connection string and also for allowing the user to install sql server express if no sql server is installed. Is there any way? Thanks, Ekjon

Thanks Dave, I got it fixed.

I have this VB .NET app with a generic save method. When a menu item, or a toolbar button or a next button is clicked - if there are any changes it should save with a message. In the code - to identify which was clicked I tried If sender Is ToolBar1.Buttons("ToolBarSave") OrElse sender Is TabMain.Controls("btnAdminDataNext") Then MessageBox.Show("successfully saved!" End If Any idea, why and how to make it work? Thanks.

I got it done, thanks if you read it.

I have this application from several years ago that I am modifying. I created a new form where I have an Xceed grid tied to a DataSet-DataAdapter. When the Add button (or a blank area on the grid) is clicked, it creates a new row. The user types information there and clicks "Save". Or the user edits an existing row and clicks "Save". The data adapter calls the Update() method that invokes the corresponding SQL Insert/Update/Delete commands. It works fine. But I have a link table where I want to Insert when a new row is saved in the previous table mentioned above. How do I know a new row has been created and "Save" button is clicked or an existing row is edited and the "Save" button is clicked? I need some help please. Thanks.

Thanks to both of you.