protected void ImgBtnExportUnion_OnClick(object sender, EventArgs e)
{
try
{
BLL_Crew_Admin objBLL = new BLL_Crew_Admin();
DataTable dtUnion = objBLL.CRW_LIB_ExportUnionWithBranchs(txtfilter.Text.Trim());
string[] HeaderCaptions = null;
string[] DataColumnsName = null;
if (hdnAddressType.Value == "0")//US
{
HeaderCaptions = new string[10] {
"Union ", "Union Branch", "Address Line 1", "Address Line 2", "City", "State", "ZipCode", "Country", "Phone Number", "Email"
};
DataColumnsName = new string[10] {
"UnionName", "UnionBranch", "AddressLine1", "AddressLine2", "City", "State", "ZipCode", "Country_Name", "PhoneNumber", "Email"
};
}
else if (hdnAddressType.Value == "1")///International
{
HeaderCaptions = new string[6] {
"Union ", "Union Branch", "Address", "Country", "Phone Number", "Email"
};
DataColumnsName = new string[6] {
"UnionName", "UnionBranch", "Address", "Country_Name", "PhoneNumber", "Email"
};
}
GridViewExportUtil.ShowExcel(dtUnion, HeaderCaptions, DataColumnsName, "Union", "Union", "");
}
catch (Exception ex)
{
}
}
