protected void GridViewTimesheet_PageIndexChanging(object sender, GridViewPageEventArgs e) { GridViewTimesheet.PageIndex = e.NewPageIndex; LoadTimesheet(); GridViewTimesheet.DataBind(); }
private void LoadTimesheet() { dt = new DataTable(); string cnnstr = ConfigurationManager.AppSettings["ConnectionString"]; SqlConnection conn = new SqlConnection(cnnstr); conn.Open(); string Query = @"SELECT dbo.ClientDetails.ClientID, dbo.ClientDetails.EmailAddress, dbo.Notes.UpdatedDate, dbo.Notes.SubscriberNotes FROM dbo.ClientDetails RIGHT OUTER JOIN dbo.Notes ON dbo.ClientDetails.ClientID = dbo.Notes.ClientID WHERE dbo.ClientDetails.EmailAddress is not null"; adapt = new SqlDataAdapter(Query, conn); adapt.Fill(dt); if (dt.Rows.Count > 0) { GridViewTimesheet.DataSource = dt; GridViewTimesheet.DataBind(); } else { dt.Rows.Add(dt.NewRow()); GridViewTimesheet.DataSource = dt; GridViewTimesheet.DataBind(); int TotalColumns = GridViewTimesheet.Rows[0].Cells.Count; GridViewTimesheet.Rows[0].Cells.Clear(); GridViewTimesheet.Rows[0].Cells.Add(new TableCell()); GridViewTimesheet.Rows[0].Cells[0].ColumnSpan = TotalColumns; GridViewTimesheet.Rows[0].Cells[0].Text = "No records Found"; } conn.Close(); }