“System.InvalidOperationException”类型的异常在 System.Data.dll 中发生，但未在用户代码中进行处理 其他信息:

[yzy1991927]

“System.InvalidOperationException”类型的异常在 System.Data.dll 中发生，但未在用户代码中进行处理

其他信息: 在没有任何数据时进行无效的读取尝试。



代码如下： SqlInt32 StoreID = 0;
string sqlstr = "SELECT StoreID,StoreName,ProductTypeID,Description ";
sqlstr += ",ZipCode,Address,Linkman,Tel,Email,Note FROM Store WHERE ";
sqlstr += " LoginName='" + oLoginName.Text + "'AND ";
sqlstr += " Password='" + oPassword.Text + "'";
string constr = ConfigurationSettings.AppSettings["ConnectionString"];
SqlConnection myConnection = new SqlConnection(constr);
SqlCommand myCommand = new SqlCommand(sqlstr, myConnection);
myConnection.Open();
SqlDataReader dr = myCommand.ExecuteReader();
while (dr.Read());
{
StoreID = dr.GetSqlInt32(0);
if (dr.GetSqlString(1).IsNull) nStoreName.Text = "";
else nStoreName.Text = dr.GetSqlString(1).ToString();
if (dr.GetSqlInt32(2).IsNull) nProductTypeID.Text = "";
else nProductTypeID.Text = dr.GetSqlInt32(2).ToString();
if (dr.GetSqlString(3).IsNull) nDescription.Text = "";
else nDescription.Text = dr.GetSqlString(3).ToString();
if (dr.GetSqlString(4).IsNull) nZipCode.Text = "";
else nZipCode.Text = dr.GetSqlString(4).ToString();
if (dr.GetSqlString(5).IsNull) nAddress.Text = "";
else nAddress.Text = dr.GetSqlString(5).ToString();
if (dr.GetSqlString(6).IsNull) nLinkman.Text = "";
else nLinkman.Text = dr.GetSqlString(6).ToString();
if (dr.GetSqlString(7).IsNull) nTel.Text = "";
else nTel.Text = dr.GetSqlString(7).ToString();
if (dr.GetSqlString(8).IsNull) nEmail.Text = "";
else nEmail.Text = dr.GetSqlString(8).ToString();
if (dr.GetSqlString(9).IsNull) nNote.Text = "";
else nNote.Text = dr.GetSqlString(9).ToString();
}
myConnection.Close();
if (StoreID == 0)
{
Message.Text = Inf4.Text; Message.Visible = true;
}
else
{
ED_Password.Checked = false; ED_StoreName.Checked = false;
ED_ProductTypeID.Checked = false; ED_Description.Checked = false;
ED_ZipCode.Checked = false; ED_Linkman.Checked = false;
ED_Address.Checked = false; ED_Tel.Checked = false;
ED_Email.Checked = false; ED_Note.Checked = false;
StoreData.Visible = true; oLoginName.Enabled = false;
oPassword.Enabled = false; Query.Enabled = false;
RF_oPassword.Enabled = false; Message.Visible = false;




}

[slwsss]

while (dr.Read())//; 多了分号 { StoreID = dr.GetSqlInt32(0);