private void BindSeachALL() { DataTable dtGetAllPro = LoginInfo.GET_ALLDATA_QUERY("RptUserSeach", VideoResultID); if (dtGetAllPro.Rows.Count > 0) { RptUserSeach.DataSource = dtGetAllPro; RptUserSeach.DataBind(); } }
private void BindSeachALL() { DataTable dtGetAllPro = SqlHelper.GetDataUsingQuery("select top 10 SC.IncidentSubCategoryName,MC.IncidentCategoryName,V.UploadedVideoIDP,P.ThumbPath,V.IsApproved,V.IsReject,P.StoryPicNVideoPath,C.FirstName, V.UploadTitle,V.EntryDate,V.AreaOfCity,V.IncidentDescription,V.KeyWordForSearch,V.IncidentDate from tblUploadedVideo as V inner join tblClient as C on (V.UserID=C.ClientIDP) inner join tblUploadStoryPicAndVideoPath as P on(P.UploadedVideoIDF=V.UploadedVideoIDP) inner join mIncidentCategory as MC on(MC.IncidentCategoryIDP=V.IncidentCategoryIDF) inner join mIncidentSubCategory as SC on(SC.IncidentSubCategoryIDP=V.IncidentSubCategoryIDF) where V.UploadTypeID=" + CategoryType + " and V.IncidentSubCategoryIDF=" + VideoCategoryid + ""); if (dtGetAllPro.Rows.Count > 0) { RptUserSeach.DataSource = dtGetAllPro; RptUserSeach.DataBind(); } else { TblError.Visible = true; } }