I have an asp.net page that loads a query which we know to run fine (within 1 to 2 seconds) when executed from SQL Server Management Studio, however when executed from ASP.NET in a SQLCommand the query takes substantially longer, I cannot seem to figure out what is happening other than one line has been added to the query since the problem started, however I cannot locate what the issue is.
I was wondering if there is easy solution to this or I’m stuck with following:
I need to know how to configure the .config to manage Session state in SQL Server
Moving a web project from test enviroment to the web server made this error occur whenever tehre’s an attempt to open a connection to the sql server.
I’ve created a Web Form using C# within Visual Web Dev 2010 Express and it contains text boxes / labels (based on check boxes) but when I run the code to fails on running the SQL command. I have gotten the code to work before using only 3 text boxes but doesn’t seem to work when I expand the code.
Suppose i have a one parameter stored procedure :
I’m running a DbDataReader on a query to remove items from a dropdownlist if they are already attached to a specific submission, and I keep getting an error telling me the reader is closed. Can’t see why my reader is being seen as closed here. What am I missing?
Make a select as json query:
I have a dynamically generated ListView which displays a set of groups, retrieved from a database. The ListView template looks like this: