Results for "Category: String Manipulation"

Shows how to get recordset data into a VB (or other) application from remote databases on the web, edit it, and put back the changes - all from simple ASP pages on the server via HTTP using ADO + XML - 1 line of code in VB to retrieve, 3 to return (+ not more than 25 lines of ASP on the server) for the simplest case. Requires :IE5 (IE4 will not work!), ADO 2.5+, XML (3 preferred) on Client PC / IIS4+ or PWS, ADO 2.5+, XML3 on Server

the engine i am providing is an asp code generator that i am currently using on my website (www.intratelligent.com) to allow asp developers to upload access databases online and build simple asp interfaces to interact with their data. (insert / update / delete and reporting functionality). although it is coded in vb, it can be compiled into a dll to be used as an object referenced by asp. otherwise it can be run as a stand-alone vb app. i have included a screen shot and added commenting to my code to make it more understandable. if you do not have a lot of experience in vb and asp this will be difficult for you to modify although it can be implemented by anyone.

Hello, This is a complete security small webpages I using ASP. Its allows user to enter their username/userpassword, in order to getting further into your webpages. Its also allows new user to creates a very simple account like: User FullName, User nickname and User password. I hope that it will gives you ideas to program better in ASP. Thank you for using this Tri Nguyen PS: Please dont forget to rate and drop me a line for this my friends!

Compact and Repair You can use the "Compact and Repair" function in Access from ASP code. The following code is an example of how this can be done. Note that when you decide to "Compact and Repair" your Access database, some autonumbers can be changed. Access makes all autonumbers consecutive. This code uses one database, but I'm sure the code can easily be changed so that the listbox displays, for example, all the databases in one folder.

After digging around and trying to find a decient multi word search function, I ended up building my own. This ASP page and database splits the words up and combines them with a SQL query string. It also allows you to resubmit a search for a "More Like This" link which resubmits the Keywords back into the page and searches for those words within the database Keyword attribute.

This program retrieve the tables and column existing from DSN ODBC. To do, use the OpenSchema method frmo ADO.

This is a small data entry form in Windows XP style for the browser (IE). Addressess basic data base functionality such as INSERT, DELETE and UPDATE, as well navigation thru the record set.

LabDev sBuilder is designed to automate the boring task of building a Form & ASP page to receive and process the values submited; Once stablished a Connection, it generates all the necessary ASP ode for you, to manage a particular table; It generates code for the Form, Request.QueryString & Request.Form, Sql Insert, Update & Delete, and Connection Obj/String :-)

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

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

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

This code snippet will compact your Access DB online. You can do this via a web browser!

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.

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.

Looking for faster performance? If you have an older database driven ASP app, it probably uses an ODBC DSN in its connection string to reach the database. It probably looks alot like this: "DSN=myDSNName;". If you see this you should immediately upgrade the code to ADO/OLEDB--Microsoft's new standard. Not only will this help you keep the code current, but it will run faster and take up less memory. Below are the connection strings for OLEDB/ADO for both Access and SQL Server--the two most common databases for IIS platforms. If you are using another database, you'll need to consult your db's ADO Provider's documentation for the proper connection string.

Display a page that allows you to type in a SQL Query statement, and display the results in HTML Table format. The number of field parameters and field names are immaterial. It will display the results in an easy to read format. Great for customer reports. The Code will not allow an Update or Delete query.

Teaches you how to allow your users to build a dynamic sql statment for searching your database, paging (nice little auto paging function I wrote included), dynamic sorting, etc... Access 2000 sample database included.

Simple ASP codes showing "Survey" and online quizes

Have you ever had a serious crunch time for writing code and finishing the project on time? Then this may help you out a bit especially if you do a lot of work with data storage. The basis and structure of this code can also be used for many things. The main object we will be working with is a collection object,(namely the Request.Form collection). This can also be used with Arrays and Session variables and anything that can hold a collection of values. You will see how we go through each item in the collection and assign the data that that collection variable is holding to a database with fields matching the same name of the items in the collection. The For..Each..Next statement is a very powerful method that can save you a lot of time. Have fun with this and fill free to use it in any variation you see fit.

This is a task manager online. What this does is allow a group of people working on a rather large, or even simple project to put down tasks or ideas that are related to their project. I use this for my school assignments and the current web site that a group of my friends are currently working on. This Task manager has a whole lot of features that have not yet been implemented but you have the ability to add tasks, asign yourself to tasks and also edit tasks (if you are working on them). On the main screen you will see a list of all the tasks sorted by importance. If you wish to sort the list by a different order, just click one of the headings ('In Charge' 'Date') etc. You will also notice that according to the level of importance, the colour differs (red for level 1, yellow for level 2, green for level 3). This code teaches how to use SQL statements to access, update and insert data into a database. It teaches how to use the server() function in asp, and also teaches how to use cookies for login purposes. This code is fully commented, and if you would like any more information or wish to contact me, please email me at festie69@hotmail.com