Comments by Member 13692796 (Top 1 by date)

Please help me on below as iam getting Implicit conversion from data type varchar to varbinary(max) is not allowed error

string strConn = string.Empty;
strConn = ConfigurationManager.ConnectionStrings["sqlConnection"].ConnectionString;
SqlConnection con = new SqlConnection(strConn);
con.Close();
if (imageupload.HasFile)
{
string strname = imageupload.FileName.ToString();
imageupload.PostedFile.SaveAs(Server.MapPath("~/Images/") + strname);
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "insert into Publications values('" + txtPublicationName.Text + "','" + strname + "')";

cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
con.Close();
lbltext.Visible = true;
lbltext.Text = "Image Uploaded successfully";
lbltext.Text = "";
}
else
{
lbltext.Visible = true;
lbltext.Text = "Plz upload the image!!!!";
}
con.Close();