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;
}
}
}
}
