Classes
for holding data
The
following are the main classes used to hold data in Ado.NET:
DataSet
DataTable
DataRow
A
DataSet is an in-memory representation of the database.
DataSet
contains DataTables (and more...)
DataTable
represents a database table
DataTable
contains DataRows (and more...)
A
DataRow represents a record in a database table.
DataRow
is a collection of all fields in a record.
We
can use the DataAdapter or DataReader to populate data in DataSet.
Once...
Friday, 1 April 2016
ADO.NET :: Classes for communicating with database
Classes
for communicating with database
The
Connection,
Command,
DataReader,
and DataAdapter
objects
are the core elements of the ADO.NET provider model.
Object
Description
SqlClient
Objects
OleDb
Objects
Connection
Establishes
a connection to a specific data source.
SqlConnection
OleDbConnection
Command
Executes
a command against a data source.
SqlCommand
...
ADO.NET :: ADO.NET and DataAccess Providers in .NET
ADO.NET
ADO.NET is the data access model that comes with the .NET Framework. ADO.NET provides the classes required to communicate with any database source (including Oracle, Sybase, Microsoft Access, Xml, and even text files).
DataAccess Providers in .NET
ADO.NET comes with few providers, including:
OleDb
SqlClient
There are other providers available, but we are not including them here as this tutorial is meant for beginners! When you want them, search for ADO.NET...
ADO.NET :: Database Concepts
Database Concepts
Database is the media to store data. If you have an application that has to store and retrieve data, your application must be using a database.
A File is the simplest form of saving the data in the disk, but is not the most efficient way of managing application data. A database is basically a collection of one or more files, but in a custom format, and data is organized in a specific format such a way that it can be retrieved and stored very efficiently.
Some...
ADO.NET for Beginners
ADO.NET for Beginners
Accessing Database
Accessing database using ADO.NET in C# or VB.NET This tutorial will teach you Database concepts and ADO.NET in a very simple and easy-to-understand manner with many code snippets and samples. This is primarily meant for beginners and if you are looking for any advanced ADO.NET topics, this may not be the right page for you.
Topic Covered...
Thursday, 31 March 2016
How to Get File Name without Extension?
Here we discuss about how to get current page title name?
When we use below code:
protected void Page_Load(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(Page.Title))
{
string path = Path.GetFileName(Request.Path);
}
}
Example:
...
Wednesday, 30 March 2016
How to add a favicon images to your asp.net page?
How to add a favicon images to your asp.net page?
How can you add images to your asp.net title page?
Step 1: Firstly convert your logo or image to favicon.ico.
This can be done as follows:
Go to the link given below,
http://favicon-generator.org/
Choose your image, convert it to .ico.
Download your favicon.ico to your application directory.
Step 2: Copy and paste this favicon.ico to image folder of project.
Step 3: Open Master page(SiteMaster).
Step...
Wednesday, 3 February 2016
Object Oriented Paradigm
1.4 Object Oriented Paradigm
The major motivating factor in the invention of object-oriented approach is to remove some of the flaws encountered in the procedural approach. OOP treats data as a critical element in the program development and does not allow it to flow freely around the system. It ties data more closely to the function that operate on it, and protects it from accidental modification...
Procedure-Oriented Programming
1.3 Procedure-Oriented Programming
In this approach, the problem is viewed as the sequence of things to be done such as reading, calculating and printing such as cobol, fortran and c. The primary focus is on functions. A typical structure for procedural programming is shown in fig.1.2. The technique of hierarchical decomposition has been used to specify the tasks to be completed for solving...
Thursday, 28 January 2016
Procedure-Oriented Programming
1.3 Procedure-Oriented Programming
In the procedure oriented approach, the problem is viewed as the sequence of things to be done such as reading, calculating and printing such as cobol, fortran and c. The primary focus is on functions. A typical structure for procedural programming is shown in fig.1.2. The technique of hierarchical decomposition has been used to specify the tasks to be completed...
Subscribe to:
Posts (Atom)