[RESOLVED] Reader giving error on third read from database.

For the first two reads from the query, it seems like everything is fine. But for some reason the third read gives me an error no matter what I ask it to read from.

Error 1 Cannot implicitly convert type 'object' to 'string'. An explicit conversion exists (are you missing a cast?) C:\Inetpub\wwwroot\thisApp\userpage.aspx.cs 65 35 C:\...\thisApp\

This is the format of my code:
if (Label2.Text == usr)
{
if (Label3.Text == pss)
{
Label2.Text = reader["UserName"] + "<br />";
Label3.Text = reader["Password"] + "<br />";
Label4.Text = reader["Relation"];
//break; //exit out of the loop since user found
}

When I test it with this code it shows it up just fine:
//take the read data from the reader and display it
readDB_Lbl.Text = (String.Format("{0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}, {9}, {10}, {11}, {12}, {13}, {14}, {15}, {16}, {17}, {18}, {19}, {20}, {21}, {22}",
reader[0], reader[1], reader[2], reader[3], reader[4], reader[5], reader[6], reader[7], reader[8], reader[9], reader[10], reader[11], reader[12], reader[13], reader[14], reader[15], reader[16], reader[17], reader[18], reader[19], reader[20], reader[21], reader[22]));

I hope someone can give me a heads up, thank you in advance.

Also, I thought that in C# I could just return the lines to keep them short and that the semicolon would end a line and it wouldn't be a problem for lines to return but with this last bit of code even if I concatenate with a + it still errors out that it's needing to be closed. Why won't something like this work?
readDB_Lbl.Text = (String.Format("{0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}, + {8}, {9}, {10}, {11}, {12}, {13}, {14}, {15}, {16}, {17}, {18}, {19}, + {20}, {21}, {22}",

For the first part I found the answer. Since the database could contain a null in one of the columns, I need to cast .ToString()

Still not sure why the concatenation doesn't work for that last line of examples.
readDB_Lbl.Text = (String.Format("{0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}, +
{20}, {21}, {22}",

How would you concatenate that line if it's not possible this way?

+ is string concatenation or variable addition.

Code:

---

readDB_Lbl.Text = (String.Format(@"{0}, {1}, {2}, {3}, {4}, {5}, {6}, {7},
{20}, {21}, {22}",

---

Using the verbatim (@) should work for you.

Thank you for this.