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