reading a file

//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)");

}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

siva kumar16y ago
//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)");


   }

   }