private void CmBTables2_SelectedValueChanged(object sender, EventArgs e)
{
CmbColums2.DataSource = SchemaTables.GetAllColumFromTable(Constants.CONECTION_STRING, Constants.DB_NAME, CmBTables2?.SelectedValue?.ToString());
if (IsChargeForm)
{
NotifyConditon.ChangeValueItem(Identifier, GenerateQuery(), CheckAND.Checked ? "AND" : "OR");
}
}
private void BtnSearch_Click(object sender, EventArgs e)
{
PnlNortificationType.Controls.Clear();
String query = String.Concat("SELECT * FROM ", CmbDestination.SelectedValue.ToString(), " WHERE ");
List <String> listRowsTables = SchemaTables.GetAllColumFromTable(Constants.CONECTION_STRING, Constants.DB_NAME, CmbDestination.SelectedValue.ToString());
foreach (String item in listRowsTables)
{
query = String.Concat(query, "(", item, " LIKE '%", TxtSearch.Text, "%') ");
if (listRowsTables.IndexOf(item) != listRowsTables.Count - 1)
{
query = String.Concat(query, " OR ");
}
}
GrdViewResult.DataSource = SchemaTables.ExeucteQuery(Constants.CONECTION_STRING, query, this);
}