protected void fetchButton_Click(object sender, EventArgs e) { if (this.Droplist_Tables.SelectedIndex == 0) { return; } else { string comboboxValue = this.Droplist_Tables.SelectedItem.Text; //var x = t.GetField("comboboxValue"); using (var db = new MyConnection()) { var t = typeof(MyConnection); PropertyInfo prop = t.GetProperty(this.Droplist_Tables.SelectedItem.Text); var query = prop.GetValue(db, null); var myType = query.GetType(); var connection = db.Database.Connection; if (connection.State == ConnectionState.Closed) connection.Open(); var command = connection.CreateCommand(); command.CommandText = query.ToString(); command.CommandType = CommandType.Text; this.tableGrid.DataSource = command.ExecuteReader(); this.tableGrid.DataBind(); connection.Close(); } //GridButtonColumn newColumn = new GridButtonColumn(); //newColumn.HeaderText = "Options"; //newColumn.Text = "Delete"; //this.tableGrid.Columns.Add(newColumn); } }
protected void tableGrid_ItemCommand(object sender, GridCommandEventArgs e) { if (e.CommandName == "Delete") { GridDataItem item = (GridDataItem)e.Item; string Id = item["Id"].Text; //Response.Write("<script>alert('ID Selected was " + Id + " from table " + this.Droplist_Tables.SelectedItem.Text + "')</script>"); using (var db = new MyConnection()) { try { db.Database.ExecuteSqlCommand("DELETE FROM " + this.Droplist_Tables.SelectedItem.Text + " WHERE ID = " + Id); Response.Write("<script>alert('Successfully removed')</script>"); } catch (Exception err) { Response.Write("<script>alert('Error: " + err.Message + "')</script>"); return; } } } if (e.CommandName == "Details") { GridDataItem item = (GridDataItem)e.Item; int Id = Int32.Parse(item["Id"].Text); Response.Write("<script>alert('ID Selected was " + Id + " from table " + this.Droplist_Tables.SelectedItem.Text + "')</script>"); } }