|
|
|
|
Articles
(445)
|
|
|
Tutorials
(3)
|
|
|
Resources
(18)
|
|
|
Downloads
(2)
|
|
|
|
|
|
Home
»
ADO.NET & Database
|
|
|
|
|
|
Welcome to ADO.NET & Database programming section of C# Corner. In this section, you will find various Database Programming related source code samples, articles, tutorials, and tips.
|
|
|
|
|
|
|
|
|
|
|
Add, Update, Delete using ADO.NET Entity Framework
by
Mahesh Chand
on
Jan 29, 2010
In my previous video, I demonstrated how to create a data model using ADO.NET Entity Framework. This video is next part that demonstrates how to add, update, and delete data using ADO.NET Entity Framework and Visual Studio 2010 in a Windows application.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Configuring an ODBC Connection String
by
Mukesh Kumar
On
Jun 29, 2011
Open Database Connectivity (ODBC) is one of the older technologies the .NET Framework supports, primarily because you still need the .NET Framework to connect to older database products that have ODBC drivers.
|
|
Comments:
0
|
|
|
|
|
ADO.NET Data Providers
by
Mukesh Kumar
On
Jun 29, 2011
The classes responsible for the movement of data between the disconnected data classes in the client application and the data store are referred to as connected classes or provider classes.
|
|
Comments:
0
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Chapter 8: Data Storage Design and SQL Server
by
Apress
on
Dec 16, 2008
This chapter will explore the most common storage technologies available to you. It will also present some benefits and concerns about different storage designs so that you can more easily choose what suits your solution. We will finish the chapter with a presentation of SQL Server-examining its architecture and how it fits into your storage policy.
|
|
|
|
|
ADO.NET: Retrieve Data using OLE DB
by
Mahesh Chand
on
Feb 08, 2007
This sample illustrates how to read data from an OLE DB provider using the OleDbDataReader class. This class provides a way of reading a forward-only stream of data records from a data source.
|
ADO.NET: Generate XML with data from SQL Server
by
Mahesh Chand
on
Feb 08, 2007
This sample illustrates how to produce XML from SQL Server using two different techniques. The first uses the ExecuteXmlReader method of SqlCommand to get an XmlTextReader, which is then populated into a DataSet using the ReadXml method of the DataSet class.
|
ADO.NET: Connection Pooling
by
Mahesh Chand
on
Feb 08, 2007
This sample illustrates how to construct a pool of connections to a datasource. You will want to do this to deploy high-performance applications. In this example the pool is established in the connection string and managed automatically by the SqlConnection.
|
ADO.NET: Filter Data
by
Mahesh Chand
on
Feb 08, 2007
There are many ways to filter data. One way is to filter data at the database command level, using a where clause on your query. A second way is to filter the data after it is in the DataSet. This topic covers filtering in the DataSet.
|
ADO.NET: Work with Typed Data
by
Mahesh Chand
on
Feb 08, 2007
ADO classic code provides late-bound access to values within its recordset through weakly typed variables. ADO.NET code enables you to access the data held in the DataSet through a "strongly typed" metaphor.
|
ADO.NET: Work with Relational Data
by
Mahesh Chand
on
Feb 08, 2007
A DataSet can contain either unrelated tables or related tables. You can think of a DataSet as a document of data. In fact, an XML data document is like this, except it is based on a hierarchical paradigm.
|
ADO.NET: Handle Errors
by
Mahesh Chand
on
Feb 08, 2007
In addition to Try/Catch and exceptions, the new ADO.NET data architecture allows you to add error messages to each row of Data in a DataSet. SqlDataAdapters attach error messages to Rows if updates or other actions fail.
|
ADO.NET: Use Database Transactions
by
Mahesh Chand
on
Feb 08, 2007
Database transactions are used to control data commitment to databases. For example, in standard account procedures, it is necessary to debit one account and credit another at the same time.
|
ADO.NET: Read and Write XML
by
Mahesh Chand
on
Feb 04, 2007
Schemas, or the tables, columns, constraints and so forth, of a DataSet can be defined in several ways. One method is to create them using properties and methods (Tables.Add, Columns.Add, and so on).
|
ADO.NET: Populate a DataSet from a Database
by
Mahesh Chand
on
Feb 04, 2007
Getting data from a database is easy, and working with data is easier than before. If you want the results from a database as a forward only, read-only stream of data, you can execute a command and retrieve the results using the DataReader.
|
ADO.NET: Get Out Parameters from a Stored Procedure
by
Mahesh Chand
on
Feb 04, 2007
Some stored procedures return values through parameters. When a parameter in a SQL statement or stored procedure is declared as "out", the value of the parameter is returned back to the caller; the value is stored in a parameter in the Parameters collection on the OleDbCommand or SqlCommand objects.
|
ADO.NET: Execute a Command
by
Mahesh Chand
on
Feb 04, 2007
To issue a command against a database, the Command object must have two basic things: a Connection and CommandText, both of which can be set in the constructor.
|
ADO.NET Overview
by
Mahesh Chand
on
Jan 29, 2007
ADO.NET is an evolution of the ADO data access model that directly addresses user requirements for developing scalable applications. It was designed specifically for the web with scalability, statelessness, and XML in mind.
|
New DataSet Features in ADO.NET 2.0
by
Mahesh Chand
on
Dec 22, 2005
Learn about the new ADO.NET 2.0 features in the DataSet .NET Framework class and the classes that are closely related to it. These changes include both functional and performance enhancements to the DataSet, DataTable, and DataView classes.
|
New DataSet Features in Visual Studio 2005
by
Mahesh Chand
on
Dec 22, 2005
Learn about the new features in the typed DataSet class and the new TableAdapter class that are generated by Visual Studio 2005, as well as the tools for designing these classes. Also learn about the new BindingSource and BindingNavigator components, and see how to use them to rapidly build flexible, data-bound WinForms applications.
|
|
|
|
|
|
|
|
|
|