Results for "Category: String Manipulation"

It generates store procedure to do INSERT,MODIFY,DELETE and VIEW operation for any Table

Learn ADO.NET basics in shortest time possible. Contains 2 tutorials: Bound manually by code and bound by build-in Databinding. Shows you how to connect to an Access database, populate the controls with data, add new record, edit existing record, delete record, and save to the database. Well commented. Ideal to VB.NET beginners as well.

This code show you a simple cashier application, which include user login, add to datagrid and manipulate it, OleDbDataAdapter, DataSet, OleDbDataReader and insert to Access with OleDbCommand

Database Management Using ADO.NET/VB.NET/ACCESS 2003

compressed backup of database. you can learn how to readxml update it to database and how to write xml files access to xml database backup and restore using ado.net.oledb database compact and compress upto 50 times use gzip in vb.net use app.path merge dataset update dataadapter

Looking for faster performance? If you have an older database driven ASP app, it probably uses an ODBC DSN in its connection string to reach the database. It probably looks alot like this: "DSN=myDSNName;". If you see this you should immediately upgrade the code to ADO/OLEDB--Microsoft's new standard. Not only will this help you keep the code current, but it will run faster and take up less memory. Below are the connection strings for OLEDB/ADO for both Access and SQL Server--the two most common databases for IIS platforms. If you are using another database, you'll need to consult your db's ADO Provider's documentation for the proper connection string.

If you're an old ADO programmer, you may be frustrated by not knowing exactly how to check for NULL. Here's a 1 second tip on how to do it in ADO.NET.

The purpose of this routine is to take a string of text (such as with a textbox) and extract a numerical value from it. let's say that you have a textbox in which people enter dollar amounts. Many users are likely to enter something such as "$ 4,335.49" and expect calculations to be performed on it. The trouble is, the value of that string is 0 (zero), not 4335.49!

Compresses strings, most effective on bitmap files

This short and sweet function accepts a string containing text to be spell checked, checks the text for spelling using MS Word automation, and then returns the processed text as a string. The familiar MS Word spelling dialog will allow the user to perform actions such as selecting from suggested spellings, ignore, adding the word to a customized dictionary, etc.

This is a class module that performs regular expression searches in a string.

Want to sort 5,000 10-byte strings in about 1/10th of a second? This will do it (at least on my PII-233!). The insertion sort manages the same task in about 60 seconds (even when optimized it still took about 15 seconds on the same machine).

This routine was designed to act as a numbers-only mask for any TextBox Keypress event. Simply call it from any KeyPress event and feed it the KeyAscii return value.

This code duplicates the functionality of VB6's split function.

upload image(jpg) create thumbnail and store both in a database. Also can view images in database

FormatFileSize: Formats a file's size in bytes into X GB or X MB or X KB or X bytes depending on size (a la Win9x Properties tab) * UPDATED Sept. 12, 2000 * to allow for overriding the default Format Mask.

It will erase any non-alphanumeric characters from a string rapidly. Usefull if you want to check strings for non-valid characters. Strings such as email or web addresses, you can even make so that only numbers can be entered in, for example, a text box.

This code is just for fun, it demostrates an interesting phenomenon and some ways to manipulate strings, and arrays. According to research at an English university, it doesn't matter in which order the letters in a word are, the only important thing is that the first and last letters are in the right place. The rest can be a total mess and you can still read it without a problem. This is because we do not read every letter by itself but the word as a whole. This works with nearly every language. IMPORTANT: A similar program was posted a little before mine, but I posted mine without knowledge of that, and without seeing any portion of the code. This program (and I'm sure the other one too) was inspired in an email that got forwarded around the world a few days ago. The main difference between my program and the other one is that this one uses a byte array and totally randomizes the order of the words, the other program merely reverses the order of the letters. Thank you.

RECURSIVE DESCENT PARSER FOR NUMERIC EXPRESSIONS

Converts a name or word string to a four digit code following Soundex rules. Similar code is used by geniological groups and the US Census Bureau for looking up names by phonetic sound. For example, the name Darrell can be spelled many different ways. Regardles of how you spell it, (Daryl, Derrel, Darel, etc.) the Soundex code is always D640. Therefore, you assign a field in your database to the Soundex code and then query the database using the code, all instances of Darrell regarless of spelling will be returned. Refer to the code comment section for more information.