Results for "Category: String Manipulation"

If you are looking for a simple solution to display data and be able to sort and query it, you are on the correct page. Complex relationships between recordsets can be viewed using this technique. It is easier to use compared to ASPDB solution. Download Complete source code and explanation.

This article not only includes the complete source code for a database driven web site that the author created, but includes a detailed description on how it works!

The zip includes an Expression Parser Class that parses and computes mathematical expressions (such as "-pi * sin(50 + 3 * 4) / -3"), and a demo client application. The parser supports built-in and user defined constants and built-in functions. Also, it demonstrates a variety of error-handling and VB tricks.

Increments text string with alpha and numeric characters.

View any font with custom height, width, slant, boldness, and color. This uses some API, and is very well commented. Check it out.

Here is are two nice functions that will convert Decimal values to binary and binary to decimal in a surprisingly short amount of code. Comments welcome. Please

Takes a string and evaluates it, thus giving the user an answer to a string such as "hsin(1)+hcos(1)", which will be e. The evaluator incorporates an error handler, as well as user entered constants. The function is in the module, easily made to be imported to other programs. A demonstration program is included an shows some possiblities. A help file is not included, but will be available by e-mail. An important point, to keep in mind, that almost all functions must be entered in form of sin(45). If a function has one argument, enter it like sin(45), otherwise, put first argument, function, second argument, as in 2+1.

Hi folks I have searched many sites for storing a picture into a database and retrieve the same. But I got some tutorials when I searched the web. Using the tutorials I have a made one for me. It was implemented using Php and Mysql. I will tell you want is the job of each files. 1). index.php This files links all the files in the project. 2). store.php This does the job of storing the picture into the database. 3). viewadd.php This file shows the entire picture stored in the database. 4). getpicture.php This file actually gets the file from file in the form of picture 5). mdbc.inc.php This is a class file for Mysql feel free to use. I got this over net. Here is the table description Id - > has the picture id Description -> has the picture description bin_data -> picture data filename -> picture file name filetype -> picture file type. Like gif or jpeg etc link -> you can store the link incase if you want to use this for ad exchange showno - > no of time ad show etc clickcount -> no of time the ad being clicked etc Query for the table. CREATE TABLE ads ( id varchar(15), description varchar(255), bin_data LONGBLOB, filename varchar(50), filesize varchar(50), filetype varchar(50), link varchar(255), shownno integer(5), clickcount integer(5), unique(id) ); If you want to see a site where I have implemented please have a look at the site http://www.asksathia.com/ Feel free to change anything in the code. If you developed a better version than this please send me the source code so that I may update myself. It took me much time when commenting the code of ease of understanding. Please vote for me. Regards Imthiaz Rafiq [email protected] Msn id: [email protected] Yahoo id: imthiazrafiq ICQ: 24294947 URL: http://high-flyer.da.ru/

This Example will Demonstrate how to use the OLEDBConnection, OLEDBDataAdapter, OLEDBCommand and DataSet Objects -Querying/Adding/Updating a Access 2000 Database. Uses System.Data.OLEDB Namespace and the Listview Control. Any Suggestions drop me a Line

This Project is an example of a Simple Multitier Application using a Business Rules Layer and Data Access Layer, to provide scalability to your applications. It uses SQLDataAdapters, DataSets and SQLCommands to Achieve the DataTransfer. The GUI Uses a Listview to Display the Dataset.

This small function will strip out the unreadable characters and return readable characters in a string. This works great for stripping thoes little boxes out of the text that you just snagged from a web page. I know that a lot of you have used my code, but have not voted. It would be nice to see some feedback in the form of a vote. Thanks.

This little App will breakup a long string of text into lines of text. The length of line is set on the form. The output is sent to the clipboard. Copy a string of text and paste it into the text box on the form. Click on RUN. The application will count the number characters in your text and tell you how many lines of text were generated from that text. The line never breaks on a word.

Demonstrates how to add an item to a listbox in any desired index. (i.e. Add an item between the 2nd and 3rd item in a listbox.) Demonstrates how to shuffle/rearrange items in a listobx (i.e. Moving an item "up" or "down" the list at runtime).

This will generate a unique serial number from your username! This is very handy for protecting your software! The code is fully commented so u can see what the hell is going on :o)

This article shows various connection strings, used to connect to various databases in Windows, as well as methods to access and modify data. Some connection strings may require client software to be installed, but most work with Windows 2000.

I modified some database paging code I found on Planet Source Code so that it was a little more straight forward. Included is a sample code file and a sample MS Access 2000 database. Paging allows you to display a specific number of records from a database at a time. For example, if you have 1000 records, you can allow it to display 10 records at a time so you don't have a huge page display. If you're smart, you can add sorting features like the ability to display records starting with 'A' only, but this will get you started.

This page allows you to view and sort all of your tables in an SQL database

This is a combination of InStr and the Like operator. It returns the position of a mask within a string. The parameters are all user friendly variants just like the regular InStr function. Example: InStrLike("Test String 123abc45 Stuff","###*##") returns 13, because 123abc45 matches the mask and it starts at character 13. Hope this is useful to somebody.

This takes 2 strings and returns the percent alike that they are. (i.e. "test string number 1" is 86.48% similar to "teststring numb 2") This function is very useful! You can use it in databases to match data that may have errors in it. Examples being people's names, company names, addresses, or anything else where you may encounter misspellings or inconsistencies in the data. Your feedback and/or votes are greatly appreciated! -- NEW - updated to use byte arrays instead of strings, 50-300% performance improvement! An implementation of the , Ratcliff/Obershelp/Levenshtein method.

RevEx - creates a random alphanumeric string based on a pattern. Think of it as regular expression pattern matching in reverse. Useful if you need to create a random combination of values in a certain format. Letters (lower/upper case) and decimal numbers or any combination or part thereof: boolean, hex, octal values; dates, times, vowels, consonants, phone numbers, zip codes, GUIDs; IP, social security, credit card numbers ... PLEASE VOTE OR COMMENT, THANKS!