Error converting data type nvarchar to int.

Source Error:

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

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

 Line 43:             CMD.ExecuteNonQuery();

 Line 44:             con.Close();

Line 45:

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

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

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)

{

}

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

CREATE DATABASE BAJAJ

USE BAJAJ

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 int,

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 int,

@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

I want to know the actual solution of this error. I'll b greatful to u if u kindly help me.

1 Reply

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

Pradip Pandey12y ago
Hi Saha,
This error 'Error converting data type nvarchar to int.' comes due to datatype mismatch. In your code, MobileNo is int (integer type) but from the application you are sending values as string i.e. CMD.Parameters.AddWithValue("@MobileNo", txt_Mobile.Text);
So you will have to cast this from string to int.

Hope this will help you.