private void BindDataGridView() { DECatagory catagory = new DECatagory(); BLLCatagory obj_BLLCatagory = new BLLCatagory(); DataTable dt_Catagory; if (txt_FilteredDescription.Text.Trim().Length <= 0) { dt_Catagory = obj_BLLCatagory.LoadCatagoryTableForAllData(); } else { catagory.Catagory_Description = txt_FilteredDescription.Text; dt_Catagory = obj_BLLCatagory.LoadCatagoryTableForAllDataByCatagoryDescription(catagory); } dgv_Catagory.DataSource = dt_Catagory; NumberingTableForDataGridView(dt_Catagory); FormatDataGridView(); }