I was recently needing to search an entire database for a particular string. I needed a script that would do this, so I went searching. I found a really useful script here: http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm. I am reposting the code here for my own future reference, and to share the script with you. But all the credit goes to the original creator.
Here is the code you need to execute against the database. It will create a stored procedure in the database that can then be used to perform the search.
Have you ever wondered how you could just display all of your applications settings for editing and reviewing quick and easy. Here is how:
Your done, it is that easy. Now all the applications settings will be displayed in a grid where they can be viewed and edited.
Note: If you only want to display User scope settings and not Application scope settings, do the following:
' Attribute for the user-scope settings.
Dim userAttr As New System.Configuration.UserScopedSettingAttribute
Dim attrs As New
PropertyGrid1.BrowsableAttributes = attrs
I was recently attempting to bind a combo box to something other than a database data source. I found this snippet of code very useful for binding it to a dictionary of items. This allows more flexibility than just editing the item list, since it allows a different display and value member to be set.
Note: This method does not seem to work with a sorted dictionary.
Dim ComboBoxSourceDictionary As New Dictionary(Of String, String)
'add all your items here
ComboBox1.DataSource = New _
ComboBox1.DisplayMember = "Value"
ComboBox1.ValueMember = "Key"