Results for "Category: String Manipulation"

This is a small example of how to get input from visitor at your site, search a database, and send them the results.

when you use string variable in VB to handle large string values the process take long time and as the variable go larger it take more time MyVar offers faster handling for string data

This project builds menus by reading from an Access Database. It creates a pure HTML dropdown menu and a treeview which uses HTML and one tiny Javascript function. It will show basic database functions using the new OleDB functions and objects of dot net.

This code shows how can power up databases applications with XML . It use common and simple way to send and receive data, in xml form over HTTP and convert it to html using XSLT

This script takes the contents of a MySQL table and dumps it to either a dynamically-generated MS Word File (file with ending '.doc') or a dynamically-generated MS Excel File (file with ending '.xls'). You can place this script on any Unix/Linux or Windows Server running PHP & MySQL, but you have to access it using a browser on a Windows computer with Word or Excel installed on it. This script does not use COM objects and does not support multiple Worksheets in Excel. It can be used not only for creating complete dumps of MySQL tables (as Word or Excel files), but can be very easily modified to support just about any kind of select statement you'd like to use.

With this extremely easy code, you can erase a character at the end of a string or in a textbox with a click of a button. Very easy code and every line is commented. DON'T forget to vote.

Paste the contents of a plaintext document into the main multiline text box, click "Parse," and this program creates an array for each unique word and the frequency at which the word occurs in the string. I made this to check my own writing for over-used words; if you're a writer you may notice how you tend to use the same words over and over again; in conjunction with a thesaurus this could be a powerful tool to liven up your use of vocabulary.

This is a Dynamic Data Layer class library that would be used on a Web based multiple tiered application in conjunction with SQL Server. It includes a TSql Script for three supporting stored procedures as well as source containing several classes. Basically it queries the parameters of stored procedures and holds a static dataset with multiple tables to populate the parameters collection automatically while the web application is running. These can be updated by calling the update method for new or change parameters. During the development cycle no parameters ever have to be recoded due to changes in the requirements and new components never have to be coded.Bottom line is this library cuts 33% of development time on a Multi Tiered application.

Ever too tired to control user's input? Ever want to control maxlength of a combobox? Ever want to validate and correct and hint(optional) user's input automatically? This is what you need to control user's input with textbox, combox etc. I am working on it and have figured out many improvements that can be done if you are so kind to rate it! Any comment or vote is appreciated! Please vote for it if you guys desire a much better version :-)

Simple user Registration form..., Database that used is Access 2002

This system will teach you how to: Populate the DataSet programmatically instead of with a wizard, Using stored procedures, fill a DataSet with complete tables from the database and then create relationships between the tables, Write the business logic to dynamically build a SQL statement to fulfill the user's criteria given on the Search Screen, Fill a DataSet with the results of the SQL query, Verify in the Output window that the data in the DataSet correctly reflects the user criteria entered on the Search Screen, Simple and complex data binding, Building the Add/View/Edit Products and Suppliers Screens, Using the ErrorProvider control to validate user input, Using DataViews to filter and sort data in the DataSet, Using the DataReader to return a single record, Updating a DataSet based on user input, Allowing the user to add, edit, and delete data in the DataSet on the Add/Edit/View, Products and Suppliers screens, Creating a second dataset that contains all changes made by invoking the GetChanges method, Checking for errors in the changed dataset by checking the HasErrors property, Saving the changes in the DataSet back to the database using Stored Procedures, Accepting or rejecting the changes made based on whether the updates were successful and Handling any errors that occur. Using Northwind SQL database

This project demonstrates how to remove the repeated characters in a string. A progress bar is included so you can know the progress of the operation. Great for beginners. VOTE IT IF YOU LIKE IT! THANKS!

Generate random passwords. You'd better check this cool GUI.

Function that counts the occurrance of a given phrase in a larger string. (I needed this function and couldn't find anything like it in MSDN for VB)

This SQL formatter Add In formats your SQL in various formats

This code shows you how to create nearly Unlimited Undos and Unlimited Redos, along with Cut Copy, Paste, and Select All features, in a RichTextBox Control. This code was originally programmed by Jason Shimkoski, it was updated by me when I discovered an error in his program.

Datagrid with sorting, paging, highlighting cols when mouseover, stylesheet, change fontcolor of dataitems when a if then function is true.

Formatting text with various alignment and margins. The standard TextWidth is not accurate, specially if you want text justified exactly. With API functions is very simple!

This code will allow you to track users without having to go into the IIS logs and looking trough the hundreds of entries just to find out what pages the users viewed, and/or to track them at the point where they left or contacted me about my products (web design). This code has two parts, the database insertion and the database viewing. Database insertion A server side include is inserted into every page that I want tracked. The code runs immediately upon the user visiting the page that has the include, once the page is requested an entry is automatically made into an MS Access database writing all the variables that will allow you to determine what the user did or the pages they viewed. Database viewing. You can later view the variables stored in the database using the default.asp which is included in the /users/ folder. It will allow you to view the visits in descending order; from there you can choose to look at the each user’s information. By clicking on the IP address you will be able to see where the visitor came from, such as country, region, etc. By clicking on the VarID you will be able to look further into other variables not displayed on the first page. I am currently working on this project, the final copy should have reports by # of visits by IP, most pages request etc. Please let me know if you find this code helpful, or of any problems you encounters. --UPDATE-- Due to the increase use of the "User tracking" software, and the problems encountered during installation, I have decided to dedicate a forum especially for it. Feel free to comment. Please give credit if you find the software useful. http://pagedream.com/redirect.asp?site=http://core.pagedream.com:8080

Hi guys, I have decided to update the user tracking system. The updates are: -Prevent database login based on IP address. The reason for this feature is because I got tired of login my own IP and those of search engines. -View blocked IP’s -Delete blocked IP’s -All pages are password protected Note: This code only works on servers supporting ASP (active server pages) 1. Unzip files to the root (warning! If you already started logging hits then your entire database will be overwritten) 2. Go to /fpdb/ open the database, open the Login table, and modify the username and password fields, by default the username is rebel and the password is moon. 3. Make your /fpdb/ directory executable trough IIS management console, this will prevent someone from downloading it's contents, which in this case is the database ServerVariables.mdb. 4. Give the IUSR_Machine account, write permissions to the /fpdb/ServerVariables.mdb database, otherwise you will receive and ODBC error 5. Include this snippet into every page you want tracked. Every page you want tracked must have the .asp extension, otherwise it wont log to the database 6. That's it. Go to http://www.yourhost.com/users, login and start viewing your hits. [b]Download the files at http://dev.pagedream.com/Track_UserVer2.zip [/b] View snapshots at http://dev.pagedream.com Let me know if you have any questions, or problems. --UPDATE-- Due to the increase use of the "User tracking" software, and the problems encountered during installation, I have decided to dedicate a forum especially for it. Feel free to comment. Please give credit if you find the software useful. http://pagedream.com/redirect.asp?site=http://core.pagedream.com:8080