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

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

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(strSubSQL6) 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(cboMainstrSQLFld0) If cmb(j)= Category Then Call FillCombo(cboCategorystrSQLFld0) If cmb(j)= Brand Then Call FillCombo(cboBrandstrSQLFld0) If cmb(j)= Description Then Call FillCombo(cboDescriptionstrSQLFld0) If cmb(j)= sSize Then Call FillCombo(cboSizestrSQLFld0) If cmb(j)= Stylecode Then Call FillCombo(cboStyleCodestrSQLFld0) If cmb(j)= Shade Then Call FillCombo(cboColorstrSQLFld0) Next End Sub Update your code using above logic