if (clbBooksName.GetItemChecked(0) == true) { BookSelection = "OR Hadith_Book_Number = 1"; } if (clbBooksName.GetItemChecked(1) == true) { BookSelection = "OR Hadith_Book_Number = 2"; } if (clbBooksName.GetItemChecked(2) == true) { BookSelection = "OR Hadith_Book_Number = 3"; } if (clbBooksName.GetItemChecked(3) == true) { BookSelection = "OR Hadith_Book_Number = 4"; } if (clbBooksName.GetItemChecked(4) == true) { BookSelection = "OR Hadith_Book_Number = 5"; } if (clbBooksName.GetItemChecked(5) == true) { BookSelection = "OR Hadith_Book_Number = 6"; } foreach (DataGridViewRow Datarow in dataGridView1.Rows) { if (Datarow.Cells[0].Value != null && Datarow.Cells[1].Value != null && Datarow.Cells[2].Value != null && Datarow.Cells[3].Value != null) { WhereClause += Datarow.Cells[0].Value.ToString() + "= 4"; } } SearchQuery = "Select * From Hadiths_old Where Baab_Id < 100 =" + BookSelection + "AND" + WhereClause; MessageBox.Show(WhereClause);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)