DbCommand ：执行超时已过期。完成操作之前已超时或服务器未响应。

问题：“Timeout 时间已到。在操作完成之前超时时间已过或服务器未响应。”的解决方法

 

在一个链接数据库的时候，老是出现超时的错误：执行超时已过期。完成操作之前已超时或服务器未响应。 

就是给这个链接加上一个TimeOut的属性

 public static DataSet ExeQuery(string Cmd)
    {

        Database db = DatabaseFactory.CreateDatabase(connstring_TMS);
        DbConnection conn = db.CreateConnection();
        try
        {
            DbCommand comm = conn.CreateCommand();
            comm.CommandTimeout = 5000;//500秒，单位是秒
            conn.Open();
            comm.CommandText = Cmd;
            DbDataReader read = comm.ExecuteReader();
            return ConvertDataReaderToDataSet(read);
        }

        finally
        {
            conn.Close();
            conn = null;
        }
    }

 public static DataSet ConvertDataReaderToDataSet(DbDataReader reader)
    {
        DataSet dataSet = new DataSet();
        do
        {
            // Create new data table
            DataTable schemaTable = reader.GetSchemaTable();
            DataTable dataTable = new DataTable();
            if (schemaTable != null)
            {
                // A query returning records was executed 
                for (int i = 0; i < schemaTable.Rows.Count; i++)
                {
                    DataRow dataRow = schemaTable.Rows[i];
                    // Create a column name that is unique in the data table 
                    string columnName = (string)dataRow["ColumnName"]; //+ " // Add the column definition to the data table 
                    DataColumn column = new DataColumn(columnName, (Type)dataRow["DataType"]);
                    dataTable.Columns.Add(column);
                }
                dataSet.Tables.Add(dataTable);
                // Fill the data table we just created
                while (reader.Read())
                {
                    DataRow dataRow = dataTable.NewRow();
                    for (int i = 0; i < reader.FieldCount; i++)
                    {
                        dataRow[i] = reader.GetValue(i);
                    }
                    dataTable.Rows.Add(dataRow);
                }
            }
            else
            {
                // No records were returned
                DataColumn column = new DataColumn("RowsAffected");
                dataTable.Columns.Add(column);
                dataSet.Tables.Add(dataTable);
                DataRow dataRow = dataTable.NewRow();
                dataRow[0] = reader.RecordsAffected;
                dataTable.Rows.Add(dataRow);
            }
        }
        while (reader.NextResult());
        return dataSet;
    }