ExecuteReader需要一個(gè)開放和可用的連接。連接的當(dāng)前狀態(tài)是連接當(dāng)嘗試通過ASP.NET Online連接到MSSQL數(shù)據(jù)庫時(shí),當(dāng)兩個(gè)或多個(gè)人同時(shí)連接時(shí),我將得到以下信息:ExecuteReader需要一個(gè)開放和可用的連接。連接的當(dāng)前狀態(tài)是連接。該站點(diǎn)在我的本地主機(jī)服務(wù)器上運(yùn)行良好。這是粗略的代碼。public Promotion retrievePromotion(){
int promotionID = 0;
string promotionTitle = "";
string promotionUrl = "";
Promotion promotion = null;
SqlOpenConnection();
SqlCommand sql = SqlCommandConnection();
sql.CommandText = "SELECT TOP 1 PromotionID, PromotionTitle, PromotionURL FROM Promotion";
SqlDataReader dr = sql.ExecuteReader();
while (dr.Read())
{
promotionID = DB2int(dr["PromotionID"]);
promotionTitle = DB2string(dr["PromotionTitle"]);
promotionUrl = DB2string(dr["PromotionURL"]);
promotion = new Promotion(promotionID, promotionTitle, promotionUrl);
}
dr.Dispose();
sql.Dispose();
CloseConnection();
return promotion;}我能知道哪里可能出了問題嗎?我該如何解決呢?編輯:不要忘記,我的連接字符串和連接都是靜態(tài)的。我相信這就是原因。請(qǐng)指點(diǎn)。public static string conString = ConfigurationManager.ConnectionStrings["dbConnection"].ConnectionString;
public static SqlConnection conn = null;
- 1 回答
- 0 關(guān)注
- 471 瀏覽
添加回答
舉報(bào)
0/150
提交
取消