Results for "Category: String Manipulation"
This program searches an XML database for a keyword and returns the results. It uses the framework's XML classes, and a few regular expressions.
Most users especially those bigenners with vb.net asks how to use DAO with vb.net
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.
Main idea of Metamorphosis.ApplicationBase is to provide .Net developer set of base classes for creating database interfaces almost similar to MS Access and way of developing data forms as simple as in MS Access. You can create "Single Form", "Continuous forms", calculated bindings with any formula (through VSA), Master-Child functionality and so on. For more details see ReadMe.Doc. Also example for Northwind database included.
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