how to solve error of nullreferenceexception

Question

1.00/5 (2 votes)

See more:

public partial class Exam : System.Web.UI.Page
{
   SqlConnection cnn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Maulik\Desktop\template\template\App_Data\Database.mdf;Integrated Security=True;User Instance=True");

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            get_T_No();
        }
        if (!IsPostBack)
        {
            start_exam();
        }
        // Label5.Text = Session["S_Id"].ToString();

    }

    protected Boolean check(int i)
    {
      cnn.Open();
      SqlCommand cmd = new SqlCommand("select * from Exam_Details where queid='" + i + "'", cnn);
      SqlDataAdapter da = new SqlDataAdapter();
      DataSet ds = new DataSet();
      da.SelectCommand = cmd;
      da.Fill(ds);
      cnn.Close();
      int c = ds.Tables[0].Rows.Count;
      if (c == 0)
      {
         return false;
      }
      else
      {
         return true;
       }
   }
      
   private void data_bind()
   {
     cnn.Open();
     lblque.Visible = true;
     rbtnans_1.Visible = true;
     rbtnans_2.Visible = true;
     rbtnans_3.Visible = true;
     rbtnans_4.Visible = true;
     btnne.Visible = true;
     btnre.Visible = true;
     lbla.Visible = true;
     lblb.Visible = true;
     lblc.Visible = true;
     lbld.Visible = true;
     cnn.Close();
     while (!check(Convert.ToInt32(Session["i"].ToString())))
     {
        Session["i"] = Convert.ToInt32(Session["i"].ToString()) + 1;
     }

     cnn.Open();
     SqlCommand cmd = new SqlCommand("select queid,sub_que,que_ans1,que_ans2,que_ans3,que_ans4 from Exam_Details where queid='" + Session["i"].ToString() + "' and subid='" + Session["subid"].ToString() + "'", cnn);
     SqlDataReader dr = cmd.ExecuteReader();
     while (dr.Read())
     {
        HiddenField1.Value = dr.GetValue(0).ToString();
        lblque.Text = dr.GetValue(1).ToString();
        rbtnans_1.Text = dr.GetValue(2).ToString();
        rbtnans_2.Text = dr.GetValue(3).ToString();
        rbtnans_3.Text = dr.GetValue(4).ToString();
        rbtnans_4.Text = dr.GetValue(5).ToString();
      }
      dr.Close();
      cnn.Close();

    }


        protected void btnne_Click(object sender, EventArgs e)
        {

            btnne.Visible = false;
            Session["queid"] = HiddenField1.Value.ToString();

            Session["que_ans"] = "";
            if (rbtnans_1.Checked == true)
            {
                Session["que_ans"] = rbtnans_1.Text.ToString();
            }
            else if (rbtnans_2.Checked == true)
            {
                Session["que_ans"] = rbtnans_2.Text.ToString();

            }
            else if (rbtnans_3.Checked == true)
            {
                Session["que_ans"] = rbtnans_3.Text.ToString();
            }
            else if (rbtnans_4.Checked == true)
            {
                Session["que_ans"] = rbtnans_4.Text.ToString();
            }

            if (Session["queid"] != null && Session["que_ans"] != null)
            {

                cnn.Open();
                string str = "insert into Result_Details(candidateid,queid,subid,que_ans,t_no) values('" + Session["candidateid"].ToString() + "','" + Session["queid"].ToString() + "','" + Session["subid"].ToString() + "','" + Session["que_ans"].ToString() + "','" + Session["t_no"].ToString() + "') "; //error line
                SqlCommand cmd = new SqlCommand(str, cnn);
                cmd.ExecuteNonQuery();
                cnn.Close();

            }

            int tot = 0;

            cnn.Open();
            //string Total = "select count(*) from Exam_Detail where T_Id='" + Session["T_Id"].ToString() + "' ";
            string Total = " select top 1 queid from Exam_Details where subid= '" + Session["subid"].ToString() + "' order by queid desc ";
            SqlCommand cmd2 = new SqlCommand(Total, cnn);
            SqlDataReader dr2 = cmd2.ExecuteReader();
            dr2.Read();
            tot = Convert.ToInt32(dr2.GetValue(0));
            dr2.Close();
            cnn.Close();


            if (Convert.ToInt32(Session["i"]) == tot)
            {
                btnne.Visible = false;
                lblque.Visible = false;
                rbtnans_1.Visible = false;
                rbtnans_2.Visible = false;
                rbtnans_3.Visible = false;
                rbtnans_4.Visible = false;
                btnre.Visible = true;
                lbla.Visible = false;
                lblb.Visible = false;
                lblc.Visible = false;
                lbld.Visible = false;
            }
            else
            {
                rbtnans_1.Checked = false;
                rbtnans_2.Checked = false;
                rbtnans_3.Checked = false;
                rbtnans_4.Checked = false;
                Session["i"] = Convert.ToInt32(Session["i"]) + 1;
                string amit = Session["i"].ToString();
                data_bind();
            }

        }
        protected void btnre_Click(object sender, EventArgs e)
        {
            Response.Redirect("Results.aspx");
        }


        private void get_T_No()
        {
            Session["t_no"] = "";

            cnn.Open();
            string str = "select top 1 t_no from Result_Details order by t_no desc ";
            SqlCommand cmd = new SqlCommand(str, cnn);
            SqlDataReader dr = cmd.ExecuteReader();
            while (dr.Read())
            {
                Session["t_no"] = dr.GetValue(0).ToString();
            }
            dr.Close();
            if (Session["t_no"] == "")
            {
                Session["t_no"] = "1";
                Response.Write(Session["t_no"].ToString());
            }
            else
            {
                Session["t_no"] = Convert.ToInt32(Session["t_no"]) + 1;
                Response.Write(Session["t_no"].ToString());
            }
            cnn.Close();
        }

        protected void start_exam()
        {

            string id = "";


            cnn.Open();
            SqlCommand cmd = new SqlCommand("select top 1 queid from Exam_Details where subid='" + Session["subid"].ToString() + "'", cnn); //error line
            SqlDataReader dr = cmd.ExecuteReader();
            while (dr.Read())
            {
                id = dr.GetValue(0).ToString();
            }
            dr.Close();
            cnn.Close();

            Session["i"] = Convert.ToInt32(id);
            rbtnans_1.Checked = false;
            rbtnans_2.Checked = false;
            rbtnans_3.Checked = false;
            rbtnans_4.Checked = false;
            data_bind();

        }
    }

Posted 5-Nov-14 16:54pm

Member 11210454

Updated 5-Nov-14 17:10pm

Praneet Nadkar

v3

Add a Solution

Comments

syed shanu 5-Nov-14 23:04pm

Where do you get your exception ,
And why you are repeating the same code 2 time for example here
if (!IsPostBack)
{
get_T_No();

}
if (!IsPostBack)
{
start_exam();
}

Laiju k 5-Nov-14 23:18pm

where are you getting exception

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Afzaal Ahmad Zeeshan · Answer 1 · 2014-11-05T17:38:00

The problems seem like Session["subid"].ToString() is null in your code. So when you pass it, it throws this error telling you that this variable is a null and the SqlCommand cannot be generated on a null.

You can fix this issue yourself, null, actually is a very basic kind of error that new developers have to face. It means that the variable actually doesn't exist in the context (memory to be precise).

There are many posts that you can read and the answer is same, You need to initialize the variable's value to be anything, but not a null value.

This might do,

C#

if(Session["subid"] != null) {
   // check the value, if its not a null,  
   // continue
   SqlCommand cmd = new SqlCommand("select top 1 queid from Exam_Details where subid='" + Session["subid"].ToString() + "'", cnn);
} else {
  // otherwise, show a custom error.
}

Read this[^] technical blog post of mine. You might be able to understand, what this error is, how to solve it and how to stop it from occuring again.

Good luck!

DamithSL · Answer 2 · 2014-11-05T17:40:00

according to your exception occurring line, it seems session value that you looking for is null. you can avoid exception by putting validation like below but check why this session value is null before coming to this method, you may have forgot to set value for that.

C#

protected void start_exam()
{
    if(Session["subid"] !=null)
    {
        // your code...

    }
}

Bernhard Hiller · Answer 3 · 2014-11-05T20:38:00

Solution 3

C#

if (!IsPostBack)
      {
          start_exam();
      }

How do you think Session["subid"] received a value if it is the first time that that page is loaded? It must be if (IsPostBack) instead.

Posted 5-Nov-14 20:38pm

Bernhard Hiller

how to solve error of nullreferenceexception

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0