Results for "Category: String Manipulation"
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
CReplaceString is a function that I decided to code when I was bored. Had no idea what to code so I decided to code an advanced ReplaceString function. The concept is simple, it will replace a specified text in the string with something else.
Use this method with Winsock. Ever had it when you need to send lots of data all at once, and you need individual structured fields for each commands? Does your field data contain special characters or binary data? Conventional methods of delimiting packets simply won’t allow you to get away with that. This code demonstrates how to use Byte Level Delimiting (as I have dubbed it, anyway), and also shows how to buffer incoming and outgoing data, so you can handle large data flawlessly. There is a word document inside the ZIP archive that explains the principle and mechanics of the idea, and also code to demonstrate it. Also uses protocol compression, if the compressed size is smaller than the decompressed size (ZLIB). Feedback greatly appreciated, thank you.
This code snippet will compact your Access DB online. You can do this via a web browser!
This example shows how you can use OleDbSchemaGuid in ADO.NET to fetch Schema information from database. It also shows, how you can use DataGrid control, to fill records from dataset, and also how to update records from DataGrid to database using OleDbDataAdapter and OleDbCommandBuilder. In this example List box is filled with Table names of a Specified Database, and by clicking on the table name, you can fill records in the DataGrid. The wonder of the ADO.NET is that it is total disconnected scenario, and this helps a lot in Web Applications.
This Article explain and gives an example how to create a tool-tips in ASP page includes the data from one or more fields in the database in a grid.
Complete datagrid operation with CURE(Create, Update, Remove and edit) functionality.
This code is do recordset paging with images instead of buttons.The images will be swapped based on the position of the current page.I have also provided a facility to "GO" to any page by entering the page number in the "GO" TEXTBOX.
THIS CODE WILL CONVERT A RECORDSET INTO A CLIENT SIDE ARRAY AND THIS ARRAY CAN BE SORTED AS PER ANY FIELD IN THE TABLE.SINCE THE PROCESSING IS DONE ON THE CLIENT SIDE ITSELF PERFORMANCE IS MUCH BETTER.CLICKING ON THE HYPERLINKED TABLE COLUMN HEADERS WILL CSORT THE RECORDS AS PER THAT COLUMN.
cennection with access database