public void grdfill() { try { dtuser.Clear(); dtuser = new DataTable(); objData = new MasterData(); string userrole = Convert.ToString(Session["userrole"]); dtuser = objData.Users_Get(userrole); if (dtuser.Rows.Count > 0) { grdUsers.DataSource = dtuser; grdUsers.DataBind(); } else { foreach (DataColumn cl in dtuser.Columns) { cl.AllowDBNull = true; } dtuser.Rows.Add(dtuser.NewRow()); grdUsers.DataSource = dtuser; grdUsers.DataBind(); int columncount = grdUsers.Rows[0].Cells.Count; grdUsers.Rows[0].Cells.Clear(); grdUsers.Rows[0].Cells.Add(new TableCell()); grdUsers.Rows[0].Cells[0].ColumnSpan = columncount - 2; grdUsers.Rows[0].Cells[0].Text = "No Records Found"; grdUsers.Columns[columncount - 2].Visible = false; } grdUsers.FooterRow.Visible = true; } catch (Exception ex) { throw ex; } }