protected void chb_chnage(object sender, EventArgs e) { CheckBox chb = (CheckBox)sender; string js = ""; string cols = ""; if (chb.Checked) { List <USP_getallcolumnsResult> obj = Reportgenrator.Getallcolumns(chb.ToolTip); for (int i = 0; i < obj.Count; i++) { cols += obj[i].COLUMN_NAME + "~" + obj[i].DATA_TYPE + "~" + obj[i].CHARACTER_MAXIMUM_LENGTH.ToString() + "^"; } if (cols.Length > 0) { cols = cols.Substring(0, cols.Length - 1); } js = "createtable('" + chb.ToolTip + "','" + cols + "');"; ddlmtables.Items.Add(new ListItem(chb.ToolTip)); } else { js = "removetable('" + chb.ToolTip + "');"; ddlmtables.Items.Remove(ddlmtables.Items.FindByText(chb.ToolTip)); } ScriptManager.RegisterStartupScript(Page, GetType(), "js", js, true); }
protected void ddlviews_changed(object sender, EventArgs e) { ddlselectcolmns.DataSource = Reportgenrator.Getallcolumns(ddlviews.SelectedItem.Text); ddlselectcolmns.DataTextField = "COLUMN_NAME"; ddlselectcolmns.DataValueField = "COLUMN_NAME"; ddlselectcolmns.DataBind(); ddlcols_change(null, null); }