Here SET the timeout for calling SQL stored Procedure from c#.
string sConnection = string.Empty;
sConnection = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionName"].ConnectionString;
var sscsb = new SqlConnectionStringBuilder(sConnection);
sscsb.ConnectTimeout = 500;
System.Data.SqlClient.SqlConnection SQLCon = new System.Data.SqlClient.SqlConnection(sscsb.ConnectionString);
SQLCon.Open();
SqlCommand sqlcmd = new SqlCommand("Procedurename", SQLCon);
sqlcmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr = sqlcmd.ExecuteReader();
return rdr;This code snippet is for to set Connection timeout for particular Transaction in C#.
