Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Execution Timeout Expired. The timeout period elapsed prior

Home
Forums
.NET

Execution Timeout Expired. The timeout period elapsed prior

Vatsal Desai

8yAsked Aug 21, 2018, 12:19 AM1.6k.NET

When I fatch Record In Asp.Net From sql server This error is Come

Execution Timeout Expired. The timeout period elapsed prior

Help..

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Pravat Kumar8y ago
Accepted answer
thank you for your suggestion @Vatsal
Vatsal Desai8y ago
Thnks For help its working

but suggestion from my side

declare "Connect Timeout" in the connection string
Database=WIMS;Server=(local);User Id =(Username); Password=(password);Connect Timeout=0"

2. SqlCommand.CommandTimeout
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand("SpGetEmployee", connection);
command.CommandType = CommandType.StoredProcedure;
// Setting command timeout to 0 second so it go to infinity
command.CommandTimeout = 0;
command.ExecuteNonQuery();
}
Pravat Kumar8y ago
Hi Vatsal,

If your query needs more than the default 30 seconds, use below code.

1. declare "Connect Timeout" in the connection string
Database=WIMS;Server=(local);User Id =(Username); Password=(password);Connect Timeout=3000000"

2. SqlCommand.CommandTimeout
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand("SpGetEmployee", connection);
command.CommandType = CommandType.StoredProcedure;
// Setting command timeout to 3000000 second
command.CommandTimeout = 3000000;
command.ExecuteNonQuery();
}