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