Esempio n. 1
0
        public string insert_questions(questions q)
        {
            string        msg  = " ";
            SqlConnection conn = new SqlConnection(connstring);

            try
            {
                SqlCommand cmd = new SqlCommand("[insert_questions]", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@q_title", SqlDbType.NVarChar).Value          = q.q_title;
                cmd.Parameters.Add("@q_opa", SqlDbType.NVarChar, 200).Value       = q.q_opa;
                cmd.Parameters.Add("@q_opb", SqlDbType.NVarChar, 200).Value       = q.q_opb;
                cmd.Parameters.Add("@q_opc", SqlDbType.NVarChar, 200).Value       = q.q_opc;
                cmd.Parameters.Add("@q_opd", SqlDbType.NVarChar, 200).Value       = q.q_opd;
                cmd.Parameters.Add("@q_opcorrect", SqlDbType.NVarChar, 200).Value = q.q_opcorrect;
                cmd.Parameters.Add("@q_addeddate", SqlDbType.NVarChar, 20).Value  = q.q_addeddate;
                cmd.Parameters.Add("@q_fk_ad", SqlDbType.Int).Value  = q.q_fk_ad;
                cmd.Parameters.Add("@q_fk_sub", SqlDbType.Int).Value = q.q_fk_sub;


                conn.Open();
                cmd.ExecuteNonQuery();

                msg = "data successfully inserted!";
            }
            catch (Exception)
            {
                msg = "data is not successfully inserted!";
            }
            finally
            {
                conn.Close();
            }
            return(msg);
        }
Esempio n. 2
0
        private void button1_Click(object sender, EventArgs e)
        {
            questions q = new questions();

            q.q_title     = textBox1.Text;
            q.q_opa       = textBox2.Text;
            q.q_opb       = textBox3.Text;
            q.q_opc       = textBox4.Text;
            q.q_opd       = textBox5.Text;
            q.q_opcorrect = textBox6.Text;
            q.q_addeddate = System.DateTime.Now.ToShortDateString();
            q.q_fk_ad     = AdminLogin.fk_ad;
            q.q_fk_sub    = comboBox1.SelectedValue.ToString();

            insertclass ic = new insertclass();

            string msg = ic.insert_questions(q);

            MessageBox.Show(msg);
            textbox();
        }