private void dataBind()
{
SqlDataSource1.SelectCommand = "select MemberID,I.Institute_Name ,D.DeptName ,F.CreatedDate, concat(U.Prefix, ' ', U.FirstName, ' ',U.MiddleName, ' ',U.LastName) AS NAME,Q1,Q2,Q3,Q4 from FeedBack_Tracker F,User_M U,Dept_M D,Institute_M I where U.User_Id=F.MemberID and U.InstituteId=I.Institute_Id AND U.Department_Id=D.DeptId and I.Institute_Id=D.Institute_Id AND Type='Pub' ORDER BY F.CreatedDate DESC";
SqlDataSource1.DataBind();
GridviewFeedback.DataBind();
}
protected void GridViewSearchPublication_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
dataBind();
GridviewFeedback.PageIndex = e.NewPageIndex;
GridviewFeedback.DataBind();
}
