fileupload control in asp.net..

Question

this is my task..when we select excel file help of fileuploader that file save into the database..plzsend me .cs code as soon as possible..

Raja T · Answer

Hi, Please checkout bellow urls   http://www.c-sharpcorner.com/UploadFile/ee01e6/how-to-send-mail-by-using-sql-server-part-2/    http://www.c-sharpcorner.com/UploadFile/sourabh_mishra1/sending-an-e-mail-using-Asp-Net-with-C-Sharp/   http://www.c-sharpcorner.com/UploadFile/0ef46a/send-email-in-sql-server/

jamal basha · Answer

SELECT TOP 1000 [clientid] ,[clientmail] FROM [test].[dbo].[droppedmails] and
that is my task when we have select file into fileuploader then values are insert into table as droppedmails..plz solve as sson as possible..

jamal basha · Answer

SELECT TOP 1000 [clientid] ,[clientmail] FROM [test].[dbo].[droppedmails] and
that is my task when we have select file into fileuploader then values are insert into table as droppedmails..plz solve as sson as possible..

jamal basha · Answer

SELECT TOP 1000 [clientid] ,[clientmail] FROM [test].[dbo].[droppedmails] and
that is my task when we have select file into fileuploader then values are insert into table as droppedmails..plz solve as sson as possible..

Supreeth J · Answer

protected void Page_Load(object sender, EventArgs e) { rndvalue = rnd.Next(1000, 9999); //Random Value to Save file name, else existing name file file will replaced }     protected void Button1_Click (object sender, EventArgs e) { string ext = System.IO.Path.GetExtension( FileUpload1 .PostedFile.FileName); string filename="Documents" + "\" + "_" + rndvalue.ToString() + ext; string filepath = Server.MapPath(filename); FileUpload1 .SaveAs(filepath); if( FileUpload1 .PostedFile.FileName!="") { foreach (HttpPostedFile postedFile in FileUpload1 .PostedFiles) { query = "insert into Documents(DocName,trvl_id,description)values('" + filename + "'," + Request.QueryString["docid"] + ",'" + txtdes.Text + "')"; //Query To Save In Database num = obj.insertsql(query); //Class Base Code to execute query if (num > 0) { lblmsg2.Text = "File uploaded Successfully"; display(); } else { lblmsg2.Text = "Failed"; } } } else { lblmsg2.Text = "No file Choosen"; } }

Upendra Pratap Shahi · Answer

Hello jamal basha,   Kindly go through below link-    http://www.c-sharpcorner.com/UploadFile/77a82c/binding-image-with-gridview-and-update-image-in-gridview/   kindly mark answer as accepted .

Raja T · Answer

Please check out excel file upload:
http://www.c-sharpcorner.com/UploadFile/0c1bb2/uploading-and-downloading-excel-files-from-database-using-as/

Raja T · Answer

Hi, Please refer bellow urls   http://www.c-sharpcorner.com/uploadfile/puranindia/the-fileupload-control/     http://www.aspsnippets.com/Articles/Save-Files-to-SQL-Server-Database-using-FileUpload-Control.aspx   http://www.codeproject.com/Articles/308552/Upload-and-Download-Files-to-SQL-Servers-in-ASP-Ne