i am trying to pick a Varchar field (Question) from tblUser where email = session variable ,
it doesn't give error but picks -1 and shows it, why ?
even that column isn't empt for the matching email
code:
String connectionString = "Data Source=COSANOSTRA; MultipleActiveResultSets=true; Initial Catalog=Waleed_orsfinal;Integrated Security=True";
protected void Page_Load(object sender, EventArgs e)
{
String user_Email = Session["Email_Forgot"].ToString();
SqlConnection con = new SqlConnection(connectionString);
String query_qstn = "Select question from tblUser where email = '"+user_Email+"'';
SqlCommand sqlCom = new SqlCommand(query_qstn,con);
try
{
con.Open();
String qstn = Convert.ToString( sqlCom.ExecuteNonQuery());
Response.Write(qstn);
}
catch (Exception exc)
{
Response.Write("Error:"+ exc.Message);
}
finally
{
con.Close();
}
even if i pass static harcoded email instead of variable, it do give me -1 only, Why ?