HI All,
I am importing bulk data store to the database. I got code. But I want to use the particular code into 3-tire. please help to convert to 3-tire architecture.
code is below
try
{
string conString = string.Empty;
string excelPath = Server.MapPath("/File/") + Path.GetFileName(fileUploadPersonalDetails.PostedFile.FileName);
fileUploadPersonalDetails.SaveAs(excelPath);
string extension = Path.GetExtension(fileUploadPersonalDetails.PostedFile.FileName);
switch (extension)
{
case ".xls": //Excel 97-03
conString = ConfigurationUtility.GetExcel03();
break;
case ".xlsx": //Excel 07 or higher
conString = ConfigurationUtility.GetExcel0 ...
Go to the complete details ...