How do Insert data to database using Asp.Net(C#)

Question

1.00/5 (1 vote)

See more:

the below code i have applied on button

C#

protected void Submit_Button_Click(object sender, EventArgs e)
       {
           string connString = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
           SqlConnection con = null;
           try
           {
               con = new SqlConnection(connString);
               using (SqlCommand cmd = new SqlCommand())
               {
                   cmd.Connection = con;
                   cmd.CommandType = CommandType.Text;
                   cmd.CommandText = "INSERT INTO  EmployeeProjects (ProjectId,EmployeeId,Date,NoOfPage,Deadline,IsDeleted,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy)values(@ProjectId,@EmployeeId,@Date,@NoOfPages,@Date,@Deadline,@IsActive,@CreatedOn,@CreatedBy,@UpdatedOn,@UpdatedBy)";
                   cmd.Parameters.AddWithValue("@ProjectId", ProjectId_TB.Text.Trim());
                   cmd.Parameters.AddWithValue("@EmployeeId", EmployeeId_TB.Text.Trim());
                    cmd.Parameters.AddWithValue("@Date", Date_TB.Text.Trim());
                   cmd.Parameters.AddWithValue("@NoOfPage", NoOfPages_TB.Text.Trim());

                   cmd.Parameters.AddWithValue("@Deadline", Deadline_TB.Text.Trim());

                   cmd.Parameters.AddWithValue("@CreatedOn", CreatedBy_TB.Text.Trim());
                   cmd.Parameters.AddWithValue("@CreatedBy", CreatedBy_TB.Text.Trim());
                   cmd.Parameters.AddWithValue("@UpdatedOn", UpdatedOn_TB.Text.Trim());
                   cmd.Parameters.AddWithValue("@UpdatedBy", UpdatedBy_TB.Text.Trim());
                   cmd.Parameters.AddWithValue("@IsDeleted", IsDeleted_TB.Text.Trim());
                   int rowsAffected = cmd.ExecuteNonQuery();
                   if (rowsAffected == 1)
                   {
                       Label1.Text = "registered successful.";
                   }
                   else
                   {
                       //Error notification
                   }

               }
           }
           catch (Exception ex)
           {
               //log error
               //display friendly error to user
           }
           finally
           {
               if (con != null)
               {
                   //cleanup connection i.e close
               }
           }
       }

and this is my Connection string

XML

<connectionStrings>
        <add name="conString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=D:\Amplits\CelebralProspectus\AssignProject\AssignProject\App_Data\celebral.mdf;Integrated Security=True;User Instance=True"/></connectionStrings>

Posted 20-Mar-14 7:17am

ramshamuzaffer

Updated 20-Mar-14 7:22am

v2

Add a Solution

Comments

Richard C Bishop 20-Mar-14 13:18pm

But what?

ramshamuzaffer 20-Mar-14 13:21pm

but not inserting data Richard

JoCodes 20-Mar-14 13:23pm

But? then what happened?

ramshamuzaffer 20-Mar-14 13:25pm

nothing .. :/ screen remain as it is .. it is not giving any error :/

JoCodes 20-Mar-14 13:34pm

Have tried to debug the code?

5 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)

Abhinav S · Answer 1 · 2014-03-20T07:31:00

Solution 1

Run the same query in Sql Server Studio and check if a record inserts or not.
That should give you an idea if this is an error with your query.

Posted 20-Mar-14 7:31am

Abhinav S

Mr.VJ · Answer 2 · 2014-03-20T18:46:00

check your parameters correctly
@IsActive , @IsDeleted

C#

cmd.CommandText = "INSERT INTO  EmployeeProjects (ProjectId,EmployeeId,Date,NoOfPage,Deadline,IsDeleted,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy)values(@ProjectId,@EmployeeId,@Date,@NoOfPages,@Date,@Deadline,@IsActive,@CreatedOn,@CreatedBy,@UpdatedOn,@UpdatedBy)";
                   
Checkout here above You have taken @IsActive instead of @IsDeleted

cmd.Parameters.AddWithValue("@ProjectId", ProjectId_TB.Text.Trim());
                   cmd.Parameters.AddWithValue("@EmployeeId", EmployeeId_TB.Text.Trim());
                    cmd.Parameters.AddWithValue("@Date", Date_TB.Text.Trim());
                   cmd.Parameters.AddWithValue("@NoOfPage", NoOfPages_TB.Text.Trim());
 
                   cmd.Parameters.AddWithValue("@Deadline", Deadline_TB.Text.Trim());
 
                   cmd.Parameters.AddWithValue("@CreatedOn", CreatedBy_TB.Text.Trim());
                   cmd.Parameters.AddWithValue("@CreatedBy", CreatedBy_TB.Text.Trim());
                   cmd.Parameters.AddWithValue("@UpdatedOn", UpdatedOn_TB.Text.Trim());
                   cmd.Parameters.AddWithValue("@UpdatedBy", UpdatedBy_TB.Text.Trim());
                   cmd.Parameters.AddWithValue("@IsDeleted", IsDeleted_TB.Text.Trim());

