Re: SQL time out exception because of datareader - ASP.NET Discussion Boards

SQL time out exception because of datareader

pavan.kumar,sai25-Mar-09 2:14

25-Mar-09 2:14

Hi All

I am facing SQL Server Timeout exception.

try
{

SetStoredProcCommand(SPRetrieveIntSchedReport, DatabaseConfigKey);

AddInParameter("@FromDate", DbType.DateTime, schedule.FromDate);

AddInParameter("@ToDate", DbType.DateTime, schedule.ToDate);

AddInParameter("@ApplnType", DbType.String, schedule.ApplnType);

IDataReader dataReader = ExecuteReader();

while (dataReader.Read())
{ .....}
}
When the control reaches the data reader its taking much time to enter the WHILE loop, and some times its getting in and its done fine,but sme times facing this SQL SERVER TIMEOUT EXCEPTION.

please help.

Thanks in advance.

Reagrds
Pavan

Re: SQL time out exception because of datareader

Ashfield25-Mar-09 2:26

Ashfield

25-Mar-09 2:26

You can increase the timeout on your connection/command, or better still optimise your proc as you may be doing a table scan or something similar - no way to tell from your code.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: SQL time out exception because of datareader

pavan.kumar,sai25-Mar-09 2:34

pavan.kumar,sai

25-Mar-09 2:34

Hi

i have increased the timeout duration, and optimized the query as simple as i can.
Any settings to be changed in the IIS ?

Thanks
pavan

Re: SQL time out exception because of datareader

www.Developerof.NET25-Mar-09 3:01

www.Developerof.NET

25-Mar-09 3:01

pavan.kumar,sai wrote:
i have increased the timeout duration,

Set it to 0 to run the query indefinately .ie until you get the result.

When you fail to plan, you are planning to fail.

Re: SQL time out exception because of datareader

pavan.kumar,sai25-Mar-09 3:11

pavan.kumar,sai

25-Mar-09 3:11

where to do that and how to do that ??

Re: SQL time out exception because of datareader

www.Developerof.NET25-Mar-09 4:19

www.Developerof.NET

25-Mar-09 4:19

use the sqlcommand CommandTimeOut property....

ie

your_cmd_obj.CommandTimeOut=0

When you fail to plan, you are planning to fail.

Re: SQL time out exception because of datareader

pavan.kumar,sai25-Mar-09 15:37

pavan.kumar,sai

25-Mar-09 15:37

I am using a datareader ...and not using it through commands, so we cant set it ...

Re: SQL time out exception because of datareader

Ashfield25-Mar-09 9:17

Ashfield

25-Mar-09 9:17

In which case I suggest you consider some of the followng:

- do you need to return all the data at once?
- could the underlying data be denormailised into reporting tables?
- could some of the data be cached?
- could the indexing be improved?

I am fairly certain that if the query times out, and you are displaying the data on a web page it will be pointless, as nobody wants to wait ages for a page to load.

Hopefully this may guide you to a solution

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: SQL time out exception because of datareader

pavan.kumar,sai25-Mar-09 15:39

pavan.kumar,sai

25-Mar-09 15:39

Hi
it is something like report grnearion,based on the user input a report is generated.
yes i am trying to display in the format of tables only.

But sometimes i can get it perfectly, and sometimes it throws the timeout exception ?

any case related to IIS ?

Thanks
Pavan

Re: SQL time out exception because of datareader

Ashfield25-Mar-09 21:56

Ashfield

25-Mar-09 21:56

What about load on the sql server? Any locking causing problems, that sort of thing? Without actually being there its difficult to pinpoint where the problem is.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Hi experts,

antony beula25-Mar-09 0:33

antony beula

25-Mar-09 0:33

How to display text in status bar in all browers using javascript

Am using window.status="text message" to display the in status bar, its working fine in IE6, but its not working in IE7 and in other browers.

Anyone please help me out to solve this problem.

beula
CMOTS INFOTECH

Re: Hi experts,

Abhijit Jana25-Mar-09 0:46

Abhijit Jana

25-Mar-09 0:46

antony beula wrote:
Am using window.status="text message" to display the in status bar, its working fine in IE6, but its not working in IE7 and in other browers.

Here you Go.
How To Enable window.status in Firefox[^]

cheers,
Abhijit
CodeProject MVP

Re: Hi experts,

antony beula25-Mar-09 2:28

antony beula

25-Mar-09 2:28

Thanks a lot for your reply.

Its not possible for me to enable window.status in client machine.

Is there any other solution to display text in status bar using asp.net or javascript

beula
CMOTS Infotech

Drop down list inside the itemTemplate in template Field of a gridview

scar_face25-Mar-09 0:02

scar_face

25-Mar-09 0:02

