forum

Home / DeveloperSection / Forums / Conversion failed when converting the nvarchar value 'meetingId' to data type int

Conversion failed when converting the nvarchar value 'meetingId' to data type int

Anonymous User 2392 15-Apr-2015

I have a dropdownlist and I am trying to insert the DataValueField into a database table. The DataValueField is retrieved from the database and the data type for the column is INT. However, when the run the query I get this error message 

Conversion failed when converting the nvarchar value 'meetingId' to data type int.

Code: 

if (MinuteUpload.HasFile)
{
    string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
 
    string updateSql = "UPDATE Project_Meeting SET meetingMinute = @meetingMinute WHERE meetingId = @MeetingId"; ;
 
    using (SqlConnection myConnection = new SqlConnection(connectionString))
    {
        myConnection.Open();
 
        SqlCommand myCommand = new SqlCommand(updateSql, myConnection);
 
        myCommand.Parameters.AddWithValue("@meetingMinute", "postUpload/" + filename);
        myCommand.Parameters.AddWithValue("@MeetingId", MinuteDropDown.DataValueField);
 
        myCommand.ExecuteNonQuery();
 
        myConnection.Close();
    }
}

However, when I try

 

Convert.ToIint.TryParse16(MinuteDropDown.DataValueField.Trim())

I get this error:

 

Input string was not in a correct format.


.net c# 
Updated on 15-Apr-2015
I am a content writter !

Can you answer this question?


Answer

1 Answers

Liked By