c# - asp.net 错误 : Cannot implicitly convert type 'object' to 'string' . 存在显式转换(是否缺少强制转换？)

Question

我想使用 select WHERE 语句从名为 hotel 的 sql server 中的表中检索数据，但出现上述错误。谁能帮忙？

SqlConnection cnn = new
        SqlConnection(ConfigurationManager.ConnectionStrings["myConnectionString"].ToString());
cnn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT RoomsAvailable FROM Hotel WHERE HotelName = '" + 
                    this.DropDownList1.Text + "'";
cmd.Connection = cnn;
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds, "Hotel");
SqlCommandBuilder cb = new SqlCommandBuilder(da);
DataRow dsRow = null;
foreach (DataRow dsRow_loopVariable in ds.Tables["Hotel"].Rows)
{
    dsRow = dsRow_loopVariable;
    //This line is where the error comes in.
    this.txtHotel.Text = (dsRow["RoomsAvailable"]);
}

Answer 1

改变

this.txtHotel.Text = (dsRow["RoomsAvailable"]);

到

this.txtHotel.Text = (dsRow["RoomsAvailable"].ToString());