/// <summary>Page Load</summary>
public void Page_Load
(
object sender,
EventArgs e
)
{
string exceptionMessage;
ServerMapPath = this.MapPath("");
if (ServerMapPath != null)
{
FilenameConfigurationXml = Path.Combine(ServerMapPath, FilenameConfigurationXml);
}
UtilityExcel.ConfigurationXml
(
FilenameConfigurationXml,
out exceptionMessage,
ref DatabaseConnectionString
);
if (exceptionMessage != null)
{
Feedback = exceptionMessage;
return;
}
}
/// <summary>SQLExcel</summary>
public void SQLExcel()
{
string exceptionMessage;
UtilityExcel.SQLExcel
(
DatabaseConnectionString,
SQL.Text,
FilenameExcel.PostedFile.FileName,
out exceptionMessage
);
if (exceptionMessage != null)
{
Feedback = exceptionMessage;
}
}
/// <summary>OpenExcel</summary>
public void OpenExcel()
{
string exceptionMessage;
DataSet dataSet;
UtilityExcel.ExcelOpen
(
FilenameExcel.PostedFile.FileName,
UtilityExcel.ExcelConnectionType.OLEDB,
out dataSet,
out exceptionMessage
);
if (exceptionMessage != null)
{
Feedback = exceptionMessage; return;
}
GridViewExcel.DataSource = dataSet;
GridViewExcel.DataBind();
}
