当我查找数据时,我收到此错误 [英] i am getting this error when i look for data
本文介绍了当我查找数据时,我收到此错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
ErrorSystem.Data.SqlClient.SqlException:超时已过期。 完成 操作或<之前经过的超时时间/ span>服务器 不响应。在System.Data.SqlClient.SqlConnection.OnError(SqlException异常,布尔 breakConnection)处于System.Data.SqlClient.SqlInternalConnection.OnError(SqlException异常, Boolean breakConnection stateObj)System.Data.SqlClient.SqlDataReader.ConsumeMetaData()在System.Data.SqlClient.SqlDataReader.get_MetaData()处于System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,RunBehavior runBehavior, String resetOptionsString(CommandBehavior cmdBehavior,RunBehavior runBehavior, Boolean returnStream, Boolean async )(CommandBehavior cmdBehavior,RunBehavior runBehavior, Boolean returnStream,字符串方法,DbAsyncResult结果)在System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior,RunBehavior runBehavior, Boolean returnStream, String 方法) System.Data.Common上System.Data.Comb.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)的System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior行为)中的关键字> String 方法 .DbDataAdapter.FillInternal(DataSet数据集,DataTable [] datatables, Int32 startRecord, Int32 System.Data.Common.DbDataAdapter.Fill中的maxRecords,字符串 srcTable,IDbCommand命令,CommandBehavior行为)(DataSet dataSet, Int32 在System.Data中的startRecord, Int32 maxRecords,字符串 srcTable,IDbCommand命令,CommandBehavior行为) .Common.DbDataAdapter.Fill(DataSet dataSet)位于Admin_BranchWiseReport.BindGrid()位于 d:\inetpub \vhosts \shriwinagro.com \ httpdocs \ Admin \ BranchWiseReport.aspx.cs:line 340
im得到此错误当我寻找2个月之间的数据。但是当我寻找1个月时它的工作..为什么这个错误..
解决方案
这个错误的原因很多。检查这些
肮脏的方式
增加 SQL连接 [ ^ ]
增加SQL命令 [ ^ ]。
好方法
使用 SQL Server Profiler [ ^ ]
如何识别SQL Server的性能问题,通过分析事件探查器输出? [的 ^ ]
SQL Server最佳实践 [ ^ ]
优化数据库
在SQL Server中优化数据访问的十大步骤:第一部分(使用索引) [ ^ ]
优化SQL Server数据访问的十大步骤:第二部分(重新考虑TSQL并应用最佳实践) [ ^ ]
在SQL Server中优化数据访问的十大步骤:第III部分(应用高级索引和非规范化) [ ^ ]
前10名在SQL Server中优化数据访问的步骤:第IV部分(诊断数据库性能问题) [ ^ ]
优化的十大步骤在SQL Server数据存取:第一部分V(优化的数据库文件,并应用分区) [ ^ ]
ErrorSystem.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Admin_BranchWiseReport.BindGrid() in d:\inetpub\vhosts\shriwinagro.com\httpdocs\Admin\BranchWiseReport.aspx.cs:line 340
i m getting this error when i look for data between 2 months.but its working when i look for 1 month..why for this error..解决方案Many reasons for this error. Check these
Dirty ways
Increase timeout for SQL connection[^]
Increase timeout for SQL command[^].
Good ways
Use SQL Server Profiler[^]
How to identify SQL Server performance issues, by analyzing Profiler output?[^]
SQL Server Best Practices[^]
Optimize the database
Top 10 steps to optimize data access in SQL Server: Part I (use indexing)[^]
Top 10 steps to optimize data access in SQL Server: Part II (Re-factor TSQL and apply best practices)[^]
Top 10 steps to optimize data access in SQL Server: Part III (Apply advanced indexing and denormalization)[^]
Top 10 steps to optimize data access in SQL Server: Part IV (Diagnose database performance problems)[^]
Top 10 steps to optimize data access in SQL Server: Part V (Optimize database files and apply partitioning)[^]
这篇关于当我查找数据时,我收到此错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文