Data is not saving in database, no error.

Question

0.00/5 (No votes)

See more:

1st table

SQL

CREATE TABLE [dbo].[Department] (
    [Dept_ID]   INT          IDENTITY (10, 10) NOT NULL,
    [Dept_Name] VARCHAR (50) NOT NULL,
    CONSTRAINT [PK_Department] PRIMARY KEY CLUSTERED ([Dept_ID] ASC),
    CONSTRAINT [FK_Department_Employee] FOREIGN KEY ([Dept_ID]) REFERENCES [dbo].[Department] ([Dept_ID])
);

2nd table

SQL

CREATE TABLE [dbo].[Employee] (
    [Dept_ID]   INT          NOT NULL,
    [Dept_Name] VARCHAR (50) NOT NULL,
    [Emp_ID]    INT          IDENTITY (1, 1) NOT NULL,
    [Emp_Name]  VARCHAR (50) NOT NULL,
    CONSTRAINT [PK_Employee] PRIMARY KEY CLUSTERED ([Emp_ID] ASC)
);

code-

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

namespace Data_Grid1
{
public partial class Employee : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("Insert into Employee (Dept_ID, Dept_Name, Emp_Name) Select Dept_ID, Dept_Name, @Emp_Name from Department WHERE Dept_Name = @Dept_Name", con);
cmd.Parameters.AddWithValue("@Emp_Name", txtName.Text.Trim());
cmd.Parameters.AddWithValue("@Dept_Name", ddlDeptName.SelectedValue);
cmd.ExecuteNonQuery();
con.Close();

}
}
}

Posted 24-Aug-15 20:41pm

Rohitk2409

Add a Solution

Comments

Sarath kumar.N 25-Aug-15 2:51am

What SQL query actually you have written?

Rohitk2409 25-Aug-15 2:55am

Insert into Employee (Dept_ID, Dept_Name, Emp_Name) Select Dept_ID, Dept_Name, @Emp_Name from Department WHERE Dept_Name = @Dept_Name

Sarath kumar.N 25-Aug-15 3:06am

Actually you have written a query for inserting multiple records right?

Rohitk2409 25-Aug-15 3:37am

yes, i want to insert data in employee table but data is not inserting in table

Sarath kumar.N 25-Aug-15 3:39am

Did u tried below solution?

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

Sarath kumar.N · Accepted Answer · 2015-08-24T21:16:00

Try this.

C#

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

namespace Data_Grid1
{
    public partial class Employee : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
        }
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString);
            con.Open();
            string Dept_Name = ddlDeptName.SelectedItem.Text;
            SqlCommand cmd = new SqlCommand("Insert into Employee (Dept_ID, Dept_Name, Emp_Name) Select Dept_ID, Dept_Name, @Emp_Name from Department WHERE Dept_Name = '"+ Dept_Name + "'", con);
            cmd.Parameters.AddWithValue("@Emp_Name", txtName.Text.Trim());            
            cmd.ExecuteNonQuery();
            con.Close();

        }
    }
}

Arasappan · Accepted Answer · 2015-08-24T21:30:00

Solution 2

cmd.Parameters.AddWithValue("@Dept_Name", ddlDeptName.SelectedItem.Text);

Posted 24-Aug-15 21:30pm

Arasappan

Comments

Rohitk2409 25-Aug-15 3:45am

nothing happened, data is still not saved

Rohitk2409 25-Aug-15 4:07am

thank You data is now saved

Mayank Vashishtha 25-Aug-15 4:17am

If it is solved. Please Mark it as Solved.

Rohitk2409 25-Aug-15 4:25am

how will I mark that it is solved?

Arasappan 25-Aug-15 5:08am

Keep on trying Rohitk

Rohitk2409 25-Aug-15 5:17am

its done So_Keeee thnku :)

aarif moh shaikh · Accepted Answer · 2015-08-24T21:55:00

Try This..

C#

protected void btnSubmit_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("Insert into Employee (Dept_ID, Dept_Name, Emp_Name) Select Dept_ID, Dept_Name,'" + txtName.Text.Trim() + "' from Department WHERE Dept_Name = '"+ ddlDeptName.SelectedItem.Value +"'", con);

cmd.ExecuteNonQuery();
con.Close();

}

F-ES Sitecore · Accepted Answer · 2015-08-24T22:10:00

WHERE Dept_Name = @Dept_Name

This is returning no matches, so there is nothing in Dept_Name that matches what is in your @Dept_Name param. We don't know what is in your Dept_Name param and we don't know what is in your data, so apart from telling you this there is little more we can do. Either what you think is in your variable isn't, or what you think is in your data isn't, you have to examine your variables and your data and try and work it out.

Data is not saving in database, no error.

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0