How To Upload PDF IN Sql Server

Question

Please Check This Table Is Right Any think Worng Ask Me i Will Change

FileName Save To PDF Filename

Here Is My Store Proc Code Any Think Worng Tell Me

This Upload Button For PDF Any Think Worng Tell Me

I Need To PDF Save Code Here Please Give Me Code

I will Attach My Code For In Txt FIle

Arvind Yadav · Answer

protected void grvDisplayPdf_SelectedIndexChanged(object sender, EventArgs e) { string sPathToSaveFileTo = @"C:\SelectedFile.pdf"; // on this path i will create selected PDF File Data open pdf for checking //Read Connection from web config using (SqlConnection cn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["Connection"].ToString())) { cn.Open(); using (SqlCommand cmd = new SqlCommand("select PDFData from tblpdfdata where ID='" + grvDisplayPdf.SelectedValue + "' ", cn)) { using (SqlDataReader dr = cmd.ExecuteReader(System.Data.CommandBehavior.Default)) { if (dr.Read()) { // read in using GetValue and cast to byte array byte[] fileData = (byte[])dr.GetValue(0); // write bytes to disk as file using (System.IO.FileStream fs = new System.IO.FileStream(sPathToSaveFileTo, System.IO.FileMode.Create, System.IO.FileAccess.ReadWrite)) { // use a binary writer to write the bytes to disk using (System.IO.BinaryWriter bw = new System.IO.BinaryWriter(fs)) { bw.Write(fileData); bw.Close(); } } } // close reader to database dr.Close(); } } } } protected void btnSavePdf_Click(object sender, EventArgs e) { using (SqlConnection cn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["Connection"].ToString())) { cn.Open(); //Convert pdf in Binary formate int lenght = FileUpload1.PostedFile.ContentLength; byte[] data = new byte[lenght]; FileUpload1.PostedFile.InputStream.Read(data, 0, lenght); using (SqlCommand cmd = new SqlCommand("insert into tblPdfData " + "(PdfData) values(@data)", cn)) { cmd.Parameters.Add("@data", data); cmd.ExecuteNonQuery(); Response.Write("Pdf File Save in Dab"); } } }

Imtiyaz Ansari · Answer

Hi Shoaib Shamsuddin Try with the below reference link:- https://www.aspsnippets.com/Articles/Upload-and-Download-PDF-file-Database-in-ASPNet-using-C-and-VBNet.aspx https://www.c-sharpcorner.com/UploadFile/0c1bb2/uploading-and-downloading-pdf-files-from-database-using-asp/ https://www.codeproject.com/Articles/308552/Upload-and-Download-Files-to-SQL-Servers-in-ASP-Ne

Guest User · Answer

Arvind Yadav your Post Belong to Web upload PDF I Want TO Windos Applicattion