kmsystems - Web Application Development - Journal - Linq to SQL basic list/grid view and form view

Saturday

Jan102009

Linq to SQL basic list/grid view and form view

Saturday, January 10, 2009 at 3:45PM

Lately I've been getting more and more into using Linq to SQL and think it rocks, Linq takes care of all the hard back end database functions so that you can focus on the interesting business logic of fun design and styling. I've been doing some research on the basics of Linq and found that most tutorials only show the List/GridView. However there was not many tutorials on working with Forms. So I have put together this basic tutorial to get you started. I have to give a lot of credit to aDefWebserver for this tutorial http://www.adefwebserver.com/DotNetNukeHELP/LinqTutorial2/LinqTutorial2_3.htm which although it specific to DotNetNuke a lot of the concepts can be learned here.

I have created a very basic database called "Contacts" with a table called "MyContacts", here is a screenshot of this table.

I prefer to set up a new database user now for this specific application so that when it comes to deploying the application your ready to go.

Now I will create a New Web Site in Visual Web Developer 2008 Express Edition called "MyContacts"

In the Database Explorer right button click on the Data Connections root and select Add Connection

Add a new Linq to SQL Classes item called "My_Contacts_DataClass.dbml" under the App_Code folder

Once the My_Contacts_DataClass opens drag the "MyContacts" table onto the data class from the Database Explorer

Add a new web form called "List_MyContacts.aspx" for the list/grid view

Add a LinqDataSource from the Data section in the Toolbox to your new List_Mycontacts page and select Configure Data Source

Select the My_contacts_DataClassDataContext object and click next

Click the "Advanced" button and select which options you want to allow from the list/grid view. In this case I only want to allow Delete

Add a GridView from the Data section in the Toolbox to your new List_Mycontacts page and select the LinqDataSource1 as the Data source. Then check Enable Deleting and Selection so that the user can either delete the record directly from the list or select it to view it in the form view mode.

Select the GridView control and open the properties and click on the lightning bolt to see the events. Double click on the SelectedIndexChanged event and enter the following line of code within this SelectedIndexChanged procedure. This code will open the update page with the selected record in the form view.

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)

{

Response.Redirect("Update_MyContacts.aspx?ContactId=" + Convert.ToInt32(GridView1.SelectedDataKey.Value) + "");

}

Add a new web form called "Update_MyContacts.aspx" for the form view

Add a LinqDataSource from the Data section in the Toolbox to your new Update_Mycontacts page and select Configure Data Source

Select the My_contacts_DataClassDataContext object and click next

Click the "Advanced" button and select which options you want to allow from the list/grid view. Here I want to allow Insert, Update and Delete

Also click on the Where button and select the Contact_Id is equal to the a parameter passed via the query string so that when a user selects an item on the list/grid view page the update form will know which item the user wants to edit. Add the where clause

Add a FormView from the Data section in the Toolbox to your new Update_Mycontacts page and select the LinqDataSource1 as the Data source.

That's it now you can open your browser and browse the application. Here is the first page the list/grid view

When you click on the Select link in the grid view the page redirects to the Update page to display the form view in read only mode

Now when the user clicks on the Edit link the form will automatically switch into update mode so they can update the data and save it

Now that all of the data access functionality has been automatically created by Linq all you need to focus on is design and logic.

David Abrahams |

11 Comments |

Application Development

View Printer Friendly Version

Email Article to Friend

Reader Comments (11)

Most of their diamonds or gemstones are synthetic for decoration. Anyhow, Jacob & Co replica watches,these kinds of timepieces do offer some of those who are longing for designer wristwatches with limited budget a good opportunity to go through high-class.

July 29, 2010 |

ivan.watcheslux

MBT shoes is good for summer. In the summer, it is a great foot injury to wear out gas-tight shoes. So take care of your feet is a useful way to protect disease. MBT shoe extremely concerned about human feet.

August 12, 2010 |

mbt

GHD Straighteners
UGG Boots
The North Face
Cheap GHD
GHD Hair
GHD Hair Straightener
GHD Purple
GHD Straighteners Australia
GHD Mini Styler
GHD Outlet
GHD MK4

September 14, 2010 |

MAC Cosmetics

Your composition is very good and very useful , I like it very much.I have never read such a lovely article and I am coming back tomorrow to continue reading.omega constellation

November 22, 2010 |

Sherry S. Hayhurst

