Example #1
0
        protected void add_question(object sender, EventArgs e)
        {
            user faculty = (user)Session["user_logged_in"];

            if (question_validator.IsValid && marks_validator.IsValid)
            {
                SqlConnection con = new SqlConnection();
                con.ConnectionString = "Data Source = (localdb)\\MSSQLlocalDB;Initial Catalog=mini_project;Integrated Security=True";
                try
                {
                    con.Open();

                    string isMcQ = "No";
                    if (mcq.Checked)
                    {
                        isMcQ = "Yes";
                    }
                    String query = "INSERT INTO questions(question_name,marks,mcq,faculty_id,faculty_name,subject,branch,semester,year) VALUES(";
                    query += "@question_name,@marks,@isMcq,@faculty_id,@faculty_name,@subject,@branch,@semester,@year)";
                    SqlCommand cmd = new SqlCommand(query, con);
                    cmd.Parameters.AddWithValue("@question_name", question.Text);
                    cmd.Parameters.AddWithValue("@marks", marks.Items[marks.SelectedIndex].Value.ToString());
                    cmd.Parameters.AddWithValue("@isMcq", isMcQ);
                    cmd.Parameters.AddWithValue("@faculty_id", faculty.get_faculty_id());
                    cmd.Parameters.AddWithValue("@faculty_name", faculty.get_faculty_name());
                    cmd.Parameters.AddWithValue("@subject", faculty.get_subject());
                    cmd.Parameters.AddWithValue("@branch", faculty.get_branch());
                    cmd.Parameters.AddWithValue("@semester", faculty.get_semester());
                    cmd.Parameters.AddWithValue("@year", faculty.get_year());
                    int rows_affected = cmd.ExecuteNonQuery();
                    if (rows_affected == 0)
                    {
                        result.Text      = "Fail,Please contact developer";
                        result.ForeColor = System.Drawing.Color.FromName("Red");
                    }
                    else
                    {
                        result.Text      = "Success";
                        result.ForeColor = System.Drawing.Color.FromName("Green");
                    }
                    result.Visible = true;
                    result.Enabled = true;

                    question.Text = "";
                }
                catch (Exception ex)
                {
                    result.Text      = ex.ToString();
                    result.ForeColor = System.Drawing.Color.FromName("Red");
                    result.Visible   = true;
                    result.Enabled   = true;
                }
                finally
                {
                    con.Close();
                }

                //to bind gridview after update
                //try
                //{
                //    con.Open();
                //    string q = "Select id,question_name,marks,mcq FROM questions WHERE faculty_name = '"+faculty.get_faculty_id()+"'";
                //    SqlDataAdapter ad = new SqlDataAdapter(q, con);
                //    DataTable dt = new DataTable();
                //    ad.Fill(dt);
                //    if (dt.Rows.Count > 0)
                //    {
                //        GridView1.DataSource = dt;
                //        GridView1.DataBind();
                //    }

                //}
                //catch (Exception ex)
                //{

                //}
                //finally
                //{
                //    con.Close();
                //}
                GridView1.DataSourceID = SqlDataSource1.ID;
            }
        }