TimeOut Expired in ado.net and sql server

Some times we feel if we can speed up the sqlserver , or database, and get rid of the a specific problem named "timeout expired"





here`s a link for the same , and now onwards u will not pray to god, we have solution at ur hand

let`s go

thanks
Pradeep Tiwari

timeout expired - ado.net

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Help for ADO.net objects

Some times we get “timeout expired” error.
It may be because of actually time allocated to a particular operation is getting timeout so start debugging.

1st thing to keep in mind is there is two types of time out
1. Connection time out (which is property (read only) of connection object) default (15 sec)
2. Command time out (which is property (read , write) of command object) default (30 sec)

To start with 1st one means Connection Time out : solution is to increase the value say 60 seconds
And for this you will rush to your connection object and as u got a property named ConnectionTimeout and u wil put the code
conn.ConnectionTimeout = 60; (60 seconds)

and according to you every thing is okey, BUT NOT ACCORDING TO ADO.NET
this is read only property.
Work around is to chage your connection string (usually we have this in our web.config or app.config) by putting “connection timeout = 60” or “connect timeout = 60”



Now is you check your connection string, it will use 60 seconds value.

This solution may or may not resolve the problem as there is an another operation connection to this “command” and command it self call time out.

This is 2nd case

To start with Command Time out : solution is increase the value say 60 seconds
And again for this you will rush to ur web.config or app.config and try to accommodate “command timeout = 60” but this will not work for your kind information, information placed at this place is used by connection not by command object.
The work around is, command.commandTimeout is a read and write property means you can set the value directly in code.
Like “Command.CommandTimeout = 900”, if u r using DataAdopter, not a issue just use its proper command type (select, update , delete).
And set this property to a numeric value.

(best example of lateral thinking)

or you can access the same at
timeout Expired

Have some hair pulling exercise

Visit at
http://rollbacktheworld.blogspot.com/

happy hair pulling....

thanks
Pradeep

Tips when working With Master page or SqlDataSource insert function

ADD by Google






Hello here is a posting related to cross container controls access and also a tip related to SqlDataSource.

Go

When We are Working with subcontainers and wanted to access controls from other containers, which is more prominent situation with Master pages , inbuild container controls comes along with VS or with user controls, a tip related to this and a tip related to datasource`s insert command text .

So just into the posting

thanks
Pradeep

introduction of HashTable using .net

Many a times we need to store similar data in our propgram, and you might encounter the situation where the descriminating item is not an integer value ,

What to do? Use Hashtable ..

Enjoy Have nice Time !!!

Pradeep Tiwari

Hello here`s a posting on Dynamic building and execution of assembly at runtime in .net, this posting is coded in .net 2.0 but can be modified for .net 1.x

Enjoy !
have nice time
Pradeep Tiwari

hello good morning


Pradeep Tiwari