protected void Button2_Click(object sender, EventArgs e) { Examination exam = (Examination)Session["questions"]; try { var conString = System.Configuration. ConfigurationManager.ConnectionStrings["examConnectionString"]; string strConnString = conString.ConnectionString; SqlConnection con = new SqlConnection(strConnString); // SqlConnection con = new SqlConnection("uid=sa;database=exam"); con.Open(); SqlCommand cmd = new SqlCommand("select isnull( max(examid),0) + 1 from oe_essay", con); int examid = (Int32)cmd.ExecuteScalar(); cmd.CommandText = "insert into oe_esay values(@examid,@mid,@fullname,@sid,@noq,@ans,@stdate,getdate())"; cmd.Parameters.Add("@examid", SqlDbType.Int).Value = examid; cmd.Parameters.Add("@mid", SqlDbType.Int).Value = exam.mid; cmd.Parameters.Add("@fullname", SqlDbType.VarChar).Value = exam.fullname; cmd.Parameters.Add("@sid", SqlDbType.Int).Value = exam.sid; cmd.Parameters.Add("@noq", SqlDbType.Int).Value = exam.SIZE; cmd.Parameters.Add("@ans", SqlDbType.NVarChar).Value = TextBox1.Text; cmd.Parameters.Add("@stdate", SqlDbType.DateTime).Value = exam.StartTime; cmd.ExecuteNonQuery(); } catch (Exception ex) { Label1.Text = "Message" + ex; } //con.Close(); }
object reference not set to an instance of an object
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)