Re: GridView with Insert Section - My Step-by-Step Notes (Almost a Tutorial)

johnly — Sun, 12 Jul 2009 20:03:31 GMT

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

Re: hiii

brijmohans10 — Wed, 17 Jun 2009 11:27:54 GMT

i think you should go to www.asp.net/learn/dataaccess.

Re: GridView with Insert Section - My Step-by-Step Notes (Almost a Tutorial)

brijmohans10 — Wed, 17 Jun 2009 11:23:58 GMT

is it 3-tier arch.??? b'cause object datasource is used in 3-tier arch.

Re: GridView with Insert Section - My Step-by-Step Notes (Almost a Tutorial)

rami_nassar — Sat, 03 Jan 2009 12:33:02 GMT

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

GridView with Insert Section - My Step-by-Step Notes (Almost a Tutorial)

JLibertor — Tue, 24 Jan 2006 23:12:22 GMT

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]

UNION ALL

SELECT '', ''

ORDER BY ProductID

FAQ - Frequently Asked Questions

Re: GridView with Insert Section - My Step-by-Step Notes (Almost a Tutorial)

Re: hiii

Re: GridView with Insert Section - My Step-by-Step Notes (Almost a Tutorial)

Re: GridView with Insert Section - My Step-by-Step Notes (Almost a Tutorial)

GridView with Insert Section - My Step-by-Step Notes (Almost a Tutorial)

Note on Refreshing Class Libraries

Background on the DATA Objects

UPDATE Section

INSERT Section

Miscellaneous