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(SupplierIdMonthYearReciptRejectsPPMQRRIMPRTotalQRRPPMRatingIMMRRatingQRRatingQRServityCertPPAPQPRRatingDateActive) 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)); } }