problem in adding data into the database.

Question

0.00/5 (No votes)

See more:

Hello Sir,
I have made a registration form and i have connected it to the database as follows:-

C#

protected void Button9_Click(object sender, EventArgs e)
    {
        String facilities="";
        String recuritementof="";
        String intrvwmode1="",intrvwmode2="",intrvwmode3="",intrvwmode4="";
        String cintletter="";
        String pneeded="";
        
        SqlConnection conn = new SqlConnection();
        SqlCommand comm = new SqlCommand();
        conn.ConnectionString = ConfigurationManager.ConnectionStrings["abc"].ToString();
        comm.Connection = conn;
        comm.CommandType = CommandType.Text;
        comm.Parameters.Add(new SqlParameter("@rname",TextBox8.Text));
        comm.Parameters.Add(new SqlParameter("@cname",TextBox9.Text));
        comm.Parameters.Add(new SqlParameter("@country", TextBox10.Text));
        comm.Parameters.Add(new SqlParameter("@state", TextBox11.Text));
        comm.Parameters.Add(new SqlParameter("@city", TextBox12.Text));
        comm.Parameters.Add(new SqlParameter("@craddress", TextBox13.Text));
        comm.Parameters.Add(new SqlParameter("@paddress", TextBox14.Text));
        comm.Parameters.Add(new SqlParameter("@hremail", TextBox15.Text));
        comm.Parameters.Add(new SqlParameter("@cphone", TextBox16.Text));
        comm.Parameters.Add(new SqlParameter("@hrphone", TextBox17.Text));
        comm.Parameters.Add(new SqlParameter("@faxnum", TextBox18.Text));
        comm.Parameters.Add(new SqlParameter("@pincode", TextBox19.Text));
        comm.Parameters.Add(new SqlParameter("@caddress", TextBox20.Text));
        comm.Parameters.Add(new SqlParameter("@cstartingdate", TextBox21.Text));
        comm.Parameters.Add(new SqlParameter("@dealsin", TextBox22.Text));
        comm.Parameters.Add(new SqlParameter("@recuritementfor", DropDownList5.SelectedItem.ToString()));
        if(RadioButton6.Checked)
        {
            recuritementof="Male";
        }
        else
        {
            recuritementof="Female";
        }
        comm.Parameters.Add(new SqlParameter("@recuritementof",recuritementof));
        comm.Parameters.Add(new SqlParameter("@numofcandidates", TextBox23.Text));
        comm.Parameters.Add(new SqlParameter("@exprequired", DropDownList6.SelectedItem.ToString()));
        comm.Parameters.Add(new SqlParameter("@qualification", DropDownList11.SelectedItem.ToString()));
        comm.Parameters.Add(new SqlParameter("@reliability", TextBox25.Text));
        comm.Parameters.Add(new SqlParameter("@ctc", TextBox26.Text));
        if(RadioButton8.Checked)
        {
            facilities="TA";
        }
        else if(RadioButton9.Checked)
        {
            facilities="DA";
        }
        else if(RadioButton10.Checked)
        {
            facilities="HRA";
        }
        else
        {
            facilities="Medical Support";
        }
        comm.Parameters.Add(new SqlParameter("@facilities", facilities));
        comm.Parameters.Add(new SqlParameter("@candidateemail", TextBox27.Text));
        comm.Parameters.Add(new SqlParameter("@candidatephone", TextBox28.Text));
        comm.Parameters.Add(new SqlParameter("@aboutcmpny", TextBox29.Text));
        comm.Parameters.Add(new SqlParameter("@jobopeningdate", TextBox30.Text));
        comm.Parameters.Add(new SqlParameter("@jobclosingdate", TextBox31.Text));
        if (RadioButton12.Checked)
        {
            intrvwmode1 = "Telephonic";
        }
        else
        {
            intrvwmode1 = "Aptitude Test";
        }
        if (RadioButton14.Checked)
        {
            intrvwmode2 = "GD";
        }
        else
        {
            intrvwmode2 = "Technical Test";
        }
        if (RadioButton16.Checked)
        {
            intrvwmode3 = "Personal Interview";
        }
        else
        {
            intrvwmode3 = "Account Checking";
        }
        if (RadioButton18.Checked)
        {
            intrvwmode4 = "Giving Offer Letter";
        }
        comm.Parameters.Add(new SqlParameter("@interviewmode", intrvwmode1 + intrvwmode2 + intrvwmode3 + intrvwmode4));
        comm.Parameters.Add(new SqlParameter("@venue", TextBox32.Text));
        comm.Parameters.Add(new SqlParameter("@reachat",TextBox33.Text));
        if(RadioButton19.Checked)
        {
            cintletter="Yes";
        }
        else
        {
            cintletter="No";
        }
        comm.Parameters.Add(new SqlParameter("@carryletter", cintletter));
        comm.Parameters.Add(new SqlParameter("@industry", DropDownList7.SelectedItem.ToString()));
        comm.Parameters.Add(new SqlParameter("@rolepost", DropDownList12.SelectedItem.ToString()));
        comm.Parameters.Add(new SqlParameter("@howknow", DropDownList8.SelectedItem.ToString()));
        if(RadioButton3.Checked)
        {
            pneeded="Platinum";
        }
        else if(RadioButton4.Checked)
        {
            pneeded="Gold";
        }
        else
        {
            pneeded="Silver";
        }
        comm.Parameters.Add(new SqlParameter("@planneed", pneeded));
        comm.Parameters.Add(new SqlParameter("@charges", DropDownList9.SelectedItem.ToString()));
        comm.Parameters.Add(new SqlParameter("@paymentmode",DropDownList10.SelectedItem.ToString()));
        comm.CommandText = "insert into recuriter values(@rname,@cname,@country,@state,@city,@craddress,@paddress,@hremail,@cphone,@hrphone,@faxnum,@pincode,@caddress,@cstartingdate,@dealsin,@recuritementfor,@recuritementof,@numofcandidates,@candidatephone,@exprequired,@qualification,@ctc,@facilities,@candidateemail,@candidatephone,@aboutcmpny,@jobopeningdate,@jobclosingdate,@interviewmode,@venue,@reachat,@carryletter,@industry,@rolepost,@howknow,@planneed,@charges,@paymentmode)";
        conn.Open();
        comm.ExecuteNonQuery();
        conn.Close();
        comm.Parameters.Clear();
    }

