//public void AddPK(string pDBParameter,pDBFieldName) //{ // VSPrimaryKey.Add(pDBParameter,pPK); // mDA.AddParameter(pDBParameter,pPK); //} public void UpdateEspackControl() { string lSql; int mNumRecords = 0; Page = 1; //mDA.SelectRS=new DynamicRS(); mDA.SelectRS.DS.Dispose(); DataSource = null; if (Paginate) { mDA.Open((Page - 1) * mPageSize, mPageSize); lSql = "SELECT NumRecords=count(*) FROM " + CtlQuery.Tablename.DBItemName + " WHERE " + CtlQuery.WhereString; DynamicRS lRS = (DynamicRS) new DynamicRS(lSql, Conn); foreach (CtlVSColumn lColumn in ColumnsExternalKeys) { lRS.AddControlParameter(lColumn.Name, lColumn.LinkedControl); } lRS.Open(); mNumRecords = Convert.ToInt32(lRS["NumRecords"]); NumPages = mNumRecords / mPageSize + ((mNumRecords % mPageSize) == 0 ? 0 : 1); mNavigationBar.Enabled = NumPages > 1; mNavigationBar.Items["Counter"].Text = "1/" + NumPages.ToString(); } else { mDA.Open(); } DataSource = mDA.Table; Refresh(); Status = mStatus; }