Breaking News: Grepper is joining You.com. Read the official announcement!

System.Data.SqlClient.SqlException: 'Execution Timeout Expired.

Doctor Strange answered on February 3, 2021 Popularity 9/10 Helpfulness 4/10

answer System.Data.SqlClient.SqlException: 'Execution Timeout Expired.

System.Data.SqlClient.SqlException: 'Execution Timeout Expired.

Comment

1-EntityFramework 
context.Database.SetCommandTimeout(60); //seconds

2-SqlDataAdapter
 dataAdapter.SelectCommand.CommandTimeout = 60;  // seconds

Popularity 9/10 Helpfulness 4/10 Language csharp

Source: Grepper

Tags: c#

Link to this answer
Share Copy Link

Contributed on Jan 16 2022

Doctor Strange

0 Answers Avg Quality 2/10

Closely Related Answers

System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter

Comment

private void FillInDataGrid(string SQLstring)
{
    string cn = ConfigurationManager.ConnectionStrings["Scratchpad"].ConnectionString; //hier wordt de databasestring opgehaald
    DataSet ds = new DataSet();
    // dispose objects that implement IDisposable
    using(SqlConnection myConnection = new SqlConnection(cn))
    {
        SqlDataAdapter dataadapter = new SqlDataAdapter(SQLstring, myConnection);

        // set the CommandTimeout
        dataadapter.SelectCommand.CommandTimeout = 60;  // seconds

        myConnection.Open();
        dataadapter.Fill(ds, "Authors_table"); 
    }
    dataGridView1.DataSource = ds;
    dataGridView1.DataMember = "Authors_table";
}

Popularity 10/10 Helpfulness 3/10 Language sql

Source: stackoverflow.com

Tags: completion c

Link to this answer
Share Copy Link

Contributed on Feb 03 2021

Polen2018

0 Answers Avg Quality 2/10

System.Data.SqlClient.SqlException: 'Execution Timeout Expired.

Contents

More Related Answers

System.Data.SqlClient.SqlException: 'Execution Timeout Expired.

Closely Related Answers

System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.