asp.net error: Cannot implicitly convert type 'object' to 'string'. An explicit conversion exists (are you missing a cast?)

Question

I want to retrieve data from a table in sql server called hotel using select WHERE statement and I get the above error. Can anyone help?

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"]);
}

Change dsRow["RoomsAvailable"] to dsRow["RoomsAvailable"].ToString() — shahkalpesh
– shahkalpesh, Commented Aug 27, 2013 at 14:21

Habib · Accepted Answer · 2013-08-27 14:21:24Z

10

Change

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

To

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

answered Aug 27, 2013 at 14:21

Habib

224k30 gold badges420 silver badges446 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Wayne Barron Over a year ago

Thank you, Habib. I encountered this issue while converting from ASP Classic to VB.NET to C#. Everything worked well in the three conversations until I got to this one. Thank you.

Allan Elder · Accepted Answer · 2013-08-27 14:25:22Z

2

Or change to

this.txtHotel.Text = dsRow["RoomsAvailable"] as string;

and you won't get an exception if the value is null.

answered Aug 27, 2013 at 14:25

Allan Elder

4,11421 silver badges20 bronze badges

Comments

senthilkumar2185 · Accepted Answer · 2013-11-25 09:30:49Z

1

Try this Code

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

edited Nov 25, 2013 at 9:30

answered Aug 27, 2013 at 14:26

senthilkumar2185

2,5983 gold badges23 silver badges38 bronze badges

Comments

Paddyd · Accepted Answer · 2013-08-27 14:39:06Z

0

dsRow["RoomsAvailable"] Is an object of type DataRow, if you want the String value you need to call ToString():

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

Docs

answered Aug 27, 2013 at 14:39

Paddyd

1,86816 silver badges27 bronze badges

Comments

Suraj Singh · Accepted Answer · 2013-08-27 14:39:26Z

0

Well i saw this code

cmd.CommandText = "SELECT RoomsAvailable FROM Hotel WHERE HotelName = '" + 
                    this.DropDownList1.Text + "'";

and this.DropDownList1.Text will fetch you selected value not text . just have you given HotelNames as dropdown values ?

and for error Try

Convert.ToString(dsRow ["RoomsAvailable"]);

answered Aug 27, 2013 at 14:39

Suraj Singh

4,0871 gold badge23 silver badges37 bronze badges

Collectives™ on Stack Overflow

asp.net error: Cannot implicitly convert type 'object' to 'string'. An explicit conversion exists (are you missing a cast?)

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related