Latest article tagged on "ADO.Net"

Connection Pooling in ADO.Net

Creating a database connection is somewhat time-consuming because it involves the overhead of network-level handshaking and security credentialing for each new connection request.

By mohan kumar posted   5 years ago

DataPager Control in ASP.Net

DataPager control can be associated with the data-bound control by using the PagedControlID property.

ListView Control in ASP.Net

The ASP.NET ListView control enables you to bind to data items that are returned from a data source and display them. You can display data in pages. You can display items individually, or you can group them.

SiteMapDataSource Control in ASP.Net

The SiteMapDataSource control enables you to declaratively data bind to site navigation data in your pages. The SiteMapDataSource control is used as a data source to place a site map to the website. A site map is a way to present all folders and pages of the website. The site map information can appear in many forms. SiteMapDataSource control is used generally as a data source for asp: SiteMapPath control.

XmlDataSource Control in ASP.Net

XmlDataSource is usually used to display read only XML data.

ObjectDataSource in ASP.Net

ObjectDataSource belongs to the family of data source controls in ASP.NET, which enables a declarative databinding model against a variety of underlying data stores, such as SQL databases or XML. The ObjectDataSource control allows developers to structure their applications using this traditional three-tiered architecture and still take advantage of the ease-of-use benefits of the declarative databinding model in ASP.NET.

SqlDataSource in ASP.Net

SqlDataSource is intended to replace the ADO.NET code you would normally write in a page to create a connection and command to query a database. Because the data queries are specified directly as properties of the data source control, this is sometimes called a two-tier model, because the data queries are still maintained in page code.

Repeater Control in ASP.Net

The Repeater control is used to display a repeated list of items that are bound to the control.

FormView Control in ASP.Net

The FormView control is used to display a single record from a data source. It is similar to the DetailsView control, except it displays user-defined templates instead of row fields. Creating your own templates gives you greater flexibility in controlling how the data is displayed.

DetailsView Control in ASP.Net

The DetailsView control displays a single record from a data source, where each data row represents a field in the record.

DataList Control in ASP.Net

The DataList control is used to display a repeated list of items that are bound to the control. However, the DataList control adds a table around the data items by default.

GridView Control in ASP.Net

The GridView control enables you to connect to a data source and display data in tabular format.

GridView Control: A brief Concept

The GridView control is used to display the values of a data source in a table.

By Amit Singh posted   7 years ago


In this Application we have to show how data is populating from the database in Datagridview on the click of a button .

By Alex R posted   7 years ago


In this project we have to Access data from SQL in datagridview control and populating data in another form by selecting fields in the datagridview as well as updating records.

By Amit Singh posted   7 years ago


In this application we have to access data from the SQL database in the form of Gridview, and update Records while selecting Records from the gridview in another Form with update Button.

By Amit Singh posted   7 years ago


First Step is to open a new project in Microsoft visual studio, then open a Design view in the form and place a various label as well as text field .

By Alex R posted   7 years ago


We can use DataReader in ADO.Net to retrieve a read-only, forward only stream of data from the database

By Amit Singh posted   7 years ago

Connection String

Connection string is one of the important part in database connectivity because without database connectivity we cannot connect the database with our project.

By Amit Singh posted   7 years ago


DataTable is used to store data in memory in SQL database. DataTable contains a collection of constraints .in data base datatable is a collection of rows and columns. Datatable is ideal for this purpose, as you can take objects from memory and display the results in controls such as DataGridView in Windows Forms. Here are the simply c sharp example which shows DataTable

By Amit Singh posted   7 years ago


DataSet has been designed for an offline container that means it always works on disconnected dataset contains data tables collections and their relationships it represent a complete set of data including tables that contain tables rows and constraints. Build and fill each data table in a dataset with data from a data source using data adapter.

By Amit Singh posted   7 years ago


Assembly is a collection of dll, exe, html, the assembly manifest which is a collection of metadata i.e. data about data that describes name of the assembly, culture setting, versioning, security and other resources.

By Alex R posted   7 years ago


Data Adapter serves a bridge between dataset and data source for retrieving and saving data from the database. The data Adapter provides this bridge by mapping fill which changes the data in dataset to make the data in data source.

By Amit Singh posted   7 years ago

String Builder in C sharp .NET

StringBuilder is a dynamic string array, in which we can append any number of strings.

By Alex R posted   7 years ago


A SqlDataReader is good for reading data in the most efficient manner. We can not use it for writing data. We can read from SqlDataReader objects in a forward-only sequential manner. Once we have read some data, we must save it because we will not be able to go back and read it again.

By Alex R posted   7 years ago

Don't want to miss updates? Please click the below button!

Follow MindStick