A long time-out problem that entangled me ...

ggggex

The timeout period has expired. The timeout period elapsed or the server did not respond before the operation completed.

Explanation: An unhandled exception occurred during the execution of the current web request. Check the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: The timeout period has expired. The timeout period elapsed or the server did not respond before the operation completed.

Source error:


Line 24: protected void BindCartData ()
Line 25: {
Line 26: mysqlSqlConnection.Open (); // this line is wrong
Line 27: SqlDataAdapter mysqlSqlDataAdapter1 = new SqlDataAdapter ("select top 2 * from aspnet_PhoneItem where Type = 'Music'", mysqlSqlConnection);
Line 28: SqlDataAdapter mysqlSqlDataAdapter2 = new SqlDataAdapter ("select top 2 * from aspnet_PhoneItem where Type = 'Smart'", mysqlSqlConnection);

Source file: f:\Self-made code\MobileBox\Default.aspx.cs Line: 26

3521565

Wrong SQL statement

SqlDataAdapter mysqlSqlDataAdapter1 = new SqlDataAdapter ("select top 2 * from aspnet_PhoneItem where Type = 'Music'", mysqlSqlConnection);


to
SqlDataAdapter mysqlSqlDataAdapter1 = new SqlDataAdapter ("select top 2 * from aspnet_PhoneItem where Type =" + "music", mysqlSqlConnection);



 SqlDataAdapter mysqlSqlDataAdapter2 = new SqlDataAdapter ("select top 2 * from aspnet_PhoneItem where Type =" + "Smart", mysqlSqlConnection);

to
 SqlDataAdapter mysqlSqlDataAdapter2 = new SqlDataAdapter ("select top 2 * from aspnet_PhoneItem where Type =" + "Smart", mysqlSqlConnection);

np1986

This problem is rare when the hardware configuration is better. . .

疾风劲草

mysqlSqlConnection.ConnectionTimeout = 100
If not set, the default is 15 seconds,

saintfrosty

You can switch to SQLite, which is also free.

苹果小刀

mysqlSqlConnection.ConnectionTimeout is longer!

ggggex

mysqlSqlConnection.ConnectionTimeout = 100
If not set, the default is 15 seconds,

An error occurred`
Cannot assign a value to the property indexer System.Data.Common.Dbconnection.ConncetionTimeout-it is read-only

江南小色

SqlDataAdapter.selectcommand.CommandTimeout = 0;

摩羯可乐

Connection pool with server database
Setting mysql SqlConnection.ConnectionTimeout

江南小色

It is not a connection timeout, but a command execution timeout.