Hi all,
I am generating drop down list boxes for every row of the gridview using the itemTemplate in template Field, i want to give different ID's for each drop down list, how can i do it???
Please help.........

scarface

Re: Drop down list inside the itemTemplate in template Field of a gridview

dayakar_dn25-Mar-09 0:09

dayakar_dn

25-Mar-09 0:09

Hi,
if you placed dropdown list inside the item templage, i think it is not possible to give the different ids for each dropdownlist.

How to use Repeator control?

Subin Alex25-Mar-09 0:01

Subin Alex

25-Mar-09 0:01

Hi,
I want to know wheather a Repeator Control:

1. can accept data from the database instead of XML files?
2. can hold an image control?
If yes plz get me some sampples.

Re: How to use Repeator control?

Abhijit Jana25-Mar-09 0:04

Abhijit Jana

25-Mar-09 0:04

Subin Alex wrote:
Hi,
I want to know wheather a Repeator Control:

1. can accept data from the database instead of XML files?
2. can hold an image control?

Here[^]You Go

cheers,
Abhijit
CodeProject MVP

How to enable so many connections

cmrhema24-Mar-09 23:44

cmrhema

24-Mar-09 23:44

Hi,

"I want that my website should be viewable to 10,000 persons at the same time.
Also they might insert, or delete data from the database.
How will you do it".

This was one of the questions posed in an interview.
Apart from poolsize, what should I answer for the above question.

Regards
cmrhema

Re: How to enable so many connections

Abhijit Jana25-Mar-09 0:52

Abhijit Jana

25-Mar-09 0:52

cmrhema wrote:

"I want that my website should be viewable to 10,000 persons at the same time.
Also they might insert, or delete data from the database.
How will you do it".

Hmm..
Did you ever check top left corner of in Codeproject Sites, that 6,006,898 members and growing! (24,514 online)
It means all online user may view the sites same times and can insert post, replying on post [ AS I am doing ], etc....

cmrhema wrote:
This was one of the questions posed in an interview.
Apart from poolsize, what should I answer for the above question.

This is very common behavior of web sites, for large number of user you many need a strong backend server and all user need to maintain by session only Smile | :)

You can also set the maximum number of request in IIS.  Create Separate Application Pool for the Site, assign that Application pool, change the Application pool Maximum Request Limit.

cheers,
Abhijit
CodeProject MVP

clickable map of USA

laziale24-Mar-09 23:38

laziale

24-Mar-09 23:38

hi there! I need to have a map of USA which can be clickable and depending from the state selection, to display different data. Can someone give me some example how I can do this or guide me to some address where I can see some example. Thanks

Re: clickable map of USA

mr_muskurahat25-Mar-09 0:04

mr_muskurahat

25-Mar-09 0:04

to achieve this functionality you will be have to use api's related thing...

for example..
http://code.google.com/more/#products-products-android[^]

Government Dyal Singh College Lahore.

how to stop refreshing a page when a button clicked at client

prasadbuddhika24-Mar-09 23:32

prasadbuddhika

24-Mar-09 23:32

in my web app when update link is clicked at the page load it fill the textboxes with current user detail, and then these data can be changed. after changing the data when click on the update button the page refresh and load the previous data replacing new data, how can i over come this problem can i stop the page being refreshed when the button clicked

Re: how to stop refreshing a page when a button clicked at client

mr_muskurahat25-Mar-09 0:01

mr_muskurahat

25-Mar-09 0:01

actually if you are filling that data on page load then you are not using page.ispostback check there... thats why your older data gets filled in texboxes you dont need to stop refresh behaviour of server side button...
its a logical problem not the control related..

Government Dyal Singh College Lahore.

Re: how to stop refreshing a page when a button clicked at client

prasadbuddhika25-Mar-09 0:11

prasadbuddhika

25-Mar-09 0:11

thank you , it is the ideal solution for my problem

Re: how to stop refreshing a page when a button clicked at client

Abhijit Jana25-Mar-09 0:18

Abhijit Jana

25-Mar-09 0:18

prasadbuddhika wrote:
after changing the data when click on the update button the page refresh and load the previous data replacing new data,

yes, that because you are loading data on poge load. And when you click on the update button, pages load again and your old data filed the text boxes.

Your Current Scenario :

Page_Load()
  {
   fillTextBoxData(); // assuming you are filling Text Box data 
  }

Change it To

Page_Load()
  {
   if(!Page.ISPostBack) // If page Load  only load the data in the text box
   {
      fillTextBoxData(); // assuming you are filling Text Box data 
   }
  }

Now, Regarding Page Refresh, You can use AJAX Updatepanel. Smile | :)

cheers,
Abhijit
CodeProject MVP

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.