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.Data;
namespace enroll
{
public partial class _Default : System.Web.UI.Page
{
public string GetConnectionString()
{
return System.Configuration.ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
}
private void InsertInfo()
{
SqlConnection cn = new SqlConnection("Data Source=SHIVLINE1-PC;Initial Catalog=ENROLLMENT;Integrated Security=True");
string cmdString = ("Insert into enrollment_table values @cources, @first_name,@middle_name, @last_name, @date_of_birth, @sex,@school_college_name,@board,@last_exam_appeared,@optional_subject,@maths,@science,@overall,@mobile_no,@email_id,@address,@state,@pin,@city,@phone_no,@first_name1,@middle_name1,@last_name1,@occupation1,@designation1,@mobile_no1,@office_address1,@state1,@city1,@pin1,@phone_no1,@first_name2,@middle_name2_name,@last_name2,@occupation2,@designation2,@mobile_no2,@office_address2,@state2,@city2,@pin2,@phone_no)");
try
{
cn.Open();
SqlCommand cmd = new SqlCommand(cmdString, cn);
cmd.Connection = cn;
cmd.Parameters.AddWithValue("@cources", DropDownList1.Text);
cmd.Parameters.AddWithValue("@first_name", TextBox41.Text);
cmd.Parameters.AddWithValue("@middle_name", TextBox18.Text);
cmd.Parameters.AddWithValue("@last_name", TextBox3.Text);
cmd.Parameters.AddWithValue("@date_of_birth", TextBox17.Text);
cmd.Parameters.AddWithValue("@sex", sex.Text);
cmd.Parameters.AddWithValue("@school_college_name", TextBox4.Text);
cmd.Parameters.AddWithValue("@board", board.Text);
cmd.Parameters.AddWithValue("@last_exam_appeared", last_exam_appeared.Text);
cmd.Parameters.AddWithValue("@optional_subject", TextBox5.Text);
cmd.Parameters.AddWithValue("@maths", TextBox6.Text);
cmd.Parameters.AddWithValue("@science", TextBox8.Text);
cmd.Parameters.AddWithValue("@overall", TextBox9.Text);
cmd.Parameters.AddWithValue("@mobile_no", TextBox10.Text);
cmd.Parameters.AddWithValue("@email_id", TextBox11.Text);
cmd.Parameters.AddWithValue("@address", TextBox12.Text);
cmd.Parameters.AddWithValue("@state", TextBox13.Text);
cmd.Parameters.AddWithValue("@pin", TextBox15.Text);
cmd.Parameters.AddWithValue("@city", TextBox14.Text);
cmd.Parameters.AddWithValue("@phone_no", TextBox16.Text);
cmd.Parameters.AddWithValue("@first_name1", TextBox19.Text);
cmd.Parameters.AddWithValue("@middle_name1", TextBox20.Text);
cmd.Parameters.AddWithValue("@last_name1", TextBox21.Text);
cmd.Parameters.AddWithValue("@occupation1", TextBox22.Text);
cmd.Parameters.AddWithValue("@designation1", TextBox23.Text);
cmd.Parameters.AddWithValue("@mobile_no1", TextBox24.Text);
cmd.Parameters.AddWithValue("@office_address1", TextBox25.Text);
cmd.Parameters.AddWithValue("@state1", TextBox26.Text);
cmd.Parameters.AddWithValue("@city1", TextBox27.Text);
cmd.Parameters.AddWithValue("@pin1", TextBox29.Text);
cmd.Parameters.AddWithValue("@phone_no1", TextBox28.Text);
cmd.Parameters.AddWithValue("@first_name2", TextBox30.Text);
cmd.Parameters.AddWithValue("@middle_name2", TextBox36.Text);
cmd.Parameters.AddWithValue("@last_name2", TextBox31.Text);
cmd.Parameters.AddWithValue("@occupation2", TextBox37.Text);
cmd.Parameters.AddWithValue("@designation2", TextBox32.Text);
cmd.Parameters.AddWithValue("@mobile_no2", TextBox38.Text);
cmd.Parameters.AddWithValue("@office_address2", TextBox33.Text);
cmd.Parameters.AddWithValue("@state2", TextBox39.Text);
cmd.Parameters.AddWithValue("@city2", TextBox34.Text);
cmd.Parameters.AddWithValue("@pin2", TextBox40.Text);
cmd.Parameters.AddWithValue("@phone_no2", TextBox35.Text);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
catch (System.Data.SqlClient.SqlException ex)
{
string msg = "Insert Error:";
msg += ex.Message;
}
finally
{
cn.Close();
}
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
InsertInfo();
}
protected void Page_Load(object sender, EventArgs e)
{
}
}
}