Aravindba · Answer 3 · 2014-03-20T20:21:00

Solution 5

Hai
Did u check ur code with break point ? if u click Submit_Button it fire Submit_Button_Click event,i mean break point goes inside of Submit_Button_click ? try to change ur button name as Submit,don't give underscore for ur button name.

Posted 20-Mar-14 20:21pm

Aravindba

Richard Deeming · Answer 4 · 2014-03-20T07:33:00

You need to Open() the connection before you can ExecuteNonQuery() the command.

C#

using (SqlConnection con = new SqlConnection(connString))
using (SqlCommand cmd = new SqlCommand())
{
    cmd.Connection = con;
    cmd.CommandType = CommandType.Text;
    cmd.CommandText = "INSERT INTO  EmployeeProjects (ProjectId, EmployeeId, Date, NoOfPage, Deadline, IsDeleted, CreatedOn, CreatedBy, UpdatedOn, UpdatedBy) values (@ProjectId, @EmployeeId, @Date, @NoOfPages, @Date, @Deadline, @IsActive, @CreatedOn, @CreatedBy, @UpdatedOn, @UpdatedBy)";
    cmd.Parameters.AddWithValue("@ProjectId", ProjectId_TB.Text.Trim());
    cmd.Parameters.AddWithValue("@EmployeeId", EmployeeId_TB.Text.Trim());
    cmd.Parameters.AddWithValue("@Date", Date_TB.Text.Trim());
    cmd.Parameters.AddWithValue("@NoOfPage", NoOfPages_TB.Text.Trim());
    cmd.Parameters.AddWithValue("@Deadline", Deadline_TB.Text.Trim());
    cmd.Parameters.AddWithValue("@CreatedOn", CreatedBy_TB.Text.Trim());
    cmd.Parameters.AddWithValue("@CreatedBy", CreatedBy_TB.Text.Trim());
    cmd.Parameters.AddWithValue("@UpdatedOn", UpdatedOn_TB.Text.Trim());
    cmd.Parameters.AddWithValue("@UpdatedBy", UpdatedBy_TB.Text.Trim());
    cmd.Parameters.AddWithValue("@IsDeleted", IsDeleted_TB.Text.Trim());  
    
    con.Open();
    int rowsAffected = cmd.ExecuteNonQuery();
    ... 
}

Richard C Bishop · Answer 5 · 2014-03-20T07:42:00

In addition to Solution #2, I would change your using statement to:

using (SqlConnection con = new SqlConnection(connString))
{
    SqlCommand cmd = new SqlCommand();
    cmd.Connection = con;
    cmd.CommandType = CommandType.Text;
    cmd.CommandText = "INSERT INTO  EmployeeProjects (ProjectId, EmployeeId, Date, NoOfPage, Deadline, IsDeleted, CreatedOn, CreatedBy, UpdatedOn, UpdatedBy) values(@ProjectId, @EmployeeId, @Date, @NoOfPages, @Date, @Deadline, @IsActive, @CreatedOn, @CreatedBy, @UpdatedOn, @UpdatedBy)";
    cmd.Parameters.AddWithValue("@ProjectId", ProjectId_TB.Text.Trim());
    cmd.Parameters.AddWithValue("@EmployeeId", EmployeeId_TB.Text.Trim());
    cmd.Parameters.AddWithValue("@Date", Date_TB.Text.Trim());
    cmd.Parameters.AddWithValue("@NoOfPage", NoOfPages_TB.Text.Trim());
    cmd.Parameters.AddWithValue("@Deadline", Deadline_TB.Text.Trim());
    cmd.Parameters.AddWithValue("@CreatedOn", CreatedBy_TB.Text.Trim());
    cmd.Parameters.AddWithValue("@CreatedBy", CreatedBy_TB.Text.Trim());
    cmd.Parameters.AddWithValue("@UpdatedOn", UpdatedOn_TB.Text.Trim());
    cmd.Parameters.AddWithValue("@UpdatedBy", UpdatedBy_TB.Text.Trim());
    cmd.Parameters.AddWithValue("@IsDeleted", IsDeleted_TB.Text.Trim());  
    
    con.Open();
    int rowsAffected = cmd.ExecuteNonQuery();

}

This is done so that your connection is closed after the application leaves the scope of the using statement.

I would recommend adding a space after the closing parenthesis of the column names in your insert statement and "values":

cmd.CommandText = "INSERT INTO  EmployeeProjects (ProjectId, EmployeeId, Date, NoOfPage, Deadline, IsDeleted, CreatedOn, CreatedBy, UpdatedOn, UpdatedBy) values(@ProjectId, @EmployeeId, @Date, @NoOfPages, @Date, @Deadline, @IsActive, @CreatedOn, @CreatedBy, @UpdatedOn, @UpdatedBy)";

How do Insert data to database using Asp.Net(C#)

5 solutions

Solution 1

Solution 4

Solution 5

Solution 2

Solution 3

Add your solution here

Preview 0