How can I set the time out, in the command and the connection?

Question

this is my code in the dataset.cs. what do I have to add for set the timeout in the connection and the command?

namespace M_Report
{


    partial class A_DBDataSet
    {

        partial class VP_DataTable
        {
        }
    }
}


namespace M_Report.A_DBDataSetTableAdapters
{
    partial class VD_TableAdapter
    {
    }

    public partial class VP_rofitsTableAdapter {
    }
}

I'm guessing by the fact that you accepted an answer that your reffering to ado.net `SqlCommand` object. Please try and be more clear in your questions — Liam, May 02 '19 at 13:28

score 0 · Answer 1 · answered May 02 '19 at 11:17

0

If you want a timeout for a particular query, then CommandTimeout is the way.

command.CommandTimeout = 60; //default is 30 seconds.

Or you can also add it in the connection string

connect timeout=180;

answered May 02 '19 at 11:17

Hitesh Anshani

1,499
9
19

score 0 · Accepted Answer · answered May 06 '19 at 07:44

Add this code in the DataSet.cs:

namespace P.A_DBDataSetTableAdapters
{
    public partial class VD_TableAdapter
    {
        public int CommandTimeout
        {
            set
            {
                int i = 0;
                while ((i < this.CommandCollection.Length))
                {
                    if ((this.CommandCollection[i] != null))
                        this.CommandCollection[i].CommandTimeout = value;
                    i = (i + 1);
                }
            }
        }
    }
}

And this code in the Form.cs: this.vD_TableAdapter.CommandTimeout = 1800;

How can I set the time out, in the command and the connection?

2 Answers2