Results for "Category: String Manipulation"

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

Compare using wildcards like * and ?, ranges like "at[0-99].gif", and a new wildcard %. Which is like *, but goes only at the end. "at%" would be like "at", and also "atquaz".

The Replace-function in VB6 is an extremely useful in many occasions, but unfortunately, it is as most string-functions in VB rather slow. Therefore I’ve tried to optimize this operation, and I must say the result is satisfying – it is nearly 50 times faster replacing 35.000 characters than the native Replace-function. The code should also work in VB5, where the native function doesn’t even exist.

That's right, all positive long values up to 2147483647. This simple algorithm can translate any positive long value to its string equivalent, both English and Spanish. The principle is simple: Process three digits at a time because the cycle is repetitive every three digits. The only thing you have to append every time is the order qualifier: Thousand, Million, or Billion. The code of the main function is commented, and the other functions are just plain very easy, so no commenting there. The user interface shown here is very simple because the object of this post is the functionality! :) BONUS: Included (and made just for fun) there is a custom uppercase function. It was programmed under the principle that switching between lower and upper case, all you have to do is flip bit &H20. It also writes to the source string directly by mapping an array to the string buffer (advanced stuff). I did not benchmark, but supposedly, this upper case method should be a lot faster than regular string manipulation, although I don't know if it is faster than the VB upper case function. If you want to implement this in one of your applications, all you have to do is drop the module in. Please vote and comment. UPDATE: Run-time error 9 in uppercase function solved. It was a silly error.

With the help of SPA Simple Paging Class you can easily implement stylish paging on your site within 30 Seconds!!!. Implementing the paging class is one of the easiest task, and it does not require too many customization. It just takes a table name, or a SQL script as input returns the number of pages. The paging class can be used on a single table or even with custom simple / complex SQL statements. ie. it now Supports JOINS, Nested SQL, UNION etc... Advantages 1.Easy to use – with just 4 simple steps. 2.Supports CSS – That means you have total control on the look and feel. 3.The code generated is 100% compliant with W3C XHTML standards. 4.Supports single table, custom SQL, Nested SQL, Joins, Union. 5.Built in support for English, and French languages. 6.Ability to easily add support for other languages. 7.Automatically includes existing query strings. 8.Supports multiple paging on same page!!! Disadvantages / Known Issues 1.Current development version support only MySQL database.

Maintain the Student Records.

Have you ever need to convert a binary string to HEX? Doing it in VB is quite simple but a lot slow. I'm using this class to exchange XML data from serial I/O apps with high performance.

UPDATED!!!! Keeps records for students : number name lessons:grade,date save to file everything

Photo Album Database Using Xml. This program demonstrates various things in C#; Xml Serialization, Storing Binary Data into XML file, using MemoryStreams to handle images. u can add albums and add photos in an album and give descriptions for both albums and photos. It's not finished yet, needs some easy touches; Edit and Delete for albums and Images, Input validation. I'm working on them beside seeking for a better method to handle XML instead of In-Memory to boost the performance. Read the ReadME.txt file for more information on how to use the program Hope u enjoy it :)

This code is made up of 2 new VBScript classes, the other VBScript class - clsSortableTable.asp was submitted by another user and works great. The first new class - clsDynaEditForm.asp creates an HTML form based on any table/view in the database and can even validate selected fields. The other class - clsUpdateDB.asp is then used to update the database.

Often I use flat mdb files to post forms to on the webserver. This is a simple page to just grab a table from an mdb file on the server with a DSN-less connection and display it as an HTML table, so I can copy the table and paste it into Excel or Access, or just to get a quick look at the contents.

A very simple database search tool. If you wanna learn how to search, sort, and write a database, download this now.