parameter '@Qualification_name', which was not supplied

Procedure or function 'SP_Qualification_insert' expects parameter '@Qualification_name', which was not supplied.

I am trying to add Qualification name from my Qualification_add page to Candidate_add bt data binding. but i unable to creat. please help me to complete my pages. All pages are given below....please give me solution as soon as possible

CANDIDATE_ADD PAGE

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Candidate_Add.aspx.cs" Inherits="Candidate_Candidate_Add" %>

Candidate Name :
Profile :
E-mail :
Gender :
Qualification :
DOB :
Mobile No. :
Current Salary :
Current Company :
Experience :
Reference Name :
Resume Upload :

.............................................................................

CANDIDATE_ADD.ASPX.CS PAGE

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.IO;

using System.Data.SqlClient;

using System.Configuration;

public partial class Candidate_Candidate_Add : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connection"].ConnectionString);

protected void Page_Load(object sender, EventArgs e)

{

Fill_Qualification();

Fill_Profile();

}

public void Fill_Profile()

{

con.Open();

SqlCommand cmd = new SqlCommand("SP_profile_insert", con);

cmd.CommandType = CommandType.StoredProcedure;

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

ddl_Profile.DataTextField = "profile_name";

ddl_Profile.DataTextField = "profile_id";

ddl_Profile.DataBind();

con.Close();

}

public void Fill_Qualification()

{

con.Open();

SqlCommand CMD = new SqlCommand("SP_Qualification_insert", con);

CMD.CommandType = CommandType.StoredProcedure;

SqlDataAdapter da = new SqlDataAdapter(CMD);

DataSet ds = new DataSet();

da.Fill(ds);

ddl_Qualification.DataTextField = "Qualification_name";

ddl_Qualification.DataTextField = "Qualification_id";

ddl_Qualification.DataSource = ds;

ddl_Qualification.DataBind();

con.Close();

}

protected void btn_Submit_Click(object sender, EventArgs e)

{

con.Open();

int Exp = int.Parse(ddl_year.SelectedValue) * 12 + int.Parse(ddl_months.SelectedValue);

string fileName = Path.GetFileName(fu_resume.PostedFile.FileName);

string Location = Server.MapPath("Resume" + "\\" + fileName);

fu_resume.SaveAs(Location);

SqlCommand CMD = new SqlCommand("SP_Candidate_insert", con);

CMD.CommandType = CommandType.StoredProcedure;

CMD.Parameters.AddWithValue("@CandidateName", txt_Candidate_Name.Text);

CMD.Parameters.AddWithValue("@CandidateProfile", ddl_Profile.SelectedValue);

CMD.Parameters.AddWithValue("@Email", txt_Email.Text);

CMD.Parameters.AddWithValue("@Gender", rdb_Gender.SelectedValue);

CMD.Parameters.AddWithValue("@Qualification", ddl_Qualification.SelectedValue);

CMD.Parameters.AddWithValue("@DOB", txt_dob.Text);

CMD.Parameters.AddWithValue("@MobileNo", txt_Mobile.Text);

CMD.Parameters.AddWithValue("@CurrentSalary", txt_CurrentSalary.Text);

CMD.Parameters.AddWithValue("@CurrentCompany", txt_CurrentCompany.Text);

CMD.Parameters.AddWithValue("@Experience", Exp);

CMD.Parameters.AddWithValue("@ReferenceName", txt_referenceName.Text);

CMD.Parameters.AddWithValue("@FileUpload", fileName);

CMD.ExecuteNonQuery();

con.Close();

}

..........................................................

WEB CONFIG

'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

DATABASE FOR CANDIDATE PAGE

CREATE DATABASE CONSULTANCY

USE CONSULTANCY

Create Table Candidate

