protected void GetPendingOrderList() { SalesOrderBLL salesOrder = new SalesOrderBLL(); try { DataTable dt = salesOrder.GetPendingSalesOrdersListBySalesCenter(salesCenterDropDownList.SelectedValue.Trim()); pendingSalesOrderListGridView.DataSource = dt; pendingSalesOrderListGridView.DataBind(); if (pendingSalesOrderListGridView.Rows.Count > 0) { pendingSalesOrderListGridView.UseAccessibleHeader = true; pendingSalesOrderListGridView.HeaderRow.TableSection = TableRowSection.TableHeader; } else { msgbox.Visible = true; msgTitleLabel.Text = "Data Not Found!!!"; msgDetailLabel.Text = ""; } } catch (Exception ex) { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message; } finally { salesOrder = null; } }