upload and delete image

Question

hiii How to upload image to folder as well as database also and How to delete image from folder as well as database also using two buuton i.e upload and delete button? using asp.net ,c# language

Raj Kumar · Answer

see this also... http://www.developerstation.org/2009/04/upload-images-onto-sql-server-using.html

Raj Kumar · Answer

protected void btndelete_Click(object sender, EventArgs e) { string connectionString = WebConfigurationManager.ConnectionStrings["connectionString"].ConnectionString; string filename = FileUpload1.FileName; FileUpload1.PostedFile.Equals(Server.MapPath("~\Uploads\" + filename)); string path = "~\Uploads\" + filename; SqlConnection cnn = new SqlConnection(connectionString); try { cnn.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "delete from emp "; cmd.CommandType = CommandType.Text; cmd.Connection = cnn; cmd.ExecuteNonQuery(); if (File.Exists(path)) { File.Delete(path); } cnn.Close(); } catch (Exception ex) { Response.Write(ex.ToString()); } finally { lblinfo2.Text = ""; lblinfo2.Text= " Deleted Successfully "; } } protected void btnUpload_Click(object sender, EventArgs e) { Stream imgStream = fuImage.PostedFile.InputStream; int imgLen = fuImage.PostedFile.ContentLength; string imgName = txtImageName.Text; byte[] imgBinaryData = new byte[imgLen]; int n = imgStream.Read(imgBinaryData,0,imgLen); //use the web.config to store the connection string SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString); SqlCommand command = new SqlCommand("INSERT INTO Image (imagename,image) VALUES ( @img_name, @img_data)", connection); SqlParameter param0 = new SqlParameter("@img_name", SqlDbType.VarChar, 50); param0.Value = imgName; command.Parameters.Add(param0); SqlParameter param1 = new SqlParameter("@img_data", SqlDbType.Image); param1.Value = imgBinaryData; command.Parameters.Add(param1); connection.Open(); int numRowsAffected = command.ExecuteNonQuery(); connection.Close(); }

upload and delete image

Answers (2)