public void grdfill() { try { // DataTable dt = new DataTable(); dtTimezone.Clear(); objData = new MasterData(); dtTimezone = new DataTable(); dtTimezone = objData.GetTimezone(null); if (dtTimezone.Rows.Count > 0) { grdTimezone.DataSource = dtTimezone; grdTimezone.DataBind(); } else { foreach (DataColumn cl in dtTimezone.Columns) { cl.AllowDBNull = true; } dtTimezone.Rows.Add(dtTimezone.NewRow()); grdTimezone.DataSource = dtTimezone; grdTimezone.DataBind(); int columncount = grdTimezone.Rows[0].Cells.Count; grdTimezone.Rows[0].Cells.Clear(); grdTimezone.Rows[0].Cells.Add(new TableCell()); grdTimezone.Rows[0].Cells[0].ColumnSpan = columncount - 2; grdTimezone.Rows[0].Cells[0].Text = "No Records Found"; grdTimezone.Columns[columncount - 2].Visible = false; } grdTimezone.FooterRow.Visible = true; } catch (Exception ex) { throw ex; } }
public void filltimezone() { MasterData objmst = new MasterData(); DataTable dt = objmst.GetTimezone("Y"); ddltimezone.DataSource = dt; ddltimezone.DataValueField = "TIMEZONE_ID"; ddltimezone.DataTextField = "TIMEZONE_DESC"; ddltimezone.DataBind(); ddltimezone.Items.Insert(0, new ListItem { Value = "0", Text = "--Select--", Selected = true }); }