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