0

i have created a page where one can edit previous message or add new. for that i created a cookie and store the primary key value and process over one want to edit

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            object ob = Session["red"];
            if (ob != null)
            {
                //try
                //{
                    string d = null;
                   
                        d = Response.Cookies["no"]["date"].ToString();//problem is here read below
                    
                        if (d != null)
                        {
                            SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\afset.mdf;Integrated Security=True;User Instance=True");
                            SqlCommand cm = new SqlCommand("select * from notice where date='" + d + "'", con);
                            con.Open();
                            SqlDataReader dr = cm.ExecuteReader();
                            if (dr.Read())
                            {
                                string l, t;
                                l = dr["linktxt"].ToString();
                                t = dr["text"].ToString();
                                TextBox1.Text = l;
                                TextBox2.Text = t;
                            }
                        }
                        else
                        {
                            SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\afset.mdf;Integrated Security=True;User Instance=True");
                            SqlCommand cmd = new SqlCommand("select distinct Dept from sub", con);
                            con.Open();

                            DropDownList2.DataSource = cmd.ExecuteReader();
                            DropDownList2.DataTextField = "Dept";
                            DropDownList2.DataBind();
                            DropDownList2.Items.Insert(0, "select");
                            con.Close();
                        }
                    }
                //}
                //catch (Exception ex)
                //{
                //    HttpCookie m = new HttpCookie("exe");
                //    m.Values["e"] = ex.StackTrace.ToString();
                //    Response.Cookies.Add(m);
                //    Response.Redirect("~\\Error.aspx");
                //}
            }
            else
            { Response.Redirect("~\\Register.aspx"); }
        }

    }

now the problem if person go directly to that page it throws an exception of object reference as cookie was never created, now i want that if cookie do not store the value then that part should not take place.

2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by __avd
This topic has been dead for over six months. 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.