Results for "Category: String Manipulation"

The following procedure acts similar to strtok in C++. Call it once with your string (S), and then everytime you call it from there on out, you can break your string apart with tokens! Included is a function StrMid() and an overload for StrMid that simulate the Mid() function in Visual Basic.

After playing with ASP .NET's Data Grid, I figured I'd create something similar for use with ASP. I've begun by creating the properties and methods to reproduce the most commonly used and useful features of .NET's data grid. Easy to run examples included. Updated 10/28! 2nd version which allows column headers to be rendered as sort by links. Updated 12/27! Now can customize error message and display. Updated 2/21! Class optimized.

This code shows you how to access MS Access MDB database files and use SELECT stements to retreive records from tables. I've seen alot of poor examples here and i couldnt get most of them to work or working to do what i needed. Also, this gives you an easy way to make a cgi type program that you can use on your web server.

This code will search trough an MySQL database and display the number of results as you want. You can say i want a limit of 25 results. If there are more results this script will print : 'Previous' 1,2,3,4,5,etc. 'Next'. I quarante you that this code works for 100%! If you want to see this code alive you can visit one of the sites i.ve made : http://www.yipee.nl, this site uses this code on several pages. If you like tjis code, please vote for me.

Manage all your databases with this visual MySqlviewer. Create/Drop database, Create/Drop/Rename table, Create/Drop/Edit/Rename field, view all records. Nice DHTML scrollbars.

Professional programmers in the industry use serious project management software tools to coordinate development efforts. This is not one of those tools. Of course, it won't put you back several thousand dollars either. The main value to be had here is that Project Notebook is an excellent demonstration of data-binding in C# (something I was unable to find elsewhere). DataGrids, DataSets, Listboxes, Combo Boxes, Edit controls are all wired up together with very little explicitely-written code. Data is persisted as XML using a schema built in the .NET GUI. While all this database-related stuff is kind of dull - this is exactly the kind of thing that you would want to know about if you were writting any editting tools for game development.

UPDATED - May 17,2002 - I just added a SQL INSERT example VIA web form! Enjoy! Please leave comments and vote. Thanks! The zip file contains 6 working examples of various things dealing with the SQL Server. In the package, I also included a file that you can import into your database to use the same tables,columns and rows that I have used. Other Notes: - Examples One, Two, and Three have extensive comments. The examples following those contain no comments because they are exactly the same, except for different control names and types. - In each file, make sure you change the connection information. (Username,Password,Server..etc) I will update this with new examples, such as inserting, updating, using stored procedures and more! This took hours so please vote and leave comments!! Note: It is recommended that you know something about ASP.NET.

DataEasy_VB: is an application written in Visual Basic.Net (converted from the c# similar submission as some of you requested) which would allow the user to load any Microsoft Access file (file format '.mdb'). This application uses OleDb as a backhand communicator with the file to allow the user to : select, delete, insert and modify the database and then save all the changes to the original file. Along with the Data Grid control TextBoxs and Labels are generated automatically and dynamically at run time to allow easy and efficient data input according to the data in the .mdb file loaded. If the file has more than one table in its database, a combobox in the application will allow the user to choose which table to work on. By right clicking column headers who’s data type is either ‘integer’ or ‘DateTime’ the user can opt for either inserting Automatic numbering based on previous cell’s value incremented by 1 or insert that day’s date automatically in their respective column on adding new data. Also provided a Search and Filter capability, by right clicking the search form’s column headers the user can filter in the element (of the column clicked) he\she wants to view. Multiple filtering can be done by filtering more than one column. The user can also use a simple search, by typing in the search textbox to find data in the database. I have included a database file ‘textbooks.mdb’ file with the application so you can try the program. I hope this program will be useful in learning how to load and modify databases and link to ‘mdb’ files, your votes will be highly appreciated :).

DataEasy: is an application written in C# which would allow the user to load any Microsoft Access file (file format '.mdb'). This application uses OleDb as a backhand communicator with the file to allow the user to : select, delete, insert and modify the database and then save all the changes to the original file. Along with the Data Grid control TextBoxs and Labels are generated automatically and dynamically at run time to allow easy and efficient data input according to the data in the .mdb file loaded. If the file has more than one table in its database, a combobox in the application will allow the user to choose which table to work on. By right clicking column headers who’s data type is either ‘integer’ or ‘DateTime’ the user can opt for either inserting Automatic numbering based on previous cell’s value incremented by 1 or insert that day’s date automatically in their respective column on adding new data. Also provided a Search and Filter capability, by right clicking the search form’s column headers the user can filter in the element (of the column clicked) he\she wants to view. Multiple filtering can be done by filtering more than one column. The user can also use a simple search, by typing in the search textbox to find data in the database. I have included a database file ‘textbooks.mdb’ file with the application so you can try the program. I hope this program will be useful in learning how to load and modify databases and link to ‘mdb’ files, your voting will be appreciated :).

This code allows you to input strings with apostrophes into a database.

Scripting engine based off pointers and OP codes. Updated 4/6/02(I fixed the order of operations problem, I think:)

View, Edit any table in a MySQL database. Code is parameter driven, so you select what tables and what columns to display. Primary keys are always needed but those are hidden.

This is a simple as it can be an HTML based news letter sending application made in Asp. Add this functionality to your web site to send news letters to your site members. This app has a client side where members can subscribe to your news letter and an admin side where you can monitor every thing. The administrator has a complete control panel to operate it. To See Admin's pass plz open the db and you will find it there. The Admin has following functionalities: Add Admin, Add Member(Subscribe Member)/unsubscribe/edit info etc, Send News letter to all the members in the list. The news letter can be in boht text/html forms. You can create your html basd newsletter in any application then copy paste its html code in the news text box and send. Thats it! ===============> This requires CDOnts.dlll to send the news letter using cdo messaging. gets the list from MS Access database in the db folder and sends it. Very simple to use and integrate , I hope this helps people out, dont forget to rank it 5 globes.

parse a string with a delimiter... choose your own delimiter and replace it with whatever you want to. Very basic.. but it works. :)

This class was created for the main purposes of having a controlled "stack" (like the stack, or memory heap in a computer). It will let you push items onto the stack, pop them off, and retrieve the number of items on the stack, and more. I'm pretty much a beginner here, so tell me what you think.

This code lets you easily create text-tables for text documents or even comment-formatting in VB. This will automatically center your text in the table. *No error checking has been added, sorry!

Learn how to Install MySQL, import an Access database into MySQL database, and display data on a ASP page. Step by step tutorial with screenshots! Please leave questions or comments.. Updates: I have included a dsn-less connection!

This a simple way to page in MySQL, its hard to find how to do this in MySQL and ASP so I wrote it and am now sharing it with you! It is my second post regarding MySQL. If you would like to learn how to setup MySQL and import an exsisting Access database you may find it here: http://www.pscode.com/vb/scripts/ShowCode.asp?txtCodeId=7739&lngWId=4 Please leave any comments if you find this code useful! Thanks for stopping by.. -Jason

ADO & VC++ Connection I'm not using ODBC, VC++ tries to connect to Access file with ADO Objects. I know part of the code has been submitted before, but the current project it's opening in a Window instead of DOS console. Plus I'm not using ODBC stuff. Thanks =)

This example showes you how to access a Microsoft Access Table using a C# class. Any feed back will be appreciate. Do not forget to vote !!!