0

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 ?

2
Contributors
2
Replies
4
Views
4 Years
Discussion Span
Last Post by HunainHafeez
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.