reading excel file in asp.net

void readexcel(String filename)
{
string connection = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source= " + Server.MapPath("test\\" + filename) + ";" + "Extended Properties=Excel 8.0;";
oledbcon = new OleDbConnection(connection);
oledbcon.Open();
try
{
oledbcom = new OleDbCommand("select * from [qryDistributionExportXLSPDNewPl$]", oledbcon);
oledbreader = oledbcom.ExecuteReader();

while (oledbreader.Read())
if (oledbreader.GetName(18).ToString() == "BaseProduct" && oledbreader.GetName(0).ToString() == "ApprovalCode" && oledbreader.GetName(1).ToString() == "ShortDescription" && oledbreader.GetName(5).ToString() == "ValidityFirstOrder" && oledbreader.GetName(6).ToString() == "ValidityLastOrder" && oledbreader.GetName(11).ToString() == "EclipseId" && oledbreader.GetName(17).ToString() == "ProductId" && oledbreader.GetName(24).ToString() == "DealerCost" && oledbreader.GetName(27).ToString() == "OrderMinimumQuantity")
{
sdescription = oledbreader["BaseProduct"].ToString();
if (sdescription == "Y")
{
ApprovalCode = oledbreader["ApprovalCode"].ToString();
description = oledbreader["ShortDescription"].ToString();
firstorder = oledbreader["ValidityFirstOrder"].ToString();
lastorder = oledbreader["ValidityLastOrder"].ToString();
eclipid = oledbreader["EclipseId"].ToString();
Pdutid = oledbreader["ProductId"].ToString();
Dcost =Convert.ToDouble(oledbreader["DealerCost"].ToString());
//Dcost = Convert.ToDecimal(oledbreader["DealerCost"].ToString());
MinQty = oledbreader["OrderMinimumQuantity"].ToString();
appdate = DateTime.Now.ToString();
string selectMarkuppercentage = "Select * from Markuppercentage where ItemCode='" + Pdutid + "' ";
// Response.Write(selectMarkuppercentage);
// Response.End();
if (charp_class.aleradyexists(selectMarkuppercentage, "MyConn"))
{
mpercent = Convert.ToDouble(charp_class.DbSelSingleFeild(selectMarkuppercentage, "Markuppercentage", "MyConn"));
}
else
{
mpercent = 0;
}
string selectqty = "select * from spcmaster where spcnumber=" + description;
//int qty = Int16.Parse(charp_class.DbSelSingleFeild(selectqty, "quantity", "MyConn"));

Double total=Dcost*mpercent/100;
//Response.Write("percentsage" + total);
total = total + Dcost;
string selectSPCMaster = "update SPCMaster set EclipseId='" + eclipid + "',ApprovedDate='" + appdate + "',ApprovalCode='" + ApprovalCode + "',ShortDesc='" + description + "',ValidityFirstOrder='" + firstorder + "',ValidityLastOrder='" + lastorder + "',ApprovedPrice='" + total + "',SPCStatus='Approved', DealerCost='" + Dcost + "' where SPCNumber='" + description + "' and SPCStatus='Pending'";
charp_class.DbManip(selectSPCMaster, "MyConn", false);
}
errormessage.Text = "Uploaded Successfully";
//insertfunction(sdescription);
}
else
{
//message.Text = "";
errormessage.Text = "Field Name Is Not In Correct Format ";
//Response.Write("Field Name Is Not In Correct Format");
}
oledbreader.Close();
oledbcon.Close();
oledbcon.Dispose();
}


catch (OleDbException)
{
//message.Text = "";
errormessage.Text = " Pls Choose Correct file format";
//Response.Write("Enter Correct format");
}
}