asp.net c#.no mapping exists whether my code is correct

krish sin

9y1.1k

asp.net c#.No mapping exists from object type System.Web.UI.WebControls.FileUpload to a known managed provider native type

this the error..

how to debug

this is the code :

protected void Page_Load(object sender, EventArgs e) {   } protected void btn_insrt_Click(object sender, EventArgs e) { try { SqlConnection con = new SqlConnection("Data Source=SYSTEM-6-PC;Initial Catalog=HRMS;Integrated Security=True");         con.Open(); FileUpload img = (FileUpload)imgUpload; Byte[] imgByte = null; if (img.HasFile && img.PostedFile != null) { //To create a PostedFile HttpPostedFile File = imgUpload.PostedFile; //Create byte Array with file len             imgByte = new Byte[File.ContentLength]; //force the control to load data in array File.InputStream.Read(imgByte, 0, File.ContentLength); } SqlCommand cmd = new SqlCommand("INSERT INTO HR_information([HRName],[HRCode],[Designation],[Department],[Qulification],[DateOfBirth]" + ",[Phone],[Mobile],[MaritalStatus] ,[Email] ,[ZipCode],[Address] ,[Street],[City] ,[State] ,[Country],[Photo],[PassportNo]) VALUES (@HRName,@HRCode,@Designation,@Department,@Qulification,@DateOfBirth" + ", @Phone,@Mobile,@MaritalStatus,@Email @ZipCode,@Address,@Street,@City,@State,@Country,,@eimg,@ PassportNo)", con);          cmd.Parameters.AddWithValue("@HRName", txt_name.Text);         cmd.Parameters.AddWithValue("@HRCode", txt_code.Text);         cmd.Parameters.AddWithValue("@Designation", drpdwn_desig.SelectedItem.ToString());         cmd.Parameters.AddWithValue("@Department", drpdwn_dept.SelectedItem.ToString());         cmd.Parameters.AddWithValue("@Qulification", txt_qual.Text);         cmd.Parameters.AddWithValue("@DateOfBirth", txt_dob.Text);         cmd.Parameters.AddWithValue(" @Phone", txt_phn.Text);         cmd.Parameters.AddWithValue("@Mobile", txt_mob.Text);         cmd.Parameters.AddWithValue("@MaritalStatus", Dropdownmatrialstatus.SelectedItem.ToString());         cmd.Parameters.AddWithValue("@Email", txt_email.Text);         cmd.Parameters.AddWithValue("@ZipCode", txt_zip.Text);         cmd.Parameters.AddWithValue("@Address", txt_addr.Text);         cmd.Parameters.AddWithValue("@Street", txt_str.Text);         cmd.Parameters.AddWithValue("@City", txt_cty.Text);         cmd.Parameters.AddWithValue("@State", drpdwn_state.SelectedItem.ToString());         cmd.Parameters.AddWithValue("@Country", txt_ctry.Text);         cmd.Parameters.AddWithValue(",@eimg", img);         cmd.Parameters.AddWithValue("@ PassportNo", txt_passportno.Text);          cmd.ExecuteNonQuery(); } catch (Exception) { }   }

}

2 Replies

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

Manas Mohapatra9y ago
You are getting error due to you are passing file upload control as SQLParameter. It needs to be byte array. Try with below code:
protected void Page_Load(object sender, EventArgs e) { }

protected void btn_insrt_Click(object sender, EventArgs e)
{
    try {
        SqlConnection con = new SqlConnection("Data Source=SYSTEM-6-PC;Initial Catalog=HRMS;Integrated Security=True");
        con.Open();

        SqlCommand cmd = new SqlCommand("INSERT INTO HR_information([HRName],[HRCode],[Designation],[Department],
        [Qulification],[DateOfBirth]" + ",[Phone],[Mobile],[MaritalStatus] ,[Email] ,[ZipCode],[Address] ,[Street],
        [City] ,[State] ,[Country],[Photo],[PassportNo]) VALUES
        (@HRName,@HRCode,@Designation,@Department,@Qulification,@DateOfBirth" + ", @Phone,@Mobile,@MaritalStatus,
        @Email @ZipCode,@Address,@Street,@City,@State,@Country,,@eimg,@ PassportNo)", con);
        cmd.Parameters.AddWithValue("@HRName", txt_name.Text);
        cmd.Parameters.AddWithValue("@HRCode", txt_code.Text);
        cmd.Parameters.AddWithValue("@Designation", drpdwn_desig.SelectedItem.ToString());
        cmd.Parameters.AddWithValue("@Department", drpdwn_dept.SelectedItem.ToString());
        cmd.Parameters.AddWithValue("@Qulification", txt_qual.Text);
        cmd.Parameters.AddWithValue("@DateOfBirth", txt_dob.Text);
        cmd.Parameters.AddWithValue(" @Phone", txt_phn.Text);
        cmd.Parameters.AddWithValue("@Mobile", txt_mob.Text);
        cmd.Parameters.AddWithValue("@MaritalStatus", Dropdownmatrialstatus.SelectedItem.ToString());
        cmd.Parameters.AddWithValue("@Email", txt_email.Text);
        cmd.Parameters.AddWithValue("@ZipCode", txt_zip.Text);
        cmd.Parameters.AddWithValue("@Address", txt_addr.Text);
        cmd.Parameters.AddWithValue("@Street", txt_str.Text);
        cmd.Parameters.AddWithValue("@City", txt_cty.Text);
        cmd.Parameters.AddWithValue("@State", drpdwn_state.SelectedItem.ToString());
        cmd.Parameters.AddWithValue("@Country", txt_ctry.Text);

        // Create a byte array to hold the contents of the file.
        byte[] input = new byte[imgUpload.PostedFile.ContentLength - 1];
        input = imgUpload.FileBytes;

        cmd.Parameters.AddWithValue("@eimg", input);
        cmd.Parameters.AddWithValue("@ PassportNo", txt_passportno.Text);
cmd.ExecuteNonQuery();
    }
    catch (Exception) { } }
}
Follow below link that may help you:

http://www.aspsnippets.com/Articles/How-to-save-insert-Image-in-Database-in-ASPNet-using-C-and-VBNet.aspx
Midhun Tp9y ago
Hi,

The issue will be on below line -
cmd.Parameters.AddWithValue(",@eimg", img);
I think you are passing image name to database?

If yes, then you should take image name from fileupload control and pass that value instead of fileupload itself.