Tutorial RSS
 

ADVANCED

The Advanced section will help us roll-up the constituent parts of a data driven web page. You'll be able to Connect, Retrieve, and Display data from a data source.

There are many different techniques to get information from databases, xml documents and web services. We needed an entire section to post code addressing the different ways to handle the data, logic and presentation layers. Please search and select from the tutorials below to help you build something powerful.

Navigator: Home - Advanced

DB Tutorials Category - Advanced
Updating Custom Object in SQL Database with VB.NET
This tutorial follows on from the Inserting Custom Object and will show you how to build on that class to add the functionality of Updating Objects in VB.NET
Updating Custom Object in SQL Database with C#
This tutorial follows on from the Inserting Custom Object and will show you how to build on that class to add the functionality of Updating Objects in C#
Inserting Custom Object to SQL Database in VB.NET
This tutorial will show you how to use Custom Objects to Insert to a SQL Server Database using VB.NET
Inserting Custom Object to SQL Database in C#
This tutorial will show you how to use Custom Objects to Insert to a SQL Server Database using C#
Render a Column Graph from DataTable in MSChart C#
This tutorial uses the new MS Chart to render a column graph from a DataTable in C# and ASP.NET 3.5
Retrieving Binary Data from SQL Database with C#
This tutorial shows you how to retrieve raw binary data from a SQL Database using C# and ASP.NET 3.5
Retrieving Binary Data from SQL Database with VB.NET
This tutorial shows you how to retrieve raw binary data from a SQL Database using VB.NET and ASP.NET 3.5
Storing Binary Data in SQL Database with C#
This tutorial shows you how to store raw binary data in a SQL Database using C# and ASP.NET 3.5
Storing Binary Data in SQL Database with VB.NET
This tutorial shows you how to store raw binary data in a SQL Database using VB.NET and ASP.NET 3.5
Export Database to Excel with Console Application in C#
In this tutorial, we will be creating a console application to export a database in a readable Microsoft Excel format. One of the most readable data file formats is Tab Delimited. We will be converting a SQL database into this format.
Using FileUpload Control to upload to Database in C#
In this tutorial, we will be using the FileUpload control to insert images into a database. We will also write another script to display the images from the database. C#.
Binding Data to DropDown, RadioButton, etc. in VB.NET
In this tutorial, we will show you how to display data in form controls from a database in VB.NET. The three most common form controls that can be bound to a DataSource are DropDownList, RadioButtonList, and CheckBoxList. We will show you how to populate these controls and display the selected value(s).
Using Stored Procedures in ASP.NET and C#
This tutorial will show you how to use Stored Procedures over in-line SQL Statements to increase security of your web application, in C#.
SQL Database for Suggestions as You Type in C#
This tutorial will show you how to use an AJAX Extender to provide suggestions as you type in a textbox, similar to the Google feature. C# version.
Calendar Control and SQL to Create an Organizer in C#
This tutorial will show you how to use a SQL database, a SQL database, and the Calendar and FormView Controls to create an organizer to keep track of events of different days. C# version.
Returning Multiple ResultsSets using DAC in VB
This tutorial will teach you how to use Data Access Components to retrieve data from more than one table in one go, which can save on server resources. VB version.
Returning Multiple ResultsSets using DAC in C#
This tutorial will teach you how to use Data Access Components to retrieve data from more than one table in one go, which can save on server resources. C# version.
Creating LINQ to SQL Entities in VB.NET and ASP.NET 3.5
This tutorial will show you how to create LINQ to SQL Entities by hand, instead of using the Object Relational Designer in Visual Studio. VB version.
Creating a Poll with AJAX, SQL and LINQ in VB.NET
This tutorial will show you how to create an online voting system which will take advantage of AJAX and LINQ to allow users to quickly and easily vote for their favorite Political candidate, and be shown who is currently the front-runner. VB.NET
Creating a Poll with AJAX, SQL and LINQ in C#
This tutorial will show you how to create an online voting system which will take advantage of AJAX and LINQ to allow users to quickly and easily vote for their favorite Political candidate, and be shown who is currently the front-runner. C#
Execution Time using Data Access Component in VB
This tutorial will show you how to create your own Data Access Component and also how to display the time it takes to retrieve data from a SQL database. VB version.
Execution Time using Data Access Component in C#
This tutorial will show you how to create your own Data Access Component and also how to display the time it takes to retrieve data from a SQL database. C# version.
Updating with Data Access Components in VB.NET
This tutorial will show you how to create your own Data Access Component that will both read and edit data from a SQL database. VB version.
Updating with Data Access Components in C#.NET
This tutorial will show you how to create your own Data Access Component that will both read and edit data from a SQL database. C# version.
Deleting with Data Access Components in C#
This tutorial will show you how to create a Data Access Component that will both read and delete data from a SQL database. C# Version.
Deleting with Data Access Components in VB.NET
This tutorial will show you how to create a Data Access Component that will both read and delete data from a SQL database. VB Version.
Using the ListView Control to Add Data in ASP.NET 3.5
This tutorial will show you how to use the ListView control to insert new records to a SQL database.
LINQ Deleting from Database using ASP.NET 3.5 and VB
This tutorial shows how we can use LINQ to bypass SQL statements to delete data from our SQL Database. VB version.
LINQ Deleting from Database using ASP.NET 3.5 and C#
This tutorial shows how we can use LINQ to bypass SQL statements to delete data from our SQL Database. C# version.
Creating LINQ to SQL Entities in C# and ASP.NET 3.5
This tutorial will show you how to create LINQ to SQL Entities by hand, instead of using the Object Relational Designer in Visual Studio. C# version.
Using Stored Procedures to Add to Database in VB
This tutorial will show us how we can use Stored Procedures instead of explicit SQL Statements to add data to our database. VB version.
Using Stored Procedures to Add to Database in C#
This tutorial will show us how we can use Stored Procedures instead of explicit SQL Statements to add data to our database. C# version.
Using LINQ to Update SQL Database in ASP.NET 3.5
This tutorial will show how we can use LINQ to update records in a database, using a GridView Control. This examples was written in Visual Studio .NET 2008
Add to Database using LINQ and AJAX in ASP.NET 3.5 VB
This tutorial will show how we can use Microsoft's new technology, LINQ, to easily add data to a database and how we can use AJAX to update the database in a more seamless way. This example was created in Visual Studio .NET 2008 and VB.NET
Add to Database using LINQ and AJAX in ASP.NET 3.5 C#
This tutorial will show how we can use Microsoft's new technology, LINQ, to easily add data to a database and how we can use AJAX to update the database in a more seamless way. This example was created in Visual Studio .NET 2008 and C#
Exporting a DataGrid to Excel in ASP.NET and VB
This tutorial will show how we can export the data displayed in a DataGrid into an Excel worksheet at the touch of a button. VB version.
Exporting a DataGrid to Excel in ASP.NET and C#
This tutorial will show how we can export the data displayed in a DataGrid into an Excel worksheet at the touch of a button. C# version.
Implementing a Pager with the Repeater Control in VB
This tutorial will show how we can add a pager to a repeater control, and use a querystring value to move between the pages. This method is much more SEO-friendly than using postback, like the built-in GridView pager. VB version.
Implementing a Pager with the Repeater Control in C#
This tutorial will show how we can add a pager to a repeater control, and use a querystring value to move between the pages. This method is much more SEO-friendly than using postback, like the built-in GridView pager. C# version.
Introduction to the GridView Control in Visual Studio
This tutorial introduces you to ASP.NET's GridView control, showing how easy it is now to display data from a database.
Using Nested Repeaters to Display Hierarchical Data C#
This tutorial will show how we can create a relational hierarchical structure using nested repeaters. This is useful for such an implementation as a structured menu system with different levels (categories and sub-categories). C# version.
Using Nested Repeaters to Display Hierarchical Data VB
This tutorial will show how we can create a relational hierarchical structure using nested repeaters. This is useful for such an implementation as a structured menu system with different levels (categories and sub-categories). VB version.
Add/Edit/Delete Access DB, using ADO.NET + DataGrid VB
Learn how to display data from an Access Database using ADO.NET and a DataGrid, and also learn how we can use the DataGrid to add new data and edit & delete existing data. VB version.
Add/Edit/Delete Access DB, using ADO.NET + DataGrid C#
Learn how to display data from an Access Database using ADO.NET and a DataGrid, and also learn how we can use the DataGrid to add new data and edit & delete existing data. C# version.
Populate DropDown List from Database in ASP.NET & VB
This tutorial shows how we can dynamically populate a dropdown menu from data pulled from a database. VB version.
Populate DropDown List from Database in ASP.NET & C#
This tutorial shows how we can dynamically populate a dropdown menu from data pulled from a database. C# version.
Uploading Files to SQL Database in ASP.NET and VB
This tutorial will show how we can upload files to a SQL database using ASP.NET and VB.
Uploading Files to SQL Database in ASP.NET and C#
This tutorial will show how we can upload files to a SQL database using ASP.NET and C#.
Hash table using ASP.NET 2.0 and VB
This example illustrates how to create and use a hash table. Each element of hash table is a key/value pair stored in a DictionaryEntry object. A key cannot be a null reference (Nothing in Visual Basic), but a value can be.
Hash table using ASP.NET 2.0 and C#
This example illustrates how to create and use a hash table. Each element of hash table is a key/value pair stored in a DictionaryEntry object. A key cannot be a null reference (Nothing in Visual Basic), but a value can be.
Making SQL transaction in DB using ASP.NET 2.0 and VB
In this tutorial, we will show you how to make a Transact-SQL transaction in a SQL Server database. We will use ASP.NET 2.0 and VB.NET in the sample.
Making SQL transaction in DB using ASP.NET 2.0 and C#
In this tutorial, we will show you how to make a Transact-SQL transaction in a SQL Server database. We will use ASP.NET 2.0 and C# in the sample.
Save image to database in ASP.NET 2.0(VB)
This tutorial will show you how to save image to a SQL database using ASP.NET and VB.NET.
Save image to database in ASP.NET 2.0(C#)
This tutorial will show you how to save image to a SQL database using ASP.NET and C#.
How to display data using the .NET GridView Control C#
This tutorial will show you how to display data using the .NET GridView Control, stored procedures, ASP.NET 2.0 and C#.NET
How to display data using the .NET GridView Control VB
This tutorial will show you how to display data using the .NET GridView Control, stored procedures, ASP.NET 2.0 and VB.NET
411asp.net123aspxDotNetFreaksServer Intellect