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;
}
}
