Click here to Skip to main content
15,917,176 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
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;
            //sets the connection string from your web config file "ConnString" is the name of your Connection String
        }
        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)
        {
        }
    }
}
Posted
Updated 2-Dec-11 0:20am
v2
Comments
sriman.ch 2-Dec-11 6:21am    
Edited for readability...
R. Giskard Reventlov 2-Dec-11 6:21am    
How about a question?

1 solution

Hi
As per my observation there is some syntax error in your insert query.

Check your query once again

Insert into XXXXXX values();

opening bracket is missing.

Try to execute the query in direct sql and see if it is working.


try to use stored procedure instead of inline query.
Hopw this helps.
 
Share this answer
 
v3
Comments
thatraja 2-Dec-11 6:29am    
Spot on, 5!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900