private void Btn1_Click(object sender, EventArgs e)
{
//throw new NotImplementedException();
for (int i = 1; i < frm1.rc1 + 1; i++)
{
for (int j = 0; j < frm1.cc; j++)
{
if (frm1.arrOfNames[i, j] == null)
{
continue;
}
if (((Button)sender).Name == frm1.arrOfNames[i, j])
{
String temp = frm1.arrOfNames[i, j];
if (temp.Contains(",") == true)
{
temp = temp.Replace(",", ".");
}
if (((Button)sender).BackColor.Equals(System.Drawing.Color.Gainsboro))
{
((Button)sender).BackColor = System.Drawing.Color.DarkGray;
if (frm1.lenOfStr == frm1.selStr.Length)
{
frm1.selStr = String.Format("SELECT * FROM {0} ", frm1.tableName) + String.Format("WHERE {2}.[{0}] = N'{1}'", frm1.arrOfNames[0, j], temp, frm1.tableName);
}
else
{
frm1.selStr = frm1.selStr + String.Format(" and {2}.[{0}] = N'{1}'", frm1.arrOfNames[0, j], temp, frm1.tableName);
ncounter++;
}
}
else
{
((Button)sender).BackColor = System.Drawing.Color.Gainsboro;
if (ncounter > 0)
{
frm1.selStr = frm1.SubStrDel(frm1.selStr, String.Format(" and {2}.[{0}] = N'{1}'", frm1.arrOfNames[0, j], temp, frm1.tableName));
ncounter--;
}
else
{
frm1.selStr = frm1.SubStrDel(frm1.selStr, String.Format("{2}.[{0}] = N'{1}'", frm1.arrOfNames[0, j], temp, frm1.tableName));
frm1.selStr = frm1.SubStrDel(frm1.selStr, "WHERE ");
}
}
//frm1.foundedColumn = i + 1;
//frm1.button2.Text = frm1.foundedColumn.ToString();
frm1.button2.Text = frm1.arrOfNames[i, j].ToString();
//frm1.selStr = String.Format("SELECT * FROM table1 WHERE table1.[{0}] = '{1}'",frm1.arrOfNames[0,j],frm1.arrOfNames[i,j]);
frm1.GroupSelection(frm1.selStr);
}
}
}
}
private void выполнитьToolStripMenuItem_Click(object sender, EventArgs e)
{
if (textBox1.Text != "")
{
string strSql = textBox1.Text;
frm1.GroupSelection(strSql);
}
else
{
MessageBox.Show("Необходимо ввести команду SQL!", "Ошибка!", MessageBoxButtons.OK);
}
}
