I got the following error while insert value in the database
Failed to convert parameter value from a SqlParameter to a String.
cmd = new SqlCommand("insert into user_senditem(user_senditem_id,username,user_id,department_id,attached_files,subject,message,compl_nature,compl_type,group_id,apartment_id,area_id,date_time,type,created_on,created_by,Image) values(@usendid,@username,@userid,@deptid,@attached,@subject,@message,@cmplnature,@comptype,@groupid,@apartmentid,@areaid,@datetime,@type,@createdon,@createdby,@image2)", conn);
SqlParameter usendid = new SqlParameter("@usendid", SqlDbType.VarChar, 50);
usendid.Value = txtUserSentId.Text;
cmd.Parameters.Add(usendid);
SqlParameter username = new SqlParameter("@username ", SqlDbType.VarChar, 50);
username.Value = Session["username"];
cmd.Parameters.Add(username);
SqlParameter userid = new SqlParameter("@userid", SqlDbType.VarChar, 50);
userid.Value = Session["id"];
cmd.Parameters.Add(userid);
SqlParameter deptid = new SqlParameter("@deptid", SqlDbType.VarChar, 50);
deptid.Value = "Admin";
cmd.Parameters.Add(deptid);
SqlParameter attached = new SqlParameter("@attached", SqlDbType.VarChar, 50);
attached.Value = uploadedDocument;
cmd.Parameters.Add(attached);
SqlParameter subject = new SqlParameter("@subject", SqlDbType.VarChar, 50);
subject.Value = txtSubject.Text;
cmd.Parameters.Add(subject);
SqlParameter message = new SqlParameter("@message", SqlDbType.VarChar, 300);
message.Value = txtMessage.Text;
cmd.Parameters.Add(message);
SqlParameter cmplnature = new SqlParameter("@cmplnature", SqlDbType.VarChar, 50);
cmplnature.Value = "Complaint";
cmd.Parameters.Add(cmplnature);
SqlParameter comptype = new SqlParameter("@comptype", SqlDbType.VarChar, 50);
comptype.Value = ddl_ComplType.SelectedItem;
cmd.Parameters.Add(comptype);
SqlParameter groupid = new SqlParameter("@groupid", SqlDbType.VarChar, 50);
groupid.Value = Session["group_id"];
cmd.Parameters.Add(groupid);
SqlParameter apartmentid = new SqlParameter("@apartmentid", SqlDbType.VarChar, 50);
apartmentid.Value = Session["apartment_id"];
cmd.Parameters.Add(apartmentid);
SqlParameter areaid = new SqlParameter("@areaid", SqlDbType.VarChar, 50);
areaid.Value = Session["area_id"];
cmd.Parameters.Add(areaid);
SqlParameter datetime = new SqlParameter("@datetime", SqlDbType.DateTime);
datetime.Value = lblDatetime.Text;
cmd.Parameters.Add(datetime);
SqlParameter type = new SqlParameter("@type", SqlDbType.VarChar, 50);
type.Value = "N";
cmd.Parameters.Add(type);
SqlParameter createdon = new SqlParameter("@createdon", SqlDbType.VarChar, 50);
createdon.Value = DateTime.Now;
cmd.Parameters.Add(createdon);
SqlParameter createdby = new SqlParameter("@createdby", SqlDbType.VarChar, 50);
createdby.Value = SystemInformation.UserName;
cmd.Parameters.Add(createdby);
SqlParameter image2 = new SqlParameter("@image2", SqlDbType.Binary, filelen);
image2.Value = buffer;
cmd.Parameters.Add(image2);
cmd.ExecuteNonQuery();