public DataSet ExecleDs(string filenameurl, string fileName)
{
DataSet ds = new DataSet();
StringBuilder strConn = new StringBuilder();
strConn.Append("Provider=Microsoft.Jet.OleDb.4.0;");
strConn.Append("data source=");
strConn.Append(filenameurl);
strConn.Append(";Extended Properties='Excel 8.0; HDR=YES; IMEX=1'");
OleDbConnection conn = new OleDbConnection(strConn.ToString());
try
{
conn.Open();
DataTable dt = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
string strSheetName = dt.Rows[0][2].ToString().Trim();
OleDbDataAdapter odda = new OleDbDataAdapter("select * from [" + strSheetName + "]", conn);
odda.Fill(ds, fileName);
}
catch (Exception)
{
return null;
}
finally
{
conn.Close();
}
return ds;
}
{
DataSet ds = new DataSet();
StringBuilder strConn = new StringBuilder();
strConn.Append("Provider=Microsoft.Jet.OleDb.4.0;");
strConn.Append("data source=");
strConn.Append(filenameurl);
strConn.Append(";Extended Properties='Excel 8.0; HDR=YES; IMEX=1'");
OleDbConnection conn = new OleDbConnection(strConn.ToString());
try
{
conn.Open();
DataTable dt = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
string strSheetName = dt.Rows[0][2].ToString().Trim();
OleDbDataAdapter odda = new OleDbDataAdapter("select * from [" + strSheetName + "]", conn);
odda.Fill(ds, fileName);
}
catch (Exception)
{
return null;
}
finally
{
conn.Close();
}
return ds;
}