Tagged Questions

2
votes
3answers
2k views

How to improve performance in this database connection class?

This is my general database connection class. I am using this class to execute my queries through website. What would your suggestions about this to improve performance. Thank you. MSSQL 2008 R2 SP1 ...
2
votes
3answers
1k views

Search using stored procedure

I want to search a DB table and display the records in a gridview below is my stored proc create procedure search @Firstname varchar (50), @Lastname varchar (50), @Gender ...
1
vote
2answers
98 views

Is My Data Access Leaking Connections?

Folks I have an N-Tiered ASP.Net Web Forms application which uses Enterprise Library 5.0 for data persistence. Recently I have noticed my application has been spitting out the following error ...
1
vote
1answer
382 views

Custom Paging in ASP.Net Web Application

I have following code for doing custom paging from an asp.net web application. Points of interest It uses Link Buttons as suggested in ...
0
votes
2answers
192 views

Critique my Database design/help me simplify my C# code please

I wish to create a database for a webpage where users are able to add their own events to a timetable. Users will be able to decide if the events should be recurring (weekly) or not. Users should be ...
0
votes
2answers
318 views

Listing SQL tables in HTML Table using asp.net [closed]

Does anyone have any techniques for listing SQL rows in an HTML table using ASP.NET and Javascript in conjunction? Actual code would be really nice...
0
votes
3answers
215 views

Using a Dedicated Class & Constructor to initialize Stored Procedure for SQL Transaction

as i thought it will be sutible as a Quetion for SO... i started to describe the issue of my Problem, though as i completed Editing the post , i could see that it will better fit here, In CR. so to ...
-2
votes
1answer
31 views

advanced asp.net improve performance [closed]

asked for help on my application , that's run on windows server 2003 and iis 6.0 ,this applications gross now , users now about 60,000 per day. and that what i did to make it faster a.SQL server 2005 ...