take one thing from her,Onitsuka Tiger X Tokidoki Fabre, is a seed, looked very ordinary seeds, then said this is my early years in the northern United States to practice when the new Bi, with an old man learned the conjuration, called parasitic seed had only learned of this technique

The effect of party strength,asics gel shoe, not a powerful trick. But then after I study more, and on this basis, the success will be its own laws on the part of the soul and the body through the seeds into each other as long as my sense of latent pressure off the other side, I can easily control each other’s body.

You will only be because I control this

Incredible confusion Road, you’re in my body the seed implantation However, in the end is when

Just you and I met that day you forgot That was almost strangled me you, that is, that was when I put seeds into your body

Even this be Immediately understand, the day he was onitsuka tiger shoes to strangle neck, had lost consciousness for a short time and wanted to onitsuka tiger shoes is in the hands of time to do that.

Like this, angrily pointing onitsuka tiger shoes, select channel you lie to me you play the fool

I did not lie to you onitsuka tiger shoes explained before that day, my mental state has been good times and bad, but the day to meet you, find your Xinghuoliaoyuan, I guess you to the origins of faint, his head more and more sober. Later, another fit of madness I,

Stuck your neck, I read your mind and from your memory, they realized you really are disciples of Iowa Iowa I know will not die, but did not expect this point, onitsuka tiger shoes motivated her to also have people guess onitsuka

the mouth of the Iowa tiger shoes is who How to make her so sad

What seems to think, face dramatic changes, warble Road, you see that you are all that matter

onitsuka tiger shoes looked toward his eyes full of anger and blame, but there are a trace of frustration, sidewalk rest assured that your hand is cultivated out of Iowa, and that thing was his voluntary, so I will not kill you

Silent bow, and looked sad, actually could not help but shed tears, the people are seen somehow, I do not know him and what onitsuka tiger shoes playing charades.

onitsuka tiger shoes saw that his eyes turn a little relaxation, but also Road, Iowa explain your thing, I know

Since you know the master’s intention, then why did he do ah Regretfully shook his head, the asics gel foundation that I promised to add a single master to the Queen wonderful things,Onitsuka Tiger Ultimate, but you are you let me explain how the master of the dead ah.

November 22, 2010 |

asics shoes

Wholesale New Era Hats
Los Angeles Angels Hats
Milwaukee Brewers Hats
Minnesota Twins Hats
New York Mets Hats
Oakland Athletics Hats
Philadelphia Phillies Hats
Pittsburgh Pirates Hats
San Diego Padres Hats
San Francisco Gaints Hats
St.Louis Cardinals Hats
Tampa Bay Rays Hats
Texas Rangers Hats
Toronto BLue Jays Hats
Washington Nationals Hats
Seattle Mariners Hats
Arizona Diamondbacks Hats
wholesale New Era Jordan Hats

Wholesale New Era Hats
Kansas City Royals Hats
Los Angeles Angels Hats
Los Angeles Dodgers Hats
Milwaukee Brewers Hats
Minnesota Twins Hats
New York Mets Hats
Oakland Athletics Hats
Philadelphia Phillies Hats
Pittsburgh Pirates Hats
San Diego Padres Hats
San Francisco Gaints Hats
St.Louis Cardinals Hats
Tampa Bay Rays Hats
Texas Rangers Hats

June 15, 2011 |

Wholesale New Era Hats

July 20, 2011 |

hahahaha

August 1, 2011 |

louis vuitton outlet

Even if you shop for your special occasion at the last moment, you are sure to find something nice at ugg boots sale. cheap ugg gifts are not restricted to just your lover, you could also pick perfect for almost everyone, including your family and friends. What is so extraordinary and unusual when it comes to cheap boots is that you have an option to pick and select your own to be attached onto the of your preference. Just in the range of cheap ugg boots, it provides options of a standard or you could opt for the obsidian. Once you select the bracelet, then you select the charms to be supplemented onto the bracelet. You will have so many options to choose from the UGG Classic Mini Boots that it may just get very difficult for you to make a choice. Well the UGG Classic Tall Metallic Boots are not limited to the use of bracelets; they can be used on as well. So your wait for a good piece of cheap ugg boots ends with the variety offered. cheap boots is incredibly popular, and the collectable nature of these beautiful pieces of means that many people are searching for them online. As with any designer label, there will always be companies selling cheap ugg, however when you are buying online how can you be sure that what you are purchasing is the genuine . If you are buying directly from the official ugg boots sale, then you are of course going to be getting the real deal. However there are many resellers, and smaller ugg boots outlet stores which may have special offers or stock a particular item which you cannot find elsewhere. Thankfully, ugg boots sale are forward thinking, and give the stores which they supply to online a "Certified Online Retailer" badge which they can display on their websites. If you are still unsure about whether or not the site is genuine, you could always visit the genuine ugg boots website and do a store search for the online retailer. If they appear in ugg boots on sale listings then they are sure to be an authentic reseller. For those of you wanting to save big bucks on your GHD straighteners, try shopping online. You can find great buys and save on the hottest designer GHD hair straighteners through online auctions. Get all of these fabulous GHD straighteners UK and more high-end designer fashions for less when you shop on the Internet. Now everyone can own high-end designer cheap GHD Straighteners. ghd hair straighteners uk

