Results for "Category: String Manipulation"

This is a page I wrote that works like a recordset. Yet I know this is not the most effiecient way to do it but it works. If you have a better way of doing this I would be interested in seeing it. You will have to change the database, Tables, and Fields to suit your needs. Requirements: PHP and mySQL

*UPDATED* This example shows you how to Save, Add, Edit, Delete, and Search for records in a SQL Server Database from a user form. It also shows some basic stuff with the new DataGridView. Allows you to click a cell retrieve cell location, header text and row content. You will need VS2008 and SQL Server 2000.

Checks to make sure the contents of a TextBox or String are only standard ASCII; If it has any extended ASCII, the function will return False.

Do you have slow running mulitple SELECT Statements or long reports to fill on a web page. Use the Microsoft Shape Command. Learn to use ADO 2.1 and greater advance features. This code is great for three things, (1) Very fast way to do multiple SQL select statements and reports. (2) Great for databases not Normalized. (3) Avoids multiple nested single threaded ADO Record Sets loops which are very slow.

This is an update to Kurt Joseph Serge's word counter code that was long, clunky and not entirely accurate. Takes a string and counts the "words" (characters separated by spaces) in it. Take a look.

Consists of two files sql.htm and tsql.asp. Nice little interface with any SQL Server database. Returns result sets, etc. If you find the code useful please rate the code.

Easy Forums is a fully functional message board system, developed using MS Active server pages: Features: - Authenticated login to registered users and facility of registration of new users - Sorting the Message board threads on the basis of Date, Email, Name, Subject etc. by a single click - Allows users to post new messages and reply to old messages. Feel free to modify, distribute, use this code as you may please, and if you like it please VOTE FOR ME in the contest.

This is to teach you how to connect to your mysql database and select a table. I have made it very clean and added comments to help you understand the process.

This is a basic drag and drop demo. It is written to recognize what type of file is being dropped and only excepts exe's but you could modify it to excpet any file extension. I think I commented the demo well enough for everyone. I hope it's ueful. Saturday, March 31, 2001 I added a few more lines of code for the ".EXE" statement because there are 2 kinds of exe's! Upper case and Lower case! It sounds funny but i have both kinds of exe's on my machine so i thought i better fix this little bug! I Also added a Progress Bar! Peace, jim byrnes

I was tired of writing code to execute store procedures so I wrote these functions that do most everything for me. Just supply the stored procedure name and an array of parameter values. Also provide a recordset or return value variable depending on what function you are using. SAVES ALOT OF TIME! There are some examples subs at the bottom...

the sample will show how to display message fromt he database when a user logs in and how his session will get expired and after session expiration he was not able to read hiw messages until he logs in again

Provides functionality to have a buffer of Undo's in your application so users can go back as far as they want and redo their actions again....

The SpeedString class boost performance on string concatenation. Almost every VB developer uses strValue = strValue & NewData as concatenation. The SpeedString class does the same, but a few hunderds times faster (something up to 1000 times). This project demonstrates the use of my SpeedString class and compares the execution times of both methods.

This code delete duplicate records in MSAcces database.

This is a program to make totally random passwords out of letters, numbers, or both. Shows how to convert strings to lowercase, make a scrolling, typing, caption effect and how to use random numbers.

A very simple tutorial on how to print report using crystal reports in VB.NET

Takes a number and returns a word expression for that number. Example: 123.01 returns "One Hundred Twenty-three And 01/100". Very useful for printing checks.

Get the statistics of your code. Find out exactly how many lines it is. It is easy to modify this project to include other file types etc.

This will get various statistics about your code, from how many blank lines you have, to how many variables you have declared. This is basically the same as my last version (Code Statistics v3), with a few improvements on the code scanner, and a new feature that lists the amount of variables you declared but never used. Just a note though, it will also list any unused event parameters. Let me know what you think - Eric

This function takes a long string of text, splits it up into lines for printing or displaying, then returns the new string. Like the newspaper, it doesnt cut off words, it carries them over to the next line. It includes a function to check for the longest word so you dont accidently ask for a column width smaller than your largest word.