(

Candidate_ID int primary key identity(1,1),

CandidateName nvarchar(50),

CandidateProfile int,

Email nvarchar(50),

Gender int,

Qualification int,

DOB nvarchar(50),

MobileNo nvarchar(50),

CurrentSalary nvarchar(50),

CurrentCompany nvarchar(50),

Experience int,

ReferenceName nvarchar(50),

QualityRate int,

ClosingRate int,

IsDelete int default 0,

FileUpload nvarchar(max)

)

create proc SP_Candidate_insert

(

@CandidateName nvarchar(50),

@CandidateProfile int,

@Email nvarchar(50),

@Gender int,

@Qualification int,

@DOB nvarchar(50),

@MobileNo nvarchar(50),

@CurrentSalary nvarchar(50),

@CurrentCompany nvarchar(50),

@Experience int,

@ReferenceName nvarchar(50),

@FileUpload nvarchar(max)

)

begin

insert into Candidate( CandidateName, CandidateProfile, Email, Gender, Qualification, DOB, MobileNo, CurrentSalary, CurrentCompany, Experience, ReferenceName, FileUpload )

values(@CandidateName,@CandidateProfile, @Email, @Gender, @Qualification, @DOB, @MobileNo, @CurrentSalary, @CurrentCompany, @Experience, @ReferenceName, @FileUpload )

end

select * from Candidate

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,........................,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,......................

QUALIFICATION_ADD PAGE

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Qualification_Add.aspx.cs" Inherits="Admin_Qualification_Add" %>

Qualification :

,,,,,,,,,,,,,,,,,,.......................................,,,,,,,,,,,,,,,,,,,,,,,..........................

QUALIFICATION_ADD.ASPX.CS PAGE

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.IO;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

public partial class Admin_Qualification_Add : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connection"].ConnectionString);

protected void Page_Load(object sender, EventArgs e)

{

}

protected void btn_save_Click(object sender, EventArgs e)

{

con.Open();

SqlCommand cmd = new SqlCommand("SP_Qualification_insert", con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@Qualification_name", txt_Qualification.Text);

cmd.ExecuteNonQuery();

con.Close();

}

DATABASE FOR QUALIFICATION

create table Qualification

( Qualification_id int primary key identity(1,1),

Qualification_name nvarchar(50),

IsDelete int default 0

)

create proc SP_Qualification_insert

(

@Qualification_name nvarchar(50)

)

begin

insert into Qualification (Qualification_name) values (@Qualification_name)

end

select * from Qualification

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,............................................

PROFILE_ADD PAGE

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Profile_Add.aspx.cs" Inherits="Admin_Profile_Add" %>

Profile Name :
	ondatabinding="btn_save_DataBinding" />

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

PROFILE_ADD.ASPX.CS

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.Configuration;

using System.Data;

using System.IO;

public partial class Admin_Profile_Add : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connection"].ConnectionString);

protected void Page_Load(object sender, EventArgs e)

{

}

protected void btn_save_Click(object sender, EventArgs e)

{

con.Open();

SqlCommand cmd = new SqlCommand("SP_profile_insert", con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@profile_name ", txt_profile.Text);

cmd.ExecuteNonQuery();

con.Close();

}

protected void btn_save_DataBinding(object sender, EventArgs e)

{

}

........................................DATABASE

use CONSULTANCY

create table profile

( profile_id int primary key identity(1,1),

profile_name nvarchar(50),

IsDelete int default 0

)

create proc SP_profile_insert

(

@profile_name nvarchar(50)

)

begin

insert into profile (profile_name) values (@profile_name)

end

select * from profile

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Khan Abrar Ahmed12y ago
Hi you can try below code while insert the Qualification code

using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["connection"].ConnectionString))
{
SqlCommand cmd = new SqlCommand("SP_Qualification_insert", connection );
command.Parameters.Add("@Qualification_name", SqlDbType.string);
command.Parameters["@Qualification_name"].Value = txt_Qualification.Text;

try
{
connection.Open();
Int32 rowsAffected = command.ExecuteNonQuery();

}
catch (Exception ex)
{

}
}
}