but when i click at the submit button than it does nothing an its running properly no error is giving. Now i am unable to understand that why the values are not going in to the database.
sir please give me any possible solution.

Thank You.

Posted 30-Apr-11 22:27pm

Shristi Tyagi

Updated 30-Apr-11 22:34pm

DaveAuld

v2

Add a Solution

Comments

DaveAuld 1-May-11 4:35am

EDIT: added code formatting

Wonde Tadesse 1-May-11 12:23pm

Are all the table column datatypes string type(i.e nvarchar, varchar, ntext ...) ?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Answer 1 · 2011-04-30T22:39:00

Solution 1

Your INSERT statement does not list the columns the data is to go into:

SQL

INSERT INTO myTable VALUES (@C1, @C2)

Try:

SQL

INSERT INTO myTable (myColumn1, myColumn2) VALUES (@C1, @C2)

I would expect this to raise an SQL error, but it may be that you are catching the exception and discarding it at a higher level.

Posted 30-Apr-11 22:39pm

OriginalGriff

Comments

Shristi Tyagi 1-May-11 5:04am

Sir i have just tried your solution but my problem is remain same it is doing nothing.

OriginalGriff 1-May-11 5:12am

Add a try-catch block around your method, and see if you get an error message - you need information as to what is happening at the moment.

Shristi Tyagi 1-May-11 5:18am

ok sir iam trying.

Shristi Tyagi 1-May-11 5:26am

sir no effect.i dn't know what to do.

OriginalGriff 1-May-11 5:40am

OK, so either your code is not executing, or you aren't debugging it.
Have you tried breakpointing it with the debugger? Does it enter the method and stop, waiting for you to continue?
If the debugger doesn't appear to be working for some reason, then try adding tracing statements.
At the top of your method:
StreamWriter sw = File.AppendText(@"F:\Temp\mylog.txt");
sw.WriteLine(DateTime.Now.ToString() + " : Click started.");
At the bottom:
sw.WriteLine(DateTime.Now.ToString() + " : Click ended!");
sw.Close();
In between, you can add bits to check what you are adding, etc.
Put a WriteLine in the catch block to give you any message.

You will want to replace "F:\Temp\" with somewhere you can find easily! Run your program, and see what you get in the text file.

Shristi Tyagi 1-May-11 6:03am

sir nothing is going into this file.it is empty.

OriginalGriff 1-May-11 6:09am

Then it looks like you are not executing the method at all!
Check that Button9 has the click event handled and that it is going to the correct method.

Shristi Tyagi 1-May-11 6:43am

Thank you sir for giving me suggestions and for giving me your precious time.
but still i am unable to find out the problem.

OriginalGriff 1-May-11 6:49am

Do any other buttons work?
If so, call the Button9_Click method from inside one of their handlers: Does anything happen?

Shristi Tyagi 1-May-11 6:55am

sir this form has only one button.

OriginalGriff 1-May-11 7:14am

And you called it Button9? :laugh:

OK: is this winforms, or web based?

Ashishmau 2-May-11 1:16am

as per discussion and problem , i also think u r not executing ur insert method. check carefully by debugging

ashokkrishnan · Answer 2 · 2011-05-01T18:45:00

Solution 2

"insert into recuriter (fieldname1,fieldname2,fieldname3)values(@rname,@cname,@country,@state.....

try with it

Posted 1-May-11 18:45pm

ashokkrishnan

LakshmiNarayana Nalluri · Answer 3 · 2011-05-01T19:08:00

Solution 3

at insert statement give as
insert into tablename(col1,col2,....) values(v1,v2...) and put breakpoint cmd.commandText and test it sql server window .

Posted 1-May-11 19:08pm

LakshmiNarayana Nalluri