public List <clsoptprp> find_rec(Int32 qstcode) { if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("findans", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@qstcode", SqlDbType.Int).Value = qstcode; SqlDataReader dr = cmd.ExecuteReader(); List <clsoptprp> obj = new List <clsoptprp>(); if (dr.HasRows) { dr.Read(); clsoptprp k = new clsoptprp(); k.optcode = Convert.ToInt32(dr[0]); k.optdsc = dr[1].ToString(); k.optqstcode = Convert.ToInt32(dr[2]); obj.Add(k); } dr.Close(); cmd.Dispose(); con.Close(); return(obj); }
public void delete_rec(clsoptprp p) { if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("delopt", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@optcode", SqlDbType.Int).Value = p.optcode; cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); }
protected void Button1_Click(object sender, EventArgs e) { nsquiz.clstbqst obj = new nsquiz.clstbqst(); nsquiz.clstbqstprp objprp = new nsquiz.clstbqstprp(); objprp.qstcatcod = Convert.ToInt32(DropDownList1.SelectedValue); objprp.qstlvl = DropDownList2.SelectedValue; objprp.qstdsc = TextBox1.Text; // obj.save_rec(objprp); Int32 a = obj.save_rec(objprp); //code for answer nsquiz.clsopt obj1 = new nsquiz.clsopt(); nsquiz.clsoptprp objprp1 = new nsquiz.clsoptprp(); objprp1.optqstcode = a; objprp1.optdsc = TextBox2.Text; obj1.save_rec(objprp1); Response.Redirect("frmqst.aspx"); }