Results for "Category: String Manipulation"
how to Make Uppercase or lowercase in Textbox
this is a wrapper for some of the more commonly used database functions. can help reduce your code dramitically.
This function takes a comma separated string and parses the values into a variable-length array, which can then be assigned to a predefined number of variables, or iterated with a For-Next loop. This code is roughly based on Brant Gluth's submission entitled "Parse Delimited Text", with the addition of a demo form and improved string handling. Most noticeably, this code can handle strings enclosed in quotes and will not break on delimiter characters within the quotes.
Objective : Control MSDE/SQL Server 2000 by doing some of SQL Server Enterprise Manager's Functionality using 100% Managed Code. PLEASE VOTE!!!!!!!!
This example demonstrates how to create subform in Internet Explorer like in MS Access. It works in same principles as a database.
If you are using a text box to input a UK postcode, the text box can be attached to this class, which will then ensure the text entered is UCase & conforms to a valid UK Postal Code format. I have add a new function to the class which enables Multimap Lookup. (Thanks to Jon Webb for that code.) Cheers also to Simon Woollard for pointing out the changes that were needed.
GrantMySql script allows user to manage users and rights of MySql database from Web browser in easy and simple manner. It is useful for novices as well as for advanced users. If you do not know line syntax of MySql or need often to change or give rights for MySql database, this script is ideal for you.
This code is an ASP VBScript Class that allows you to find any acccess database on your server, and connect to any record in any table and edit,add or delete. It has a full grid function for paging through recordsets.
Most users especially those bigenners with vb.net asks how to use DAO with vb.net
only change to your database name. yazi.mdb to yourdb.mdb ( find and replace in notepad )
This Code .can be show you how to get all image from database[MSSQL] to show with listview like LargeIconStyle.I find this module from www. but not found,untill me tried to coding to modified of someone at http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=1137&lngWId=10 .i do it and get adapt to my work.that done.
Includes many common useful string functions. Reverse string, Remove extra spaces, Delimit string, Alternating caps, Proper case, and Count number of occurances of a string in a string. Vote if you like it!
This code shows how to find a longest common substring in two strings. I had a hard time finding out how exactly to do this so now that I have done it I'm sharing it to help others that need it.
Database grid with records edit, delete, add, search, filter and export to excel, database and table selection, page navigation, field sort and search in page. Works with MS Access, MSSQL and MySQL databases.
This is a simple VB.NET application which demonstrats handling local database (I used MDB). I think this example will be a great help for extreme BEGINNERS. (Env: Visual Basic.NET Express Beta 2005)
This program demonstrates using an XML document as a database. The example uses a fake forum database and allows you to view all of the members, view member information, edit a member's information, remove a member, and add a member.
Storing data (anything) in a string can be done more compactly using this method than using Hex strings. *Updated - speedier main functions. I've also added functions for more compact storage of dates/times in strings than a simple byte translation.
Due to the astonishing popularity of someone else's recent submission and me feeling bored...
Title: Music Database for MP3 Files Description: This code is based on "My Music Database" by H. Morales. Here are the differences: 1. Code was rewritten in Visual Basic. 2. Additional fields added to the table: Composer, Copyright, Comments, and FullPath. 3. Removed buttons and wrote event handlers for BindingNavigator buttons. 4. Added ComboBox for Search type and wrote code to search all fields except Track and FullPath. 5. Added class library to obtain ID3 data from file. 6. Added class library to play MP3 file. 7. Added button to create entries for all MP3 files in a folder automatically. 8. Added setup program. Because of the multiple projects (and types) it is necessary to use a full version of Visual Studio 2008 to build this solution. Microsoft SQL Server 2008 R2 is also required.
Give this function a number from 0 to 100, and it will generate a cool progress bar made of text!