Error Converting nvarchar to int

Usha Raj

11y1.7k

Am trying to add the table column value into another table ,the column data type is varchar(.i.e QQ20150001),but while adding into another table am getting the error like "Error Converting nvarchar to int"

my code is:

page.DAL

public void SaveData(string JobTitle, string RequiredExp,string JobLocation,int RegistrationId,string RequirementId)

{

SqlConnection con = dbcon.OpenCoonection( );

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

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add("@JobTitle", JobTitle);

cmd.Parameters.Add("@RequiredExp", RequiredExp);

cmd.Parameters.Add("@JobLocation", JobLocation);

cmd.Parameters.AddWithValue("@RegId", RegistrationId);

cmd.Parameters.Add("@RequirementId", RequirementId);// Am getting the this value from other table by using session

cmd.ExecuteNonQuery();

dbcon.CloseConnection();

}

Can any one tell me what's going wrong?

20 Replies

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

Deepak Saini11y ago
Dear Usha,

if u get Error your make conversion on the insert time.
0
Usha Raj11y ago
No I can't because am concatenating with string ,date and int,so while creating table by using query it won't accept,after creation of table that column data type we can't change
0
Khargesh Rajput11y ago
here do not have any datatype for RequirementId

set datatype as varchar(50)
0
Usha Raj11y ago
This is my table structutre
0
Khargesh Rajput11y ago
share your table structure
0
Usha Raj11y ago
If I change also no use,can u execute and check the design of table once
0
Khargesh Rajput11y ago
change datatype varchar(50)
0
Usha Raj11y ago
Sorry I didn't get u
0
Khargesh Rajput11y ago
varchar(50)
varchar datatype used with size
0
Usha Raj11y ago
I gave varchar only
0
Usha Raj11y ago
Yes,I know but am getting errror...I don't know what's going wrong
0
Khargesh Rajput11y ago
in database change column RequirementId datatype as varchar
0
Usha Raj11y ago
While creating the table am writing the query to store the Id "QQ201540001",The query like

create table tbl_ss(ReqId As cast('QQ'+cast(year(Getdate()) as varchar(10))
+cast(month(GetDate()) as varchar(10))
+RIGHT('000'+CAST(RowNum AS VARCHAR(3)),4) as varchar(30)) PERSISTED, rownum int identity(1,1))

this same value I want to add in other table,How I have to do ,can any one suggest me,
0
Usha Raj11y ago
Thnx for reply,In database the requirement Id is like "QQ201540001",so then how it'll become int
0
Khargesh Rajput11y ago
what datatype for RequirementId (integer) in database
set same datatype as in database and same pass from code behind

0
Usha Raj11y ago
Thanks for Quick replys Am getting the same error, after applying the above code
0
Gowtham Rajamanickam11y ago
// Add the input parameter and set its properties. SqlParameter parameter = new SqlParameter(); parameter.ParameterName = "@RegId"; parameter.SqlDbType = SqlDbType.NVarChar; parameter.Direction = ParameterDirection.Input; parameter.Value = RegistrationId.ToString(); // Add the parameter to the Parameters collection. cmd.Parameters.Add(parameter);
0
Pranay Rana11y ago
You can do this to avoid error , i.e. specify the type of input with the sql parameter that is the missing thing in your code

// Add the input parameter and set its properties.
SqlParameter parameter = new SqlParameter();
parameter.ParameterName = "@RegId";
parameter.SqlDbType = SqlDbType.NVarChar;
parameter.Direction = ParameterDirection.Input;
parameter.Value = RegistrationId.ToString();
// Add the parameter to the Parameters collection.
cmd.Parameters.Add(parameter);
0
Usha Raj11y ago
Yes,that's y I mentioned datatype like string
0
Tom Mohan11y ago
Hi Usha,

The problem is RequirementId has some string(not integer ). System will try to convert that to int. That will throw the error.
0