In this video you will see an alternative method to search query, which we have shown you before, for creating a Search Button for database in Visual Studio 2010. Source Code: basseltech.com/watch?v=Z4GK7y...
For just looking for a single word, this alternative method is working for me with one exception. If a word has an apostrophe (single quote) in the word, e.g. haven't, an exception error is generated. Is there some way this code could be adjusted to include a word with the single quote mark in it?
need small help sir 1) If i search 'Juice' it is not showing Grape Juice, it is showing like Juice Mixer,Juice Apple like that. i need juice type of all products. 2)i have attributes in that it will show Yes and No for example Color(Attribute) - YES/NO if it is Yes then it will show in RED color(Is it possible) Thanks in Advance Prakash Karnam
Dear sir, regarding your first question, do you want your search to be only for categories? or for both products' names and categories? Regarding your second question, yest it's possible; you may now re-check the blog post for this tutorial, I've updated it with your requested question. basseltech.com/watch?v=Z4GK7yxPOko Thanks, I'm waiting for your reply, have a great day! :-)
This works great, but I am binding textboxes to my data rather than using the datagrid, and I have a Previous and Next button that use the methods BindingSource.MovePrevious and BindingSource.MoveNext. That all works fine until I use the search. It finds the record, but then the MovePrevious and MoveNext methods don't do anything anymore. Some help?
If you want to exactly match an integer, then remove the % from the line: Me.Table1BindingSource.Filter = "Firstname LIKE ' " & TextBox1.Text & "%'" So it's going to be: Me.Table1BindingSource.Filter = "Firstname LIKE ' " & TextBox1.Text & "'" If you still have any doubts, feel free to contact me. Have a nice day! :-) Email: admin@basseltech.com Kik: kik.me/basseltech/
So you want to search for data in a specific excel sheet column?
2 года назад
@@BasselTech yes. i made aproject in excel and would like to make it possible to import excel file so those who use my software will be able to make excel adres book and then import it in to the software and search or add data into the excel document. i plan to make a digital adressbook software for companies so they can just open a excel file that theadmin makes and from the software be able to add or remove data. it is planned that those who will use my software will not have to use excel and instead use my software.
2 года назад
@@BasselTech yes. i made aproject in excel and would like to make it possible to import excel file so those who use my software will be able to make excel adres book and then import it in to the software and search or add data into the excel document. i plan to make a digital adressbook software for companies so they can just open a excel file that theadmin makes and from the software be able to add or remove data. it is planned that those who will use my software will not have to use excel and instead use my software.
It refers to the current form that you are working with, but since you are within the scope of the form, It's not necessary to write it, just write the code without "Me.".
Hi Blakkabwoy, I already have a video on this, (Database With Custom Action Buttons in VB 2010): ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-dklYLutuqP4.html If you still have any doubts, feel free to contact me. Have a nice day! :-) Email: admin@basseltech.com Kik: kik.me/basseltech/
Try to write the two words between ( grave accent mark ` ), so it should look like ( `First Name` ) instead of ( First Name ). Please give me a feedback on how it goes. :-)