Change the code from old to new

Question

string text1 = this.FileUploadFront.FileName; string str8 = this.Session["ProductIDA"].ToString(); this.Ade = this.Session["ProductIDA"].ToString(); if (this.FileUploadplotfullP.HasFile) { string filename = base.Request.PhysicalApplicationPath.ToString() + ConfigurationManager.AppSettings["UploadSlidePhotoPath"].ToString(); string str10 = str8 + str5; filename = filename + str10; this.FileUploadFront.SaveAs(filename); str = "SlidePhoto/" + str10; ConfigurationManager.ConnectionStrings["ConnectionString"].ToString(); connection = new SqlConnection(this.strConnectionstring); connection.Open(); this.cmd = new SqlCommand("update TBL_PRODUCTDETAILS Set PhotoFront='" + str + "' where ID ='" + str8 + "' ", connection); this.cmd.ExecuteNonQuery(); }      --I have this previous code and i want to change like this code as following   try { Byte[] bytes = null; if (FileUpload1.HasFile) { string filename = FileUpload1.PostedFile.FileName; string filePath = Path.GetFileName(filename); Stream fs = FileUpload1.PostedFile.InputStream; BinaryReader br = new BinaryReader(fs); bytes = br.ReadBytes((Int32)fs.Length); } using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString)) { SqlCommand command = new SqlCommand( "INSERT INTO tblImage (ImageName, Image) " + "Values(@ImageName, @Image)", con); command.Parameters.Add("@ImageName", SqlDbType.NVarChar, 20).Value = txtImageName.Text; command.Parameters.Add("@Image", SqlDbType.Binary).Value = bytes; con.Open(); command.ExecuteNonQuery(); } } catch (Exception) { //error } }

Suvendu Shekhar Giri · Answer

so, what is the issue?

Gnanavel Sekar · Answer

Here is no error in your code, What's the error you are getting? , if still getting error means use my green code    try { Byte[] bytes = null; if (FileUpload1.HasFile) {   string filename = FileUpload1.PostedFile.FileName; FileStream fs = new FileStream( filename , FileMode.Open, FileAccess.Read); BinaryReader br = new BinaryReader(fs); bytes = br.ReadBytes((Int32)fs.Length); br.Close(); fs.Close(); } using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString)) { SqlCommand command = new SqlCommand( "INSERT INTO tblImage (ImageName, Image) " + "Values(@ImageName, @Image)", con); command.Parameters.Add("@ImageName", SqlDbType.NVarChar, 20).Value = txtImageName.Text; command.Parameters.Add("@Image", SqlDbType.Binary).Value = bytes; con.Open(); command.ExecuteNonQuery(); } } catch (Exception) { //error } }

Shahbaz Kaware · Answer

i want to insert new imeges in only databse not in other folder

Jitendra Shekhawat · Answer

Please Show Your Error Msg....