Comments by Lokesh Zende (Top 71 by date)

Hi SAKryukov,Thanx 4 your quick rply

Hi _Damian S_,
Thanks for your quick response.
Yes, my file is getting created properly and I can open it without any trouble.

Here's my code

public enum ExcelVersion
{
Excel,
Excel2007
};

private string ProviderExcel = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
private string ExtendedPropertiesExcel = "Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"";
private string ProviderExcel2007 = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=";
private string ExtendedPropertiesExcel2007 = "Extended Properties=\"Excel 12.0;HDR=YES\"";
private string mConnString = "";

protected void btnPost_Click(object sender, EventArgs e)
{
if (rdpUpload.UploadedFiles.Count == 0)
throw new Exception("Please select file to upload");

string sExtension = "";
string FileName = "";

ApplicationDirectoryTypeInfoList oApplicationDirectoryTypeInfoList = ApplicationDirectoryTypeInfoList.GetAllApplicationDirectories(); // my classes to read Directory..
ApplicationDirectoryTypeInfo oApplicationDirectoryTypeInfo = oApplicationDirectoryTypeInfoList.GetItem(35);

string FilePath = oApplicationDirectoryTypeInfo.ApplicationDirectoryFQN;

FilePath = FilePath.Substring(FilePath.IndexOf("/") + 1);
FilePath = AppDomain.CurrentDomain.BaseDirectory + FilePath;

foreach (UploadedFile file in rdpUpload.UploadedFiles)
{
FileName = file.GetName();
sExtension = file.GetName();
sExtension = sExtension.Substring(sExtension.LastIndexOf(".") + 1);

if (sExtension != "xls")
throw new System.Exception("Select .xls/.xlsx file ");

ExcelImport(ExcelVersion.Excel, FilePath + "//" + FileName);
GetPaymentVouchers();
}
}

public void ExcelImport(ExcelVersion ver, string FilePath)
{
switch (ver)
{

case ExcelVersion.Excel:
mConnString = ProviderExcel + FilePath + ";" + ExtendedPropertiesExcel;
break;
case ExcelVersion.Excel2007:
mConnString = ProviderExcel2007 + FilePath + ";" + ExtendedPropertiesExcel2007;
break;
}
}

public void GetPaymentVouchers()
{
OleDbConnection cn = new OleDbConnection(mConnString);
try
{
cn.Open(); // I get Error here while opening Connection...

DataTable schemaTable = cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
string SheetName = schemaTable.Rows[0][2].ToString();
StringBuilder SelectStatement = new StringBuilder();
SelectStatement.Append("SELECT * FROM [").Append(SheetName).Append("]");

OleDbDataAdapter da = new OleDbDataAdapter(SelectStatement.ToString(), cn);
DataSet ds = new DataSet();
da.Fill(ds);
}
catch(Exception ex)
{}
}