dimanche 28 juin 2015

How to record datareader results at Session?

How to record datareader results at Session? I read database then value that I read want to assigne at Session Thank you in advance for your advise

dr = islem.KayitGetir_DataReader("SELECT * FROM products P INNER JOIN products_description PD ON P.products_id = PD.products_id WHERE P.products_id='" + Session[i].ToString() + "'");

        if (dr.Read())
        {
    cartProductImage.ImageUrl = dr["products_thumbnails_images"].ToString();
    lblCartProductName.Text   = dr["pro_description_name"].ToString();
    lblCartProductPrice.Text  = dr["products_price"].ToString();
    dr.Close();

            Session["ProImg"]      = cartProductImage;
            Session["ProImgName"]  = lblCartProductName;
            Session["ProImgPrice"] = lblCartProductPrice;

}

Aucun commentaire:

Enregistrer un commentaire