i want to add imagesand selected values of checkbox and buttons to sqldatabase

Vote count:

0

i am making project for my last year in that i have to create a admission form in asp.net C# in which i have added textbook, drop-down list,buttons,check-boxes and file-upload control button to insert images but i am unable to add the values of buttons,check-boxes and images in database please help me.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;

public partial class Admin_Admision : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        try
        {
            SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["RegistrationConnectionString"].ConnectionString);
            conn.Open();
            String InsertQuery = "insert into Admission(FirstName, MiddleName, LastName, Day, Month, Year,Adress,Emailid,PhoneNo,Courses,GenderM,GenderF,English,Hindi,Marathi,Bk,Eco,Sp,Maths,Oc,Evs,Fc,School_college,MarksSSC,MarksSYJC,MarksTYBCOM,Image) values(@firstName, @middleName, @lastName, @day, @month, @year,@adress,@emailid,@phoneNo,@courses,@genderM,@genderF,@english,@hindi,@marathi,@bk,@eco,@sp,@maths,@oc,@evs,@fc,@school_college,@marksSSC,@marksSYJC,@marksTYBCOM,@image)";
            SqlCommand com = new SqlCommand(InsertQuery, conn);
            com.Parameters.AddWithValue("@firstName", TextBoxname.Text);
            com.Parameters.AddWithValue("@middleName", TextBoxMname.Text);
            com.Parameters.AddWithValue("@lastName", TextBoxLastname.Text);
            com.Parameters.AddWithValue("@day", DropDownListday.SelectedItem.ToString());
            com.Parameters.AddWithValue("@month", DropDownListmonth.SelectedItem.ToString());
            com.Parameters.AddWithValue("@year", DropDownListyear.SelectedItem.ToString());
            com.Parameters.AddWithValue("@adress", TextBoxaddress.Text);
            com.Parameters.AddWithValue("@emailid", TextBoxemail.Text);
            com.Parameters.AddWithValue("@phoneNo", TextBoxno.Text);
            com.Parameters.AddWithValue("@courses", DropDownListcourse.SelectedItem.ToString());
            com.Parameters.AddWithValue("@genderM", RadioButtonmale.Text);
            com.Parameters.AddWithValue("@genderF", RadioButtonfemale.Text);
            com.Parameters.AddWithValue("@english", CheckBoxeng.Text);
            com.Parameters.AddWithValue("@hindi", CheckBoxhin.Text);
            com.Parameters.AddWithValue("@marathi", CheckBoxmarathi.Text);
            com.Parameters.AddWithValue("@bk", CheckBoxbk.Text);
            com.Parameters.AddWithValue("@eco", CheckBoxeco.Text);
            com.Parameters.AddWithValue("@sp", CheckBoxsp.Text);
            com.Parameters.AddWithValue("@maths", CheckBoxmath.Text);
            com.Parameters.AddWithValue("@oc", CheckBoxoc.Text);
            com.Parameters.AddWithValue("@evs", CheckBoxevs.Text);
            com.Parameters.AddWithValue("@fc", CheckBoxfc.Text);
            com.Parameters.AddWithValue("@school_college", TextBoxSchool.Text);
            com.Parameters.AddWithValue("@marksSSC", TextBoxMssc.Text);
            com.Parameters.AddWithValue("@marksSYJC", TextBoxMsyjc.Text);
            com.Parameters.AddWithValue("@marksTYBCOM", TextBoxMtybcom.Text);
            com.Parameters.AddWithValue("@image", FileUpload1.PostedFile);

            com.ExecuteNonQuery();
            Response.Redirect("EnrollDetails.aspx");




            conn.Close();
        }
        catch (Exception ex)
        {
            Response.Write("Error:" + ex.ToString());

        }
    }
    protected void CheckBox1_CheckedChanged(object sender, EventArgs e)
    {

    }
}

asked 52 secs ago

Sumit Pandey

1