SQL Server requests time out as TempGetStateItemExclusive is getting called continuously
I run a site with decent traffic (~100,000 page views per day) and sporadically the site has been brought to its knees due to SQL Server timeout errors.
sql-server
How do I retrieve the result of an ADO.NET SqlCommand?
Ok either I’m really tired or really thick at the moment, but I can’t seem to find the answer for this
Cache results from sql database, or query each time?
I’m generating pages based on an sql query.
Display image from a datatable in asp:image in code-behind
I have a datatable which is filled from the resultset of a 1 row select statement (via a stored procedure in SQL Server 2008) and it contains a Image typed column which I store images in.
SQL Server Express connection to .mdf file
Two-Part Question.
How to insert value into primary key identity column in SQL through C#?
(My problem solved. As almost everyone said I had to remove @OB_ID and left it to SQL to assign value.)
ASP.NET tableadapter insert not returning the correct identity value
In my Visual Studio 2008 ASP.NET web page codebehind, I am calling an add routine in an SQL tableadapter, as follows.
Best Practices for Building a Search App?
Is there a way to search all properties (without pulling all objects into memory – which I assume means building a list of each object’s properties with reflection, stringifying them, and then checking is out)? If not, this seems incredibly cumbersome as I’d have to build new logic for every new property I might add. Something like s.Contains(textFilter) in the above would be ideal.
Using iTextSharp to print a PDF with multiple tables
I have a detailed bill to print that pulls up billing details from various departments. I need them to be printed on a PDF. But I use plenty of select procedures as I have to display a lot of tables so I need code that I can reuse.