Results for "Category: String Manipulation"

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 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.

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

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

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.

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 :)

Simple Data Entry application using untyped datasets. Shows add,delete,edit,find,update,cancel,navigation and databinding procedures.

This class provides an easy way to access OLEDB Datasources (you can change the code very easy to access SQL-Server). It shows you how to work with destructors, constructors, dataset, stored procedures, own stuctures, Oledbcommand, datarelations, overload subs(functions). Download this at www.visualsoft-net.de under VB.Net Code

This Code shows you how you can create Pie Charts Graphics and PDF Exports out of an OLEDB-Datasource with vb.net on the fly. For the datasource i've used the Northwind.mdb. The connection string is persisted in the app.config file and has to be changed after the download to get the code up and running. For the PDF Export I've used the freely available itextsharp library. The Pie Chart is generated by GDI+ so no expensive 3rd Party Products, follow the instructions in the readme.txt. Download this and much more source code at www.visualsoft-net.de (plz Rate)

This is a web-based version of Enterprise Manager for SQL Server and MSDE. An online demo is available at http://www.aspenterprisemanager.com/. This is an Open Source Project in VB.Net, ASP.Net and ADO.Net that is in the early stages, so any contributions, feedback or additions are greatly appreciated. ASP Enterprise Manager will allow you to create and edit tables, stored procedures and views, manage logins and database users, manage basic permissions, and query your database returning multiple recordsets. This is the version 0.5.0 release of the code and structures most of the code with better .Net structures (on most of the pages), introduces a class structure (I am working on documenting the classes), cuts down on the number of connections that are made to the SQL Server, introduces an XP style interface and adds a few new features and interface enhacements. This code is not a Visual Studio Project so it only requires the .Net Framework, Someone is also working on a version of this project as a Visual Studio Project using C#, that code can be downloaded from the website (http://www.aspenterprisemanager.com/)

To learn database in VB.net easy to add, edit, delete using OLED connection

Return a dataset from an excel spreadsheet using OLE DB and a "named region" as a table

This Code will help the programmer to insert the image into a Sql Server Database through DataReader in VB.NET

Upload and Download BLOB [files] to an Access Database. Handles any file type. Instructions included for implementation under VS.NET, WinXP, IIS 5.1 and .NET Framework SP2. Includes a class to set database connection dynamically and is almost fully documented. Not a great implementation, but does the job and provides relatively straight forward processes for providing this functionality in your WebApplication. Have Fun :)

This program read a xml file and stole it in a datagrid with all structure.Is a great program

This program searches an XML database for a keyword and returns the results. It uses the framework's XML classes, and a few regular expressions.

Most users especially those bigenners with vb.net asks how to use DAO with vb.net

This is a simple VB.NET application which demonstrats handling local database (I used MDB). I think this example will be a great help for extreme BEGINNERS. (Env: Visual Basic.NET Express Beta 2005)

This program demonstrates using an XML document as a database. The example uses a fake forum database and allows you to view all of the members, view member information, edit a member's information, remove a member, and add a member.

Main idea of Metamorphosis.ApplicationBase is to provide .Net developer set of base classes for creating database interfaces almost similar to MS Access and way of developing data forms as simple as in MS Access. You can create "Single Form", "Continuous forms", calculated bindings with any formula (through VSA), Master-Child functionality and so on. For more details see ReadMe.Doc. Also example for Northwind database included.