November 25, 2011 |

cheap ugg boots

Helplessly watched the light on his brow, Mu Chen is unable to escape, when white light from him and a scale far when, he saw, flying is augg boots sale previous hit him in the shoulder in the heart of the stone as like as two peas. Iugg boots clearancen the face of the flying stones, he helpless eyes closed.

December 6, 2011 |

wendy

With thunder two years and $6.5 million contract renewal

8. With thunder two years and $6.5 million contract renewal of KuiAn-cook. Cook in 2007 the first round of the 76 draft night 21 people team selected,cheap nike air max,
cheap nike air max 24/7,
nike shoes outlet,
cheap nike air max 90,
cheap nike air max 2012,
cheap nike air max shoes the four seasons has played in the heat and thunder. In the 222 games, cook averaging can get 7.5 points and 2.3 rebounds. On behalf of his team last season thunder 43 games,Wholesale nba Jerseys,cheap nhl Jerseys,Wholesale NFL Jerseys , NBA Jerseys,cheap mlb jerseys, NFL Throwback Jerseys,cheap nfl Jerseys,cheap NBA Jerseys cook all present 13.9 minutes with the can get 5.6 points and 1.7 rebounds, his 3-point shot 42.2%. And the three points is the lack of the thunder,cheap air max,
cheap air max shoes,
cheap jordan shoes,
cheap air max 90,
nike air max 2012,
air max shoes this is also out of contract he thunder decided to reason.cheap nfl jerseys,
cheap nhl jerseys,
football jerseys,
nfl football jerseys,
cheap nfl football jerseys,
cheap mlb jerseys,
cheap nba jerseys,
nfl jerseys cheap,
wholesale nfl jerseys
9.76 people team this summer signing first cheap nba shoes rookie nicola-wu's cut and second round picks pull walter Iraq Allen. Wu's cut from nba basketball jerseys,
cheap nba basketball shoes,
nba jerseys,
cheap nba shoes,
cheap NBA Throwback Jerseys,cheap nba jerseys the university of southern California, he in the first round of the 16 th overall 76 team selected, and walter Iraq is in total 50 overall pick.Green Bay Packers NFL Jerseys,
San Francisco 49ers NFL Jerseys,
Baltimore Ravens NFL Jerseys,
New Orleans Saints NFL Jerseys,
Pittsburgh Steelers NFL Jerseys,
New York Giants NFL Jerseys,
New England Patriots NFL Jerseys,
New York Jets NFL Jerseys,Cheap nfl jerseys,
nfl jerseys,
cheap mlb jerseys,nfl jerseys from china,cheap nhl jerseys,wholesale nfl jerseys,nfl jerseys cheap In addition, 76 people and free player Antonio Anderson, dwyane-Jones,wholesale authentic jerseys,
cheap authentic jerseys,cheap nhl jerseys,
wholesale authentic nfl jerseys,cheap mlb jerseys,
cheap authentic nfl jerseys.
Green Bay Packers NFL Jerseys
San Francisco 49ers NFL Jerseys
Baltimore Ravens NFL Jerseys
New Orleans Saints NFL Jerseys
Pittsburgh Steelers NFL Jerseys
New York Giants NFL Jerseys
New England Patriots NFL Jerseys mike-of Atlantis, and Xavier-sheila, so that 76 people of the book's list to reach 15 people.Herve Leger,
Herve Leger on sale,
authentic Herve Leger,
wholesale Herve Leger,
cheap Herve Leger,
Herve Leger Dress

January 10, 2012 |

nflstorechina

Post a New Comment

Enter your information below to add a new comment.

My response is on my own website »

Author:

Author Email (optional):

Author URL (optional):

Post:

↓ | ↑

Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <blockquote cite=""> <code> <strike>