reading a file

Question

How to read a pdf file using c#.

siva kumar · Answer

//Upload ur pdf file fuUpload.SaveAs(Server.MapPath("~/Quality/") + fuUpload.FileName); //export from pdf file //Fetch data from Your File and display it into Datagrid o_Con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + Server.MapPath("~/Quality/Quality.pdf") + "';Extended Properties=Excel 8.0;"); o_Cmd = new OleDbCommand("Select * From [Quality$]", o_Con); o_Da.SelectCommand = o_Cmd; o_Con.Open(); o_Da.Fill(ds); dgDelivery.DataSource = ds; dgDelivery.DataBind(); //then save it in your database foreach (DataRow dr in ds.Tables[0].Rows) { if (dr[0].ToString() != string.Empty && dr[0].ToString() != null) { objDataAccess.ExcuteQuery("Insert Into tb_Quality(SupplierId,Month,Year,Recipt,Rejects,PPM,QRR,IMPR,TotalQRR,PPMRating,IMMRRating,QRRating,QRServity,Cert,PPAP,QPRRating,Date,Active) Values('" + dr[0].ToString() + "','" + dr[1].ToString() + "'," + dr[3].ToString() + "," + dr[4].ToString() + "," + dr[5].ToString() + "," + dr[6].ToString() + "," + dr[7].ToString() + "," + dr[8].ToString() + "," + dr[9].ToString() + "," + dr[10].ToString() + "," + dr[11].ToString() + "," + dr[12].ToString() + "," + dr[13].ToString() + "," + dr[14].ToString() + "," + dr[15].ToString() + "," + dr[16].ToString() + ",'" + DateTime.Now.ToString() + "',1)"); } }