Results for "Category: String Manipulation"

Transactions are atomic operations that allow you to do multiple operations on a database as one operation. For example, if you were creating a banking application in which you deducted $100 from one account and added it to another account, you wouldn't want the operation to fail right in the middle, because the money would be 'lost'! The solution is to wrap the SQL in a transaction. If the operation is aborted in the middle (the pc gets shut off for example) the database will rollback the changes so that the initial account was never debited the $100. This will make you feel good, especially if its your bank account!

You can use ADO GetRows to output and ADO recordset to an array. This is often useful in n-tier applications when you are moving data between tiers--or if you want to persist your data in another way. http://adozone.cnw.com/default.htm

Since ASP is especially good at reading and writing to databases, let's start with a very simple database and scripts that we'll eventually build into a guestbook... Reprinted with permission from http://www.web-savant.com/users/kathi/asp

This is not real RDS but a simulation (Like Access's Not_In_List event). This functions gives the user the ability to 1) Add a new Value into a Database table and 2) update and select the value in the combobox WITHOUT REFRESHING the page from the server. I found this to be a life saver with large ASP pages with comboboxes on them that need to be dinamicaly filled. (You don't have to worry about the controls on the pages)

This code returns a boolean expression that declares if a string is a valid email address or not. It returns true if the string is valid, false if not

This code converts UNIX files to DOS files and DOS files to UNIX files

This code gives a dump(backup) of your local or remote database. I use this in combination with vb to backup my remote database. If you are interested in the vb_code to do so... let me know....

how to do subselects in mySQL

will search a listbox's contents for a string returning a True if the string exists and a False if it dosent

takes a string like "Johnny*(722)555-5555*35" and splits it into columns on a listview control(designed for Report view)

This code shows you how to create Unlimited Undo and Unlimited Redo, along with Cut Copy, Paste, and Select All features, in a RichTextBox Control.

This Code shows, how easy it is to store some dates in a mysql database

This Moves a Forms caption from left to right.

THIS VERY COOL FUNCTION TAKES A NORMAL STRING AND CONVERT EVERY CHARACTER IN IT FROM UCase TO LCase OR FROM LCase TO UCase... CHECK IT OUT!! AND VOTE IF YOU FIND IT USEFUL

I keep reading requests for RichtextBox code on PSC so I decided to upload one of my templates with a few added features. Nothing that special here really - basic RichtextBox functioality. The RichtextBox is pretty good at what it does though ! This example demonstrates : Find and Replace, Infinite Undo/Redo, Using .tmp files, HighLighting selected words, Inserting Images, Inserting text at a set location with different Fonts, Common Editing Functions, Shrinking a path to a desired length, Creating your own light-weight Wizard. This is not meant to be a complete application merely a demonstation of some techniques. All error messages and bugs are provided entirely free of charge. Feel free to use any of the code or errors as you wish - MS wrote the control - I've just shown how you might use it. It's capable of more than I've shown here.

Search a directory for files containing a specified string and return a list of such files. Once again, I've uploaded this in response to a quetion posted in the Discussion Forum.

Syntax coloring, advanced selection routines and Highlighting. Highlighting using the Richtextbox control is awkward. Whilst there are a host of Selection properties there is no Highlight property we can access from VB. We just have to parse the RTF code.

The Richtextbox is a great tool for displaying text but it can be quite a task converting it's format for use on the web. This project is part of a Code Library application that I still use today. It has HTML saving options for publishing source code to web sites. It demonstrates manipulation of the Richtextbox control, string parsing routines and syntax highlighting. It will also format your code applying standard indentation, remove blank lines and truncate long lines neatly, making your code much more readable. You can then choose to save it back to disk as a VB file(retaining it's original header), an HTML file or as a rich text file(rtf). Like all code this old, I would do many of the functions quite differently nowadays, but there are still some handy techniques used here. I hope I didn't create too many bugs when I pulled it out of my Code Library app ! I have had quite a few emails of late enquiring as to when I'll upload some more submissions, so in response to those here is yet another Bobo submission !

Provides a tutorial and applications for implementing a database update strategy utilizing the DataSet, DataAdapter and SqlServer.

This sifts through all the text in a RTF file and changes the colour of html tags. It can be used ewither automatically or on the fly (as you type into the RTF box). It currently Chnages the colour of html tags (defined as anything between "") and html comments (""). Enjoy! Please mail me with suggestions