ASP.NET GridView Tutorial - Object datasource in asp net Part 3
Database, Information Technology
ASP.NET GridView Tutorial
301 Lessons
- Datagrid in asp net Part 1
- Data source controls in asp net Part 2
- Object datasource in asp net Part 3
- Data source controls in asp net Part 2
- Data source controls in asp net Part 2
- Data source controls in asp net Part 2
- Data source controls in asp net Part 2
- XMLDataSource in asp net Part 4
- Object datasource in asp net Part 3
- Object datasource in asp net Part 3
- Object datasource in asp net Part 3
- Object datasource in asp net Part 3
- Using XSLT transform with XMLDataSourceControl Part 5
- XMLDataSource in asp net Part 4
- XMLDataSource in asp net Part 4
- XMLDataSource in asp net Part 4
- XMLDataSource in asp net Part 4
- AccessDataSource in asp net Part 6
- Using XSLT transform with XMLDataSourceControl Part 5
- Using XSLT transform with XMLDataSourceControl Part 5
- Using XSLT transform with XMLDataSourceControl Part 5
- Using XSLT transform with XMLDataSourceControl Part 5
- Formatting asp net gridview control Part 7
- AccessDataSource in asp net Part 6
- AccessDataSource in asp net Part 6
- AccessDataSource in asp net Part 6
- AccessDataSource in asp net Part 6
- Formatting gridview using rowdatabound event Part 8
- Formatting asp net gridview control Part 7
- Formatting asp net gridview control Part 7
- Formatting asp net gridview control Part 7
- Formatting asp net gridview control Part 7
- Formatting gridview based on row data Part 9
- Formatting gridview using rowdatabound event Part 8
- Formatting gridview using rowdatabound event Part 8
- Formatting gridview using rowdatabound event Part 8
- Formatting gridview using rowdatabound event Part 8
- Design time and runtime formatting of gridview Part 10
- Formatting gridview based on row data Part 9
- Formatting gridview based on row data Part 9
- Formatting gridview based on row data Part 9
- Formatting gridview based on row data Part 9
- Using stored procedures with sqldatasource control Part 11
- Design time and runtime formatting of gridview Part 10
- Design time and runtime formatting of gridview Part 10
- Design time and runtime formatting of gridview Part 10
- Design time and runtime formatting of gridview Part 10
- Using stored procedures with objectdatasource control – Part 12
- Using stored procedures with sqldatasource control Part 11
- Using stored procedures with sqldatasource control Part 11
- Using stored procedures with sqldatasource control Part 11
- Using stored procedures with sqldatasource control Part 11
- Deleting data from gridview using sqldatasource control
- Using stored procedures with objectdatasource control – Part 12
- Using stored procedures with objectdatasource control – Part 12
- Using stored procedures with objectdatasource control – Part 12
- Using stored procedures with objectdatasource control – Part 12
- ConflictDetection property of SqlDataSource control – Part 14
- Deleting data from gridview using sqldatasource control
- Deleting data from gridview using sqldatasource control
- Deleting data from gridview using sqldatasource control
- Deleting data from gridview using sqldatasource control
- Deleting data from gridview using objectdatasource control – Part 15
- ConflictDetection property of SqlDataSource control – Part 14
- ConflictDetection property of SqlDataSource control – Part 14
- ConflictDetection property of SqlDataSource control – Part 14
- ConflictDetection property of SqlDataSource control – Part 14
- ConflictDetection property of objectdatasource control – Part 16
- Deleting data from gridview using objectdatasource control – Part 15
- Deleting data from gridview using objectdatasource control – Part 15
- Deleting data from gridview using objectdatasource control – Part 15
- Deleting data from gridview using objectdatasource control – Part 15
- Editing and updating data in gridview using sqldatasource control – Part 17
- ConflictDetection property of objectdatasource control – Part 16
- ConflictDetection property of objectdatasource control – Part 16
- ConflictDetection property of objectdatasource control – Part 16
- ConflictDetection property of objectdatasource control – Part 16
- Editing and updating data in gridview using objectdatasource control – Part 18
- Editing and updating data in gridview using sqldatasource control – Part 17
- Editing and updating data in gridview using sqldatasource control – Part 17
- Editing and updating data in gridview using sqldatasource control – Part 17
- Editing and updating data in gridview using sqldatasource control – Part 17
- Using optimistic concurrency when editing data in gridview – Part 19
- Editing and updating data in gridview using objectdatasource control – Part 18
- Editing and updating data in gridview using objectdatasource control – Part 18
- Editing and updating data in gridview using objectdatasource control – Part 18
- Editing and updating data in gridview using objectdatasource control – Part 18
- Keep gridview in edit mode when update fails due to data conflict – Part 20
- Using optimistic concurrency when editing data in gridview – Part 19
- Using optimistic concurrency when editing data in gridview – Part 19
- Using optimistic concurrency when editing data in gridview – Part 19
- Using optimistic concurrency when editing data in gridview – Part 19
- GridView TemplateField in asp.net – Part 21
- Keep gridview in edit mode when update fails due to data conflict – Part 20
- Keep gridview in edit mode when update fails due to data conflict – Part 20
- Keep gridview in edit mode when update fails due to data conflict – Part 20
- Keep gridview in edit mode when update fails due to data conflict – Part 20
- Using validation controls with asp.net gridview when editing data – Part 22
- GridView TemplateField in asp.net – Part 21
- GridView TemplateField in asp.net – Part 21
- GridView TemplateField in asp.net – Part 21
- GridView TemplateField in asp.net – Part 21
- GridView insert update delete in asp.net – Part 23
- Using validation controls with asp.net gridview when editing data – Part 22
- Using validation controls with asp.net gridview when editing data – Part 22
- Using validation controls with asp.net gridview when editing data – Part 22
- Using validation controls with asp.net gridview when editing data – Part 22
- GridView insert update delete in asp.net using objectdatasource – Part 24
- GridView insert update delete in asp.net – Part 23
- GridView insert update delete in asp.net – Part 23
- GridView insert update delete in asp.net – Part 23
- GridView insert update delete in asp.net – Part 23
- GridView insert update delete without using datasource controls – Part 25
- GridView insert update delete in asp.net using objectdatasource – Part 24
- GridView insert update delete in asp.net using objectdatasource – Part 24
- GridView insert update delete in asp.net using objectdatasource – Part 24
- GridView insert update delete in asp.net using objectdatasource – Part 24
- Displaying summary data in asp.net gridview footer – Part 26
- GridView insert update delete without using datasource controls – Part 25
- GridView insert update delete without using datasource controls – Part 25
- GridView insert update delete without using datasource controls – Part 25
- GridView insert update delete without using datasource controls – Part 25
- EmptyDataText and EmptyDataTemplate properties of asp.net gridview control – Part 27
- Displaying summary data in asp.net gridview footer – Part 26
- Displaying summary data in asp.net gridview footer – Part 26
- Displaying summary data in asp.net gridview footer – Part 26
- Displaying summary data in asp.net gridview footer – Part 26
- Delete multiple rows from asp.net gridview – Part 28
- EmptyDataText and EmptyDataTemplate properties of asp.net gridview control – Part 27
- EmptyDataText and EmptyDataTemplate properties of asp.net gridview control – Part 27
- EmptyDataText and EmptyDataTemplate properties of asp.net gridview control – Part 27
- EmptyDataText and EmptyDataTemplate properties of asp.net gridview control – Part 27
- Enhancing gridview using jquery when deleting mulitple rows – Part 29
- Delete multiple rows from asp.net gridview – Part 28
- Delete multiple rows from asp.net gridview – Part 28
- Delete multiple rows from asp.net gridview – Part 28
- Delete multiple rows from asp.net gridview – Part 28
- Displaying images in asp.net gridview using templatefield – Part 30
- Enhancing gridview using jquery when deleting mulitple rows – Part 29
- Enhancing gridview using jquery when deleting mulitple rows – Part 29
- Enhancing gridview using jquery when deleting mulitple rows – Part 29
- Enhancing gridview using jquery when deleting mulitple rows – Part 29
- Displaying images in asp.net gridview using imagefield – Part 31
- Displaying images in asp.net gridview using templatefield – Part 30
- Displaying images in asp.net gridview using templatefield – Part 30
- Displaying images in asp.net gridview using templatefield – Part 30
- Displaying images in asp.net gridview using templatefield – Part 30
- Displaying GridView in a GridView – Part 32
- Displaying images in asp.net gridview using imagefield – Part 31
- Displaying images in asp.net gridview using imagefield – Part 31
- Displaying images in asp.net gridview using imagefield – Part 31
- Displaying images in asp.net gridview using imagefield – Part 31
- Merging cells in gridview footer row – Part 33
- Displaying GridView in a GridView – Part 32
- Displaying GridView in a GridView – Part 32
- Displaying GridView in a GridView – Part 32
- Displaying GridView in a GridView – Part 32
- Drilldown and display hierarchical data in an asp.net gridview using sqldatasource control – Part 34
- Merging cells in gridview footer row – Part 33
- Merging cells in gridview footer row – Part 33
- Merging cells in gridview footer row – Part 33
- Merging cells in gridview footer row – Part 33
- Drilldown and display hierarchical data in gridview using objectdatasource control – Part 35
- Drilldown and display hierarchical data in an asp.net gridview using sqldatasource control – Part 34
- Drilldown and display hierarchical data in an asp.net gridview using sqldatasource control – Part 34
- Drilldown and display hierarchical data in an asp.net gridview using sqldatasource control – Part 34
- Drilldown and display hierarchical data in an asp.net gridview using sqldatasource control – Part 34
- Drilldown and display hierarchical data in gridview without using datasource controls – Part 36
- Drilldown and display hierarchical data in gridview using objectdatasource control – Part 35
- Drilldown and display hierarchical data in gridview using objectdatasource control – Part 35
- Drilldown and display hierarchical data in gridview using objectdatasource control – Part 35
- Drilldown and display hierarchical data in gridview using objectdatasource control – Part 35
- Detailsview in asp.net – Part 37
- Drilldown and display hierarchical data in gridview without using datasource controls – Part 36
- Drilldown and display hierarchical data in gridview without using datasource controls – Part 36
- Drilldown and display hierarchical data in gridview without using datasource controls – Part 36
- Drilldown and display hierarchical data in gridview without using datasource controls – Part 36
- Using objectdatasource control with detailsview – Part 38
- Detailsview in asp.net – Part 37
- Detailsview in asp.net – Part 37
- Detailsview in asp.net – Part 37
- Detailsview in asp.net – Part 37
- Working with detailsview without using datasource controls – Part 39
- Using objectdatasource control with detailsview – Part 38
- Using objectdatasource control with detailsview – Part 38
- Using objectdatasource control with detailsview – Part 38
- Using objectdatasource control with detailsview – Part 38
- asp.net detailsview insert update delete using sqldatasource control – Part 40
- Working with detailsview without using datasource controls – Part 39
- Working with detailsview without using datasource controls – Part 39
- Working with detailsview without using datasource controls – Part 39
- Working with detailsview without using datasource controls – Part 39
- asp.net detailsview insert update delete using objectdatasource control – Part 41
- asp.net detailsview insert update delete using sqldatasource control – Part 40
- asp.net detailsview insert update delete using sqldatasource control – Part 40
- asp.net detailsview insert update delete using sqldatasource control – Part 40
- asp.net detailsview insert update delete using sqldatasource control – Part 40
- asp.net detailsview insert update delete without using data source controls – Part 42
- asp.net detailsview insert update delete using objectdatasource control – Part 41
- asp.net detailsview insert update delete using objectdatasource control – Part 41
- asp.net detailsview insert update delete using objectdatasource control – Part 41
- asp.net detailsview insert update delete using objectdatasource control – Part 41
- Nested gridview in asp.net – Part 43
- asp.net detailsview insert update delete without using data source controls – Part 42
- asp.net detailsview insert update delete without using data source controls – Part 42
- asp.net detailsview insert update delete without using data source controls – Part 42
- asp.net detailsview insert update delete without using data source controls – Part 42
- Sorting a gridview that uses sqldatasource control – Part 44
- Nested gridview in asp.net – Part 43
- Nested gridview in asp.net – Part 43
- Nested gridview in asp.net – Part 43
- Nested gridview in asp.net – Part 43
- Sorting a gridview that uses objectdatasource control and a dataset – Part 45
- Sorting a gridview that uses sqldatasource control – Part 44
- Sorting a gridview that uses sqldatasource control – Part 44
- Sorting a gridview that uses sqldatasource control – Part 44
- Sorting a gridview that uses sqldatasource control – Part 44
- Sorting a gridview that uses objectdatasource control and business objects – Part 46
- Sorting a gridview that uses objectdatasource control and a dataset – Part 45
- Sorting a gridview that uses objectdatasource control and a dataset – Part 45
- Sorting a gridview that uses objectdatasource control and a dataset – Part 45
- Sorting a gridview that uses objectdatasource control and a dataset – Part 45
- Sorting a gridview that does not use any datasource control – Part 47
- Sorting a gridview that uses objectdatasource control and business objects – Part 46
- Sorting a gridview that uses objectdatasource control and business objects – Part 46
- Sorting a gridview that uses objectdatasource control and business objects – Part 46
- Sorting a gridview that uses objectdatasource control and business objects – Part 46
- Sorting an asp.net gridview in ascending and descending order – Part 48
- Sorting a gridview that does not use any datasource control – Part 47
- Sorting a gridview that does not use any datasource control – Part 47
- Sorting a gridview that does not use any datasource control – Part 47
- Sorting a gridview that does not use any datasource control – Part 47
- How to include sort arrows when sorting an asp.net gridview control – Part 49
- Sorting an asp.net gridview in ascending and descending order – Part 48
- Sorting an asp.net gridview in ascending and descending order – Part 48
- Sorting an asp.net gridview in ascending and descending order – Part 48
- Sorting an asp.net gridview in ascending and descending order – Part 48
- Implement paging in an asp.net gridview that uses sqldatasource – Part 50
- How to include sort arrows when sorting an asp.net gridview control – Part 49
- How to include sort arrows when sorting an asp.net gridview control – Part 49
- How to include sort arrows when sorting an asp.net gridview control – Part 49
- How to include sort arrows when sorting an asp.net gridview control – Part 49
- Implement default paging in an asp.net gridview that uses objectdatasource – Part 51
- Implement paging in an asp.net gridview that uses sqldatasource – Part 50
- Implement paging in an asp.net gridview that uses sqldatasource – Part 50
- Implement paging in an asp.net gridview that uses sqldatasource – Part 50
- Implement paging in an asp.net gridview that uses sqldatasource – Part 50
- Implement custom paging in an asp.net gridview that uses objectdatasource – Part 52
- Implement default paging in an asp.net gridview that uses objectdatasource – Part 51
- Implement default paging in an asp.net gridview that uses objectdatasource – Part 51
- Implement default paging in an asp.net gridview that uses objectdatasource – Part 51
- Implement default paging in an asp.net gridview that uses objectdatasource – Part 51
- Implement default paging in an asp.net gridview without using datasource controls – Part 53
- Implement custom paging in an asp.net gridview that uses objectdatasource – Part 52
- Implement custom paging in an asp.net gridview that uses objectdatasource – Part 52
- Implement custom paging in an asp.net gridview that uses objectdatasource – Part 52
- Implement custom paging in an asp.net gridview that uses objectdatasource – Part 52
- Implement custom paging in an asp.net gridview without using datasource controls – Part 54
- Implement default paging in an asp.net gridview without using datasource controls – Part 53
- Implement default paging in an asp.net gridview without using datasource controls – Part 53
- Implement default paging in an asp.net gridview without using datasource controls – Part 53
- Implement default paging in an asp.net gridview without using datasource controls – Part 53
- Custom paging and sorting in gridview – Part 55
- Implement custom paging in an asp.net gridview without using datasource controls – Part 54
- Implement custom paging in an asp.net gridview without using datasource controls – Part 54
- Implement custom paging in an asp.net gridview without using datasource controls – Part 54
- Implement custom paging in an asp.net gridview without using datasource controls – Part 54
- asp.net gridview paging using a dropdownlist – Part 56
- Custom paging and sorting in gridview – Part 55
- Custom paging and sorting in gridview – Part 55
- Custom paging and sorting in gridview – Part 55
- Custom paging and sorting in gridview – Part 55
- Export gridview to excel in asp.net – Part 57
- asp.net gridview paging using a dropdownlist – Part 56
- asp.net gridview paging using a dropdownlist – Part 56
- asp.net gridview paging using a dropdownlist – Part 56
- asp.net gridview paging using a dropdownlist – Part 56
- Export gridview to pdf in asp.net – Part 58
- Export gridview to excel in asp.net – Part 57
- Export gridview to excel in asp.net – Part 57
- Export gridview to excel in asp.net – Part 57
- Export gridview to excel in asp.net – Part 57
- Generate pdf document from gridview data and store on web server – Part 59
- Export gridview to pdf in asp.net – Part 58
- Export gridview to pdf in asp.net – Part 58
- Export gridview to pdf in asp.net – Part 58
- Export gridview to pdf in asp.net – Part 58
- Repeater control in asp.net – Part 60
- Generate pdf document from gridview data and store on web server – Part 59
- Generate pdf document from gridview data and store on web server – Part 59
- Generate pdf document from gridview data and store on web server – Part 59
- Generate pdf document from gridview data and store on web server – Part 59
- Part 61 How to get value from a gridview templatefield
- Repeater control in asp.net – Part 60
- Repeater control in asp.net – Part 60
- Repeater control in asp.net – Part 60
- Repeater control in asp.net – Part 60
- Part 61 How to get value from a gridview templatefield
- Part 61 How to get value from a gridview templatefield
- Part 61 How to get value from a gridview templatefield
- Part 61 How to get value from a gridview templatefield
Object datasource in asp net Part 3
Text version of the video
http://csharp-video-tutorials.blogspot.com/2013/02/object-datasource-in-aspnet-part-3.html
Slides
http://csharp-video-tutorials.blogspot.com/2013/10/part-3-object-datasource-in-aspnet.html
All GridView Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-asp.html
All GridView Slides
http://csharp-video-tutorials.blogspot.com/p/blog-page.html
All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd
All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists
In Part 2 of the asp.net gridview tutorial, we discussed about sqldatasource controls. Please watch Part 2, before proceeding with this video.
Sqldatasource control include sql queries, in the HTML of the aspx page. This may lead to the complexity of the project. That’s why, in real time, sqldatasource control is very rarely used.
Let us understand object datasource, with an example.
Let’s assume our project has the following 3 layers.
1. Presentation Layer – This includes the asp.net web application project, where we have webforms, their code-behind files etc.
2. Business Logic Layer – This is usually a class library project, which includes business objects, like customers, orders, products etc.
3. Data Access Layer – This is usually a class library project, that is responsible for all the database CRUD(Create, Read, Update and Delete) operations.
The above 3 layers interact in the following way.
Presentation Layer – Business Logic Layer – Data Access Layer – Database
Presentation Layer, calls Business Logic Layer which in turn will call, Data Access Layer. Data Access Layer performs all the CRUD operations on the database.
In reality, we may have each layer in it’s own project, but for the purpose of this demo, we will include the data access layer classes in our asp.net web application. We will discuss about building an asp.net web application with n-tier architecture and the difference between layers and tiers in a later video session.
At this point, drag “ObjectDataSource” control from the toolbox and drop it on WebForm1.aspx. Steps to configure “ObjectDataSource”
1. Flip the webform to design mode
2. Click on the little right arrow(Smart Tag). This should display “ObjectDataSource Tasks”
3. Click on “Configure DataSource” link
4. From “Choose your business object” dropdownlist select “Demo.ProductDataAccessLayer” and click “Next”
5. From “Choose a method” dropdownlist, select “GetAllProducts()” and click “Finish”
At this point, we are done, configuring ObjectDataSource control. Now, drag a GridView control from the toolbox and drop it on the webform. Finally associate “ObjectDataSource1” with “GridView1” control using DataSourceID property of “GridView1” control. Run the application and data from “tblProducts” table should now be displayed in the gridview control.
-
Access DataSource in asp.net
AccessDataSource in asp.net
Alert
another gridview
ascending
asp net gridview access database
asp.net
asp.net c# bind xml to gridview
asp.net data source controls
asp.net datagridview
asp.net datasource controls
asp.net get data from access database
asp.net gridview
asp.net gridview bind to xml
asp.net gridview edit
asp.net gridview formatting
asp.net gridview sqldatasource
asp.net gridview xml c#
asp.net gridview xml file
asp.net ms access database example
asp.net objectdatasource explained
between
bi-directional
bidirectional
bind xml file to gridview in asp.net
binding xml file to gridview
business objects
C#
c# accessdatasource
c# data source object
c# datagrid example
c# get data from access database
c# gridview sqldatasource
c# sql data source connection string
c# sqldatasource example
c# sqldatasource selectcommand
c# xslt example
c# xslt transform xml document
c# xslt tutorial
c#.net
cells
changing data
checkbox
client-side
code
colspan
CompareAllValues
compute
concurrency
confirm
ConflictDetection
conflictdetection property
content
control
controls
convert xml node to attribute
custom paging
Data
DataFormat String
DataFormatString
datagrid in asp.net
datagrid in c#
DataKeyNames
dataset
datasource
datasource controls
default paging
delete
delete confirmation
delete data
Deleting
deleting data
descending
detailed data
details view
details view in asp.net
DetailsView
difference
display
Displaying
displaying gridview
document
Drill Down
Drilldown
drilling down
dropdownlist
edit
edit and update
editing
EmptyDataTemplate
EmptyDataText
event
example
Excel
Export
exporting
footer
footer row
format
formatting gridview at runtime
Formatting gridview in code
generate
Grid View
gridview
gridview currency format
gridview datasource xml file
gridview date format
gridview ms access database
gridview retrieve templatefield value
gridview RowDataBound
gridview template
gridview templatefield
gridview templatefield get control
GridViewDeletedEventArgs
hierarchical data
how
how to display date in gridview without time
How to get value from TemplateField in GridView
how to pass data from gridview to another page in asp.net
image field
imagefield
images
implement
implementing
insert
inside
javascript
jquery
KeepInEditMode
Merging. merge
microsoft
multiple rows
nested
nested gridview
nesting
no data
no rows in datasource
object datasource
object datasource in asp.net
objectdatasource
objectdatasource in asp.net
order
OverwriteChanges
page
page numbers
page size
paging
pdf
properties
read xml file with child nodes c#
Repeater
Retrieve ItemTemplate control value in Gridview
row cells
rowcommand
rowdatabound
rowdatabound event
RowDataBound example
RowDeleted event
RowUpdated
several rows
show date only in gridview
showing
sort
sort arrows
sort images
sortable
Sorting
sqldatasource
sqldatasource in asp.net
stored procedures
summary data
templatefield
totals
tutorial
two or more rows
Update
update data
Updated
updating
updating data
Use
use optimistic concurrency
using
validation
Validation Controls
web server
when
without
without data source controls
without datasource controls
Word
workbook
working with
xmldatasource in asp.net
xslt basics
xslt example
xslt to transform xml to xml
xslt transformation
xslt transformation c# example