Object reference not set to an instance of an object.

Deepak Ratan

11y1k.NET

This is my code:

protected void txtcmd_Click(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connect"].ConnectionString);

SqlCommand cmd = new SqlCommand();

int ID = int.Parse(Session["Id"].ToString());

string comments = ((TextBox)statusgrdview.FindControl("txtcommt")).Text;

cmd.CommandType = CommandType.Text;

cmd.CommandText = "insert into TBL_Comments(ID,comments) " + "values("+ID+",@comments);" + "select * from TBL_Comments";

cmd.Parameters.Add("@comments", SqlDbType.VarChar).Value = comments;

statusgrdview.DataSource = GetData(cmd);

statusgrdview.DataBind();

}

private object GetData(SqlCommand cmd)

{

throw new NotImplementedException();

}

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sanjeeb Lenka11y ago
I guess session["id"] is coming as null. put a debug point and check what you are getting in session["id"]
Akhil Garg11y ago
your session["id"] is coming as null Use Convert.ToString instead of ToString and use tryparse for integer conversion.
Deepak Ratan11y ago
From this line
int ID = int.Parse(Session["Id"].ToString());
Sanjeeb Lenka11y ago
In which line you are getting error.
Deepak Ratan11y ago
Hi Dipankar Biswas,
ERROR
Dipankar Biswas11y ago
Hi

I think

SqlCommand cmd= new SqlCommand(con);

Try it..