private void LoadGrid() { Business.DAM.Library lib = CurrentLibrary; if (lib != null) { txtResourceTypeValue.DataSource = resourceTypes; txtResourceTypeValue.DataBind(); documents.DataSource = lib.Resources; documents.DataBind(); } mainToolBar.Items.FromKeyButton("Add").Pressed(false); }
private void BindGrid() { Business.DAM.Library lib = CurrentLibrary; if (lib != null) { using (Database dbObj = new Database(SessionState.CacheComponents["DAM_DB"].ConnectionString)) { using (DataSet ds = dbObj.RunSPReturnDataSet("DL_GetDAMPackages", new System.Data.SqlClient.SqlParameter("@LibraryId", CurrentLibrary.Id))) if (ds != null && ds.Tables.Count == 2) { ds.Relations.Add("files", ds.Tables[0].Columns["ResourceId"], ds.Tables[1].Columns["ResourceId"]); documents.DataSource = ds; if (documents.CurrentPageIndex * documents.PageSize > ds.Tables[0].Rows.Count) { documents.CurrentPageIndex = 0; } documents.DataBind(); } } } }