protected void btnSubmit_Click(object sender, EventArgs e) { tableColumns = (Dictionary<string, List<DB.Column>>)Session["tableColumns"]; if (null == tableColumns) return; var dbo = new DB.DBCalls(); tableColumns.ToList().ForEach(table => { var query = "alter table [" + client + "].[" + table.Key + "] add "; table.Value.ForEach(column => { query += "[" + column.ColumnName + "] " + column.DataType.ToString(); if ((column.DataType == System.Data.SqlDbType.VarChar) || (column.DataType == System.Data.SqlDbType.NVarChar) || (column.DataType == System.Data.SqlDbType.Char) || (column.DataType == System.Data.SqlDbType.Char) || (column.DataType == System.Data.SqlDbType.NChar)) { query += "(" + column.Length.ToString() + ")"; } query += (column.IsNullable) ? " null " : " not null "; query += (string.IsNullOrEmpty(column.DefaultValue)) ? "" : " default '" + column.DefaultValue + "'"; query += ", "; }); query = query.Remove(query.LastIndexOf(","), 2); try { dbo.ExecuteString(query); } catch (System.Data.SqlClient.SqlException sqlE) { } }); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { txtTenantName.Text = "StarBucks"; DataTable dt; tenant = txtTenantName.Text; // Get all tables for starbucks string query = "select distinct(table_name) from information_schema.columns where TABLE_SCHEMA='" + tenant + "'"; try { dt = new DB.DBCalls().ExecuteString(query); } catch (System.Data.SqlClient.SqlException) { return; } ddlTableSchema.DataSource = dt; ddlTableSchema.DataTextField = "table_name"; ddlTableSchema.DataValueField = "table_name"; ddlTableSchema.DataBind(); ddlTableSchema.Items.Insert(0, new ListItem("-- Select --", "-1")); } }