Though I have been programming for over 10 years, I am a complete .NET noob. I have been working with GridViews for several weeks and after much blood and tears(literally) I have finally figured out how to use GridViews with ObjectData Sources.
Over the past three weeks several specific problems have cost me 3-4 days to figure out. To organize myself, I typed up a step-by-step instruction manual for creating a GridView page (with an Insert section) using my company's provided ObjectData Sources.
While the following may not be a step-by-step instruciton applicable to your specific situation, there are many little gems that may save you fellow .Net noobs a few days of frustration!
If you disagree with me on how to do something then .. well you are probablty right and I would appreciate you to set me straight!
So here it is in all of it's rawness.
Note on Refreshing Class Libraries
If you have your objects squirreled away in a class library, then it may be hard to get yoru changes to show up in the designer.
Every time a change is made in a class library the changes will
not show up in the design pager until you:
Open the class library and press CTRL-ALT-B (to rebuild)
Open the DateSource's Smart Tag on the Design View and choose Refresh Schema
Some popups will jump out - DO NOT SAY YES TO EITHER QUESTION ABOUT RELOAING, unless you want to erase all work so far.
Note: If nothing happens when you press Refresh Schema, then it didn’t work.This is not uncommon.Recompile the whole project, or delete the files in the Bin folder. Try again.
Background on the DATA Objects
The GridView accepts objects as rows and will use these objects to display the editable grid. However, (to my
great surprise) when you edit the row and hit “Save” the GridView DOES NOT pass back the actual object. Instead it constructs a new object from scratch and fills in
only the columns explicitly displayed/handled in the GridView.
Therefore a Business-layer object need to receive the infant object/row and beef it up.
Example:
You have a collection of records. When instantiated they are quite full with all sorts of meta-data like – date of last change, created-by user. Some of these fields are to be calculated, and some of these fields
are to be sent on a round-trip. Create BIZ methods objects that will take in the infantile object, handle all the columns explicitly. (you can also use the
DataKeyNames property - explained later)
Create the BIZ Insert methods in the BIZ object
Will handle all fields that need to be explicitly calculated or handled.
Create the BIZ Update methods in the BIZ object
Will handle all fields that need to be explicitly calculated or handled.
Drag a new ObjectDataSource to the page and configure it
Match up the Select, Insert_BIZ, and Update_BIZ methods to their respective events.
UPDATE Section
Create a GridView
Link to the ObjectDataSource created above
Using the Property bar: Add all round-trip hidden fields to
DataKeyNames Property
For example Record ID's
(If the ID's are read-only then... well... your screwed...get creative.)
Click GridViewTasks -> Edit Columns…
Delete Cols not to be displayed (Biz method will handle them)
Reorder the cols (for aesthetics)
Rename the headers (for aesthetics)
Make the non-editable fields ReadOnly
Make the Public Resolve Fields for the ID’s (i.e. you want to display UserName “Joe” instead of UserID “23343”)
I found it necessary to add actual new properties to the object for columns that require differetn data. It seems that the GridView wants 100% of the data reconcilled before it is handed over. I named them
stuff like BIZ_UserName, and BIZ_WarehouseName
Add new properties to the SELECT class
i.Create a Get method
1.return string based on private data
a.(don’t forget to check for errors and scrub data)
ii.Create an empty Set statement (GridView crashes otherwise)
For each column that needs a resolved version
i.Turn the column into a template, and close
ii.Edit Binding for the
Item Template
iii.Change the bound field
If the column is not handled by the Biz Update Method, add it to the
DataKeyNames Property (else it will not round-trip)
Determine the fields that need a Dropdown for the editing portion
For each
i.Make the field into a Template and close –
probably already a template from last step
ii.Open the templates and Delete the input field in the
EditItemTemplate
iii.Create a SQL data object (or whatever you want) - and configure it to pull up the appropriate data for the dropdown
1.Note: Don’t add the DataObject into the actual template field, add it on the main page so that it can be reused by other dropdowns if needed.
2.Rename the data object to something meaningful
iv.Drag a Dropdown to the
EditItemTemplate
v.Choose data source for the object
1.Choose the Value and Display fields
vi.Set the SelectedID
1.Choose Data Bindings for the DropDown
2.Set the SelectedValue property to the ID of the previously deleted field
INSERT Section
Drag and Drop a Detail View
Choose Data Source - > ObjectDateSource for the GridView (The same as above)
Edit Fields
Rearrange (for asthectics)
Rename headers (for asthectics)
For each field that needs a dropdown
Edit Field -> Change to Template
Open the INSERT template
Delete the text box
DnD a Dropdown
Change DataSource to the ALREADY existing data source used for dropdowns in the GridView above
Important –
i.Chose Edit Bindings
ii.Bind the Dropdown to the appropriate field
( This one really took me a while to figure out. You’d think that since we are only doing Inserts here, we don’t need to bind to a SelectedID. If you do not bind to the correct field, then your dropdown
will always return 0! )
On the GridView Enable Inserts (using the smart tag checkbox)
Switch to Source Mode and edit the DetailView to start off in Insert Mode
<asp:DetailsView
... DefaultMode="Insert">
Miscellaneous
To have a dropdown allow blank selections you have to UNION in a blank entry, else the bind crashes. For example:
SELECT [ProductID], [ProductName] FROM [CRM_Products]
hope if you can put this taturial in articles websites like
http://www.codeproject.com and put it with detailed code & images so it will be more readble and useful.. & just here provide us with a link to it....
nice & helpful taturial, thanks
Regards,
Nassar, Rami (MCP, MCTS, MCPD)
My Blog || E-Mail
Don't forget to click "Mark as Answer" on the post that helped you.
JLibertor
Member
100 Points
22 Posts
GridView with Insert Section - My Step-by-Step Notes (Almost a Tutorial)
Jan 24, 2006 10:12 PM|LINK
Though I have been programming for over 10 years, I am a complete .NET noob. I have been working with GridViews for several weeks and after much blood and tears(literally) I have finally figured out how to use GridViews with ObjectData Sources.
Over the past three weeks several specific problems have cost me 3-4 days to figure out. To organize myself, I typed up a step-by-step instruction manual for creating a GridView page (with an Insert section) using my company's provided ObjectData Sources.
While the following may not be a step-by-step instruciton applicable to your specific situation, there are many little gems that may save you fellow .Net noobs a few days of frustration!
If you disagree with me on how to do something then .. well you are probablty right and I would appreciate you to set me straight!
So here it is in all of it's rawness.
Note on Refreshing Class Libraries
If you have your objects squirreled away in a class library, then it may be hard to get yoru changes to show up in the designer.
Every time a change is made in a class library the changes will not show up in the design pager until you:
Note: If nothing happens when you press Refresh Schema, then it didn’t work. This is not uncommon. Recompile the whole project, or delete the files in the Bin folder. Try again.
Background on the DATA Objects
The GridView accepts objects as rows and will use these objects to display the editable grid. However, (to my great surprise) when you edit the row and hit “Save” the GridView DOES NOT pass back the actual object. Instead it constructs a new object from scratch and fills in only the columns explicitly displayed/handled in the GridView.
Therefore a Business-layer object need to receive the infant object/row and beef it up.
Example:
You have a collection of records. When instantiated they are quite full with all sorts of meta-data like – date of last change, created-by user. Some of these fields are to be calculated, and some of these fields are to be sent on a round-trip. Create BIZ methods objects that will take in the infantile object, handle all the columns explicitly. (you can also use the DataKeyNames property - explained later)
UPDATE Section
I found it necessary to add actual new properties to the object for columns that require differetn data. It seems that the GridView wants 100% of the data reconcilled before it is handed over. I named them stuff like BIZ_UserName, and BIZ_WarehouseName
i. Create a Get method
1. return string based on private data
a. (don’t forget to check for errors and scrub data)
ii. Create an empty Set statement (GridView crashes otherwise)
i. Turn the column into a template, and close
ii. Edit Binding for the Item Template
iii. Change the bound field
i. Make the field into a Template and close – probably already a template from last step
ii. Open the templates and Delete the input field in the EditItemTemplate
iii. Create a SQL data object (or whatever you want) - and configure it to pull up the appropriate data for the dropdown
1. Note: Don’t add the DataObject into the actual template field, add it on the main page so that it can be reused by other dropdowns if needed.
2. Rename the data object to something meaningful
iv. Drag a Dropdown to the EditItemTemplate
v. Choose data source for the object
1. Choose the Value and Display fields
vi. Set the SelectedID
1. Choose Data Bindings for the DropDown
2. Set the SelectedValue property to the ID of the previously deleted field
INSERT Section
i. Chose Edit Bindings
ii. Bind the Dropdown to the appropriate field
( This one really took me a while to figure out. You’d think that since we are only doing Inserts here, we don’t need to bind to a SelectedID. If you do not bind to the correct field, then your dropdown will always return 0! )
Miscellaneous
UNION ALL
SELECT '', ''
ORDER BY ProductID
rami_nassar
Contributor
3608 Points
828 Posts
Re: GridView with Insert Section - My Step-by-Step Notes (Almost a Tutorial)
Jan 03, 2009 11:33 AM|LINK
hope if you can put this taturial in articles websites like http://www.codeproject.com and put it with detailed code & images so it will be more readble and useful.. & just here provide us with a link to it....
nice & helpful taturial, thanks
Nassar, Rami (MCP, MCTS, MCPD)
My Blog || E-Mail
Don't forget to click "Mark as Answer" on the post that helped you.
brijmohans10
Participant
1133 Points
242 Posts
Re: GridView with Insert Section - My Step-by-Step Notes (Almost a Tutorial)
Jun 17, 2009 11:23 AM|LINK
is it 3-tier arch.??? b'cause object datasource is used in 3-tier arch.
brij
Remember to click “Mark as Answer” on the post, if it helps you.
brijmohans10
Participant
1133 Points
242 Posts
Re: hiii
Jun 17, 2009 11:27 AM|LINK
i think you should go to www.asp.net/learn/dataaccess.
brij
Remember to click “Mark as Answer” on the post, if it helps you.
johnly
Member
292 Points
56 Posts
Re: GridView with Insert Section - My Step-by-Step Notes (Almost a Tutorial)
Jul 12, 2009 08:03 PM|LINK
Hi JLibertor,
Thanks for this useful article. I was searching for this for a long time. it really helped.
Your article and the below article helped me.
http://forums.asp.net/p/889109/939477.aspx
Zebralive | Send BulkSMS