Search from database from multi-textbox !!

Question

how to retrieve data from database using mutiple-texboxes ?? basically making SQL query dynamically ? (without LIKE operator) example format this in image !! as user may left some text-box empty but result must be show on basis of other filled text-boxes

Nilesh Sawardekar · Answer

Private Sub FilterData(strFilter As String ) Dim i As Integer Dim j As Integer Dim strSQL As String Dim fieldSQL As String = "" Dim Fld As String = "" Dim sSampData() As String Dim strSubSQL As String = "" Dim cboFilter(6) As String Dim cmb(6) As String cboFilter(0)=cboMain.Text cboFilter(1)=cboCategory.Text cboFilter(2)=cboBrand.Text cboFilter(3)=cboDescription.Text cboFilter(4)=cboSize.Text cboFilter(5)=cboStyleCode.Text cboFilter(6)=cboColor.Text cmb(0)= "MainCategory" cmb(1)= "Category" cmb(2)= "Brand" cmb(3)= "Description" cmb(4)= "sSize" cmb(5)= "StyleCode" cmb(6)= "Shade" For i=0 To cmb.Count-1 If cmb(i)=strFilter Then GoTo down End If Next : For j=0 To i If j=0 Then fieldSQL=fieldSQL& "," & "MainCategory='" &cboFilter(j)& "'" If j=1 Then fieldSQL=fieldSQL& "," & "Category='" &cboFilter(j)& "'" If j=2 Then fieldSQL=fieldSQL& "," & "Trim(Brand)='" & "" &cboFilter(j)& "'" If j=3 Then fieldSQL=fieldSQL& "," & "Description='" &cboFilter(j)& "'" If j=4 Then fieldSQL=fieldSQL& "," & "sSize='" &cboFilter(j)& "'" If j=5 Then fieldSQL=fieldSQL& "," & "StyleCode='" &cboFilter(j)& "'" If j=6 Then fieldSQL=fieldSQL& "," & "Shade='" &cboFilter(j)& "'" Next sSampData=Split(fieldSQL, "," ) For j=1 To UBound(sSampData) strSubSQL=strSubSQL& "AND" &sSampData(j) Next strSubSQL=Mid(strSubSQL,6) For j=i+1 To cboFilter.Count-1 If j=0 Then Fld= "MainCategory" If j=1 Then Fld= "Category" If j=2 Then Fld= "Brand" If j=3 Then Fld= "Description" If j=4 Then Fld= "[sSize]" If j=5 Then Fld= "StyleCode" If j=6 Then Fld= "[Shade]" strSQL= "SelectDistinct" &Fld& "FromProductMasterWhere" &strSubSQL If cmb(j)= "MainCategory" Then Call FillCombo(cboMain,strSQL,Fld,0) If cmb(j)= "Category" Then Call FillCombo(cboCategory,strSQL,Fld,0) If cmb(j)= "Brand" Then Call FillCombo(cboBrand,strSQL,Fld,0) If cmb(j)= "Description" Then Call FillCombo(cboDescription,strSQL,Fld,0) If cmb(j)= "sSize" Then Call FillCombo(cboSize,strSQL,Fld,0) If cmb(j)= "Stylecode" Then Call FillCombo(cboStyleCode,strSQL,Fld,0) If cmb(j)= "Shade" Then Call FillCombo(cboColor,strSQL,Fld,0) Next End Sub Update your code using above logic

Krishna Rajput Singh · Answer

http://stackoverflow.com/questions/21010426/search-data-from-sql-database-using-multiple-textbox-and-a-search-button http://www.vbforums.com/showthread.php?772001-Checking-multiple-textboxes-before-searching-a-database http://c.bigresource.com/C-Sharp-Searching-with-multiple-textboxes--JatTm9gW.html

Search from database from multi-textbox !!

Nilesh Sawardekar

Krishna Rajput Singh