Accessing MySQL Database with ASP.NET
This step-by-step tutorial makes use of over 20 images to describe every step in detail from obtaining, installing, configuring and running MySQL on Windows to insalling/uninstalling MySQL as a Windows service, creating a new table, populating it with some records and displaying those records in an ASP.NET page. Also explains the advantages of using MySQL on Windows with ASP.NET. All the code is available for download.
Adding Items to a DataView and DataTable
In this article we'll be demonstrating how to add a new row to both a DataTable and a DataView. In the first part of this article we will briefly discuss the differences between a DataView and DataTable, then we'll give a code example and analysis of how to add a new item to each. The code will demonstrate how effecting one, has a direct effect on the other.
ADO and ADO.NET - Part I
In this article, we're going to take a look at some of the fundamental differences that exist between ADO and ADO.NET in a practical sense. We will be using ASP, ASP.NET and C# to both instantiate ADO and ADO.NET classes, seeing how the calling ...
ADO and ADO.NET - Part II
In this second part, you will learn about Rowsets, Calling stored procedures and Retrieving records as XML in ASP .NET using C#
ASP.NET DATASET vs. ASP recordset spped tests: where's the fire?
Well, it's paying off. After a disappointing hibernation, Robbe has cracked the pen and produced an excellent and well researched article about ADO .NET performance for our site. He even found time to throw in a couple of classic ASP (ADO) comparison tests. The results are interesting!
Connecting to a SQL database from ASP .NET
I This is part I of the tutorial that teaches you how to
connect to a SQL database from ASP .NET using SQL
Authentication. This part shows you how to set up MSDE for
Mixed Mode and how to use Web Data Administrator to create
databases and users.
Connecting to a SQL database from ASP .NET I
This is part I of the tutorial that teaches you how to connect to a SQL database from ASP .NET using SQL Authentication. This part shows you how to set up MSDE for Mixed Mode and how to use Web Data Administrator to create databases and users.
Creating a Master-detail page
In this article I'll show you have you can quite easily make a master-detail page by nesting repeater controls. The data will be taken from the Northwind database, and the two tables we are going to use are 'Categories' and 'Products'.
Data Access with ADO.NET
This article describes the (data access layer) DAL class used
by ASPAlliance.com, including a handy function that can cut the
number of lines of code required for DAL methods by half or
more, by cutting down the number of lines required for each
stored procedure parameter.
Data Access with ADO.NET - Part 1
This series of articles will first be a simple overview of what ADO.NET is, and second, will be a look at the specific objects and functionality that make up ADO.NET as a whole.
Data Access with ADO.NET - Part 2
This week, continuing his series on data access under ADO.NET, this article presents a simple ASP.NET sample script which illustrates querying the 'pubs' database. He then explains and walks you through how it works.
DB Admin Tool in 20 Lines
Create a 1 page tool with only 20 lines of code that provides access to your tables with SELECT, INSERT, UPDATE and DELETE statements.
Display SQL Server table data in a browser
Just supply your database connection string and this code will give you a radio button list of all your SQL Server tables and will show their fields.
Displaying Images in DataGrid
In this Article we will discuss about retrieving images from a sql server database in ASP .NET and how to display them in a datagrid. This article has downloadable examples and you can test the output online. When ever you want to deal with images .....
Editing and Deleting Items in the DataTable and DataView
In last weeks article I explained how to add a new item to a DataTable and a DataView. In this weeks article we'll discuss editing and deleting items in both the DataView and DataTable objects. We saw in last weeks article that adding a new row in one DataTable or DataView object has a direct effect on another that is derived from the same DataTable, well editing rows is no different! In both the DataView and DataTable you edit items by using their rowscollection, the DataView has a DataRowView and the DataTable has the DataRow. You edit in nearly the exact same manner in both as you'll see in Code Listing 1.1 where we go through editing a single row in each.
Encapsulating ODBC in ASP .NET
HotQuant, LLC, builds on their previous ODBC article by demonstrating how to use encapsulation to isolate an application's data access layer and significantly streamline the code.
File Uploading to Access Database using ASP.NET
A comprehensive tutorial on uploading files to Microsoft Access database using built-in ASP.NET server controls. Describes how to upload one or more file to Access database? how to insert and retrieve binary data from an Access database? how to view and delete files uploaded on the Access database?
Hierarchical data with ADO.NET
ADO.NET implements a completely new model for accessing data and storing data in the memory. With this in mind, the way to work with hierarchical data is also changed. This article will try to cast some light on the changes and the new way of thinking.
In Depth ASP.NET using ADO.NET
In this article we will discuss a number of ways to retrieve, show, and update data with ASP.NET forms using ADO.NET. Also, we will have a clear idea about the most common server controls in ASP.NET. In particular, with this article we will cover ASP.NET server controls, ADO.NET DataSource, and creating Templated DataBound Controls, ASP.NET forms, using data with controls.
Inserting Images to SqlServer
Read this article to know about, how to insert an image into a SqlServer database. You will also learn about the prerequistes for inserting an image into SqlServer. All aspects that need to take care in ASPX page and in database are discussed...........
Integrating Flash with an Access Database
This article describes how to connect a Macromedia Flash movie to an Access database using an ASP page as the data-transfer mechanism.
Listing and Viewing SQL Objects
List names and details of SQL objects like tables and stored procedures using the sample code and utility described in this article.
Presenting Hierarchical Data in ASP.NET
ASP.NET comes with very powerful template based, iterative web server controls. Web pages that display data in tabular format can use DataGrid, DataList or Repeater ASP.NET controls. There are cases where data need to be presented in more complex/hierarchical format than simple tabular format. This article focuses on simple techniques/tricks to present the data in the hierarchical format, using existing ASP.NET controls.
Sorting in DataList
We all know that, the DataList web server control does not support in-built sort option. Still we can provide users with the sort option for all columns in a DataList. The logic is very simple. The DataView object has a property called Sort. We are going to make use of this property to sort the rows in a DataList. For our example, we will consider the table, stores from the database (SQL Server 2000), pubs.
Sorting in DataList
We do not have inbuilt mechanism for sort with the DataList. But there may me many occassions in which we may want allow user to do sorting on a Datalist. Read this article to know more about this. Demo and source code are available for FREE!
SqlWhereBuilder ASP.NET Server Control
SqlWhereBuilder is a web control which provides a user interface for generating custom SQL WHERE clauses. Designed to support ad hoc reporting needs, users add conditions through the interface, and developers use either the GetWhereClause() or GetWhereClauseWithParameters() method upon postback to compile the chosen conditions into a string of text suitable for inclusion in a SQL WHERE clause.
Taking Full Control: Build Your Own Reusable Datalist with VS.NET
In this article, I will show you how to build a custom control based on the .NET datalist control. This custom control will implement a lot of the functionality discussed in the datagrid story. As an introduction to creating custom controls, I will start with creating a simple one. It is a delete LinkButton, which implements the user confirmation I discussed in the last article. A demo WebForm will use both custom controls to demonstrate their usage.
Using Database Schema Information with ASP.NET
The database schema, sometimes called metadata, is how the database defines itself. To oversimplify things, when an action is taken against the database such as an update, the database checks the command against the schema information and makes sure there are no conflicts. You have probably received an error when you tried to pass a string to the database when it was expecting an integer. The database schema is responsible for this.
Using Parameterized Query in ASP.NET
This article examines what, exactly, parameterized queries are, their advantages, and how to use them in ADO.NET through an ASP.NET Web page!
Computer Professionals: Are you owed Overtime? Federal and State Laws may allow computer professionals to collect overtime. Our law firm is experienced, and has initiated class action lawsuits against some of the largest computer companies to collect back pay and overtime. Strictly Confidential.
Articles
