protected void SaveButton_OnClick(object sender, EventArgs e) { int measureID = Convert.ToInt32(Request.QueryString["mID"]); OrderedDictionary keys = new OrderedDictionary(); keys.Add("measureID", measureID); OrderedDictionary newvalues = new DxDbOps.FormLayoutNewValues((ASPxFormLayout)FormLayout); newvalues.Add("measureID", measureID); OrderedDictionary oldvalues = (OrderedDictionary)Session["formlayoutoldvalues"]; bool outcome = DxDbOps.BuildUpdateSqlCode(keys, newvalues, oldvalues, "tblMeasure", "backend", "dbo"); bool outcome2 = DxDbOps.BuildUpdateSqlCode(keys, newvalues, oldvalues, "tbl", "data", "def"); LoadMeasureInfo(measureID); }
protected void LoadMeasureInfo(int measureID) { SQL_utils sql = new SQL_utils("backend"); string code = String.Format("select a.*, tblname, tblpk, spname, skipstartingrows, importfiletype, textqualifier, firstrowcontainsfldnames from tblmeasure a {0} " + " left join uwautism_research_data.def.tbl b ON a.measureID = b.measureID where a.measureID={1}" , Environment.NewLine, measureID); DataTable dt = sql.DataTable_from_SQLstring(code); string fldcode = String.Format("select count(*) from uwautism_research_data.def.fld where tblpk = (select tblpk from uwautism_research_data.def.tbl where measureID = {0}) ", measureID); int nflds = sql.IntScalar_from_SQLstring(fldcode); btnDict.Visible = (nflds > 0) ? true : false; sql.Close(); FormLayout.DataSource = dt; FormLayout.DataBind(); OrderedDictionary oldvalues = new DxDbOps.FormLayoutNewValues((ASPxFormLayout)FormLayout); oldvalues.Add("measureID", measureID); Session["formlayoutoldvalues"] = oldvalues; }