public void UpdateDataGridView() { GridView_Table = Table_SQL.showRecords(providernm, dbname, tableName, out QUERY); ViewState["GridView_Table"] = GridView_Table; Table_GridView.DataSource = GridView_Table; Table_GridView.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if ((Session["Message_Label"] != null) && (Session["SQL_Label"] != null)) { Color setColor = Color.Green; (this.Master as MasterPages_MasterPage).ShowMessageLabel(Session["Message_Label"].ToString(), setColor); (this.Master as MasterPages_MasterPage).ShowSQLLabel(Session["SQL_Label"].ToString(), setColor); Session["Message_Label"] = null; Session["SQL_Label"] = null; } if (ViewState["GridView_Table"] != null) { GridView_Table = (DataTable)ViewState["GridView_Table"]; } if (Request.QueryString["provider"] != null && Request.QueryString["dbnm"] != null && Request.QueryString["tbnm"] != null) { providernm = Request.QueryString["provider"].ToString(); dbname = Request.QueryString["dbnm"].ToString(); tableName = Request.QueryString["tbnm"].ToString(); if (!IsPostBack) { Table_SQL.UseDatabase(providernm, dbname); LoadDataGridView(); } } else { Response.Redirect("~/Default.aspx"); } }
protected void MultipleDeleteButton_Click(object sender, EventArgs e) { QUERY = ""; for (int index = 0; index < Table_GridView.Rows.Count; index++) { CheckBox c1 = (CheckBox)Table_GridView.Rows[index].FindControl("Select_CheckBox"); if (c1.Checked) { if (providernm.Equals("mysql", StringComparison.OrdinalIgnoreCase)) { QUERY += Mysql_DeleteStatement(index); } else if (providernm.Equals("mssql", StringComparison.OrdinalIgnoreCase)) { QUERY += MsSQL_DeleteStatement(index); } } } Color setColor; string msg = Table_SQL.DeleteRecords(providernm, dbname, QUERY, out setColor); (this.Master as MasterPages_MasterPage).ShowMessageLabel(msg, setColor); (this.Master as MasterPages_MasterPage).ShowSQLLabel(QUERY, setColor); UpdateDataGridView(); }
protected void Table_GridView_RowCommand(object sender, GridViewCommandEventArgs e) { int index = Convert.ToInt32(e.CommandArgument); if (e.CommandName == "Delete_Button") { if (providernm.Equals("MYSQL", StringComparison.OrdinalIgnoreCase)) { string DeleteQuery = Mysql_DeleteStatement(index); Color setColor; string msg = Table_SQL.DeleteRecords(providernm, dbname, DeleteQuery, out setColor); (this.Master as MasterPages_MasterPage).ShowMessageLabel(msg, setColor); (this.Master as MasterPages_MasterPage).ShowSQLLabel(DeleteQuery, setColor); UpdateDataGridView(); } else if (providernm.Equals("MsSQL", StringComparison.OrdinalIgnoreCase)) { string DeleteQuery = MsSQL_DeleteStatement(index); Color setColor; string msg = Table_SQL.DeleteRecords(providernm, dbname, DeleteQuery, out setColor); (this.Master as MasterPages_MasterPage).ShowMessageLabel(msg, setColor); (this.Master as MasterPages_MasterPage).ShowSQLLabel(DeleteQuery, setColor); UpdateDataGridView(); } } }
protected void clear_Button_Click(object sender, EventArgs e) { Color setColor; string msg = Table_SQL.CleanTableRecords(providernm, dbname, tableName, out setColor, out QUERY); (this.Master as MasterPages_MasterPage).ShowMessageLabel(msg, setColor); (this.Master as MasterPages_MasterPage).ShowSQLLabel(QUERY, setColor); }
private void LoadDataGridView() { DataTable dt = Table_SQL.showTableStructure(providernm, dbname, tableName); if (dt.Rows.Count > 0) { table_structure_GridView.DataSource = dt; table_structure_GridView.DataBind(); } else { (this.Master as MasterPages_MasterPage).ShowMessageLabel("No Columns Available.", Color.Crimson); } }
public void LoadDataGridView() { GridView_Table = Table_SQL.showRecords(providernm, dbname, tableName, out QUERY); ViewState["GridView_Table"] = GridView_Table; Table_GridView.DataSource = GridView_Table; Table_GridView.DataBind(); if (GridView_Table.Rows.Count > 0) { (this.Master as MasterPages_MasterPage).ShowMessageLabel("Query Executed Succesfully...", Color.Green); (this.Master as MasterPages_MasterPage).ShowSQLLabel(QUERY, Color.Green); } else { Response.Redirect("~/Table_Pages/table_structure.aspx?provider=" + providernm + "&dbnm=" + dbname + "&tbnm=" + tableName); } }
protected void drop_Button_Click(object sender, EventArgs e) { Color setColor; bool flag = false; string msg = Table_SQL.DropTable(providernm, dbname, tableName, out setColor, out QUERY, out flag); if (flag) { Session["SQL_Label"] = QUERY; Session["Message_Label"] = msg; Response.Redirect("~/database_structure.aspx?provider=" + providernm + "&dbnm=" + dbname); } else { (this.Master as MasterPages_MasterPage).ShowMessageLabel(msg, setColor); (this.Master as MasterPages_MasterPage).ShowSQLLabel(QUERY, setColor); } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["provider"] != null && Request.QueryString["dbnm"] != null && Request.QueryString["tbnm"] != null) { providernm = Request.QueryString["provider"].ToString(); dbname = Request.QueryString["dbnm"].ToString(); tableName = Request.QueryString["tbnm"].ToString(); if (!IsPostBack) { Table_SQL.UseDatabase(providernm, dbname); LoadDataGridView(); } } else { Response.Redirect("~/Default.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["provider"] != null && Request.QueryString["dbnm"] != null && Request.QueryString["tbnm"] != null) { providernm = Request.QueryString["provider"].ToString(); dbname = Request.QueryString["dbnm"].ToString(); tableName = Request.QueryString["tbnm"].ToString(); Table_SQL.UseDatabase(providernm, dbname); int total = 0; if (!IsPostBack) { ViewState["total"] = total = 2; } else { total = int.Parse(ViewState["total"].ToString()); } CreateInsertStructure(total); } else { Response.Redirect("~/Default.aspx"); } }
protected void Save_Button_Click(object sender, EventArgs e) { bool isInsert = false; string InsertQuery = ""; if (providernm.Equals("MSSQL", StringComparison.OrdinalIgnoreCase)) { InsertQuery = "USE [" + dbname + "]"; } else { InsertQuery = ""; } int total = int.Parse(ViewState["total"].ToString()); for (int i = 0; i < total; i++) { if (!ad[i].isInsert) { InsertQuery += ad[i].GetInsertQuery(); isInsert = true; } } if (isInsert) { Color setColor; string msg = Table_SQL.InsertRecords(providernm, dbname, tableName, InsertQuery, out setColor); Session["SQL_Label"] = InsertQuery; Session["Message_Label"] = msg; Response.Redirect("~/Table_Pages/table_browse.aspx?provider=" + providernm + "&dbnm=" + dbname + "&tbnm=" + tableName); } else { (this.Master as MasterPages_MasterPage).ShowMessageLabel("Please Insert Any Record...", Color.Red); } }
public void CreateStructure(string providernm, string dbname, string tablenm) { Providernm = providernm; DBName = dbname; Tablenm = tablenm; dt = Table_SQL.GetInsertStructure(providernm, dbname, tablenm); if (providernm.Equals("MYSQL", StringComparison.OrdinalIgnoreCase)) { for (int i = 0; i < dt.Rows.Count; i++) { TableRow Row_Column = new TableRow(); TableRow Row_DataType = new TableRow(); TableRow Row_Value = new TableRow(); TableCell cell_Column = new TableCell(); TableCell cell_DataType = new TableCell(); TableCell cell_Value = new TableCell(); TextBox t1 = new TextBox(); t1.ID = "t" + i; cell_Column.Text = dt.Rows[i][0].ToString(); Row_Column.Cells.Add(cell_Column); Table_Column.Rows.Add(Row_Column); cell_DataType.Text = dt.Rows[i][1].ToString(); Row_DataType.Cells.Add(cell_DataType); Table_DataType.Rows.Add(Row_DataType); cell_Value.Controls.Add(t1); Row_Value.Cells.Add(cell_Value); Table_Value.Rows.Add(Row_Value); } } else if (providernm.Equals("MSSQL", StringComparison.OrdinalIgnoreCase)) { for (int i = 0; i < dt.Rows.Count; i++) { TableRow Row_Column = new TableRow(); TableRow Row_DataType = new TableRow(); TableRow Row_Value = new TableRow(); TableCell cell_Column = new TableCell(); TableCell cell_DataType = new TableCell(); TableCell cell_Value = new TableCell(); TextBox t1 = new TextBox(); t1.ID = "t" + i; cell_Column.Text = dt.Rows[i]["ColumnName"].ToString(); Row_Column.Cells.Add(cell_Column); Table_Column.Rows.Add(Row_Column); cell_DataType.Text = dt.Rows[i]["DataType"].ToString(); Row_DataType.Cells.Add(cell_DataType); Table_DataType.Rows.Add(Row_DataType); cell_Value.Controls.Add(t1); Row_Value.Cells.Add(cell_Value); Table_Value.Rows.Add(Row_Value); if (dt.Rows[i]["DataType"].ToString().Contains("identity")) { t1.Enabled = false; } } } }