Datareader(simple)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

SqlCommand findProducts = new SqlCommand("SELECT PRODUCT_TYPE_ID FROM
PRODUCT_TYPE WHERE [NAME] = 'Meals'", sqlConnection1);

This command returns a value of 17. How can i insert this value into
a string variable? Please help . I tried this but it wouldnt work

SqlDataReader myReader = findProducts.ExecuteReader();
while (myReader.Read())
{
ProdTypeID =
int.Parse(myReader["PRODUCT_TYPE_ID"].ToString());
}
.