Easy Tutorial
Met Websecurity Changepassword Control Listbox Control Htmlinputbutton Prop Webcontrol Linkbutton Postbackurl Prop Webcontrol Listcontrol Selectedindex Prop Webcontrol Listcontrol Items Prop Webcontrol Tablerow Tablesection Met Websecurity Resetpassword Met Websecurity Createaccount Prop Webcontrol Calendar Showdayheader Prop Webcontrol Checkbox Textalign Aspnet Databinding Prop Webcontrol Style Borderstyle Webpages Helpers Webpages Ref Webmail Mvc Reference Prop Webcontrol Listcontrol Text Prop Webcontrol Calendar Todaysdate Met Websecurity Getpasswordchangedate Prop Webcontrol Calendar Nextmonthtext Webpages Ref Websecurity Met Websecurity Logout Control Adrotator Control Hyperlink Webpages Global Webpages Webgrid Prop Webcontrol Standard Borderstyle Prop Webcontrol Calendarday Isweekend Prop Webcontrol Bulletedlist Bulletimageurl Razor Cs Logic Prop Control Standard Visible Prop Webcontrol Tablecell Columnspan Prop Webcontrol Calendar Showgridlines Webpages Ref Database Mvc Security Prop Webcontrol Button Onclientclick Prop Webcontrol Table Caption Prop Webcontrol Tablecell Wrap Prop Webcontrol Adrotator Advertisementfile Aspnet Ref Htmlcontrols Prop Webcontrol Style Backcolor Prop Webcontrol Radiobuttonlist Repeatcolumns Webpages Razor Prop Webcontrol Textbox Text Prop Control Standard Uniqueid Prop Webcontrol Table Horizontalalign Prop Webcontrol Textbox Textmode Control Label Prop Websecurity Hasuserid Prop Webcontrol Standard Style Prop Webcontrol Calendar Selecteddaystyle Prop Webcontrol Textbox Readonly Control Customvalidator Control Reqfieldvalidator Aspnet Intro Prop Control Standard Page Prop Webcontrol Calendarday Isselected Prop Webcontrol Radiobuttonlist Repeatlayout 2 Prop Webcontrol Hyperlink Target Prop Webcontrol Image Imageurl Prop Webcontrol Bulletedlist Target Met Websecurity Isconfirmed Prop Webcontrol Calendar Selectorstyle Control Checkboxlist Webpages Php Webpages Folders Prop Webcontrol Button Text Mvc Models Prop Webcontrol Calendar Weekenddaystyle Index Prop Webcontrol Standard Tabindex Prop Webcontrol Listcontrol Datavaluefield Prop Webcontrol Listitem Selected Control Style Prop Webcontrol Standard Tooltip Mvc Layout Control Htmlinputimage Prop Webcontrol Style Bordercolor Prop Webcontrol Standard Borderwidth Control Comparevalidator Aspnet Xml Webpages Layout Razor Intro Control Calendarday Razor Vb Logic Prop Webcontrol Button Validationgroup Prop Webcontrol Imagebutton Validationgroup Prop Webcontrol Table Gridlines Prop Webcontrol Button Postbackurl Prop Webcontrol Adrotator Target Prop Webcontrol Tablecell Verticallalign Webpages Intro Met Websecurity Iscurrentuser Control Htmlinputtext Prop Webcontrol Standard Height Control Htmlinputcheckbox Prop Webcontrol Textbox Autopostback Control Htmlform Prop Webcontrol Calendar Selecteddates Prop Websecurity Isauthenticated Control Linkbutton Control Panel Control Placeholder Mvc Folders Prop Webcontrol Panel Wrap Control Radiobuttonlist Aspnet Ref Webcontrols Prop Webcontrol Style Borderwidth Aspnet Arraylist Prop Webcontrol Standard Bordercolor Prop Webcontrol Radiobuttonlist Repeatdirection Met Websecurity Confirmaccount Prop Webcontrol Standard Backcolor Webpages Ref Classes Control Image Control Bulletedlist Prop Webcontrol Calendarday Istoday Aspnet Events Prop Webcontrol Table Cellpadding Aspnet Repeater Met Websecurity Createuserandaccount Control Imagebutton Prop Webcontrol Panel Groupingtext Prop Webcontrol Tablecell Rowspan Prop Webcontrol Calendar Prevmonthtext Prop Webcontrol Calendar Nextprevformat Prop Webcontrol Calendar Selectweektext Prop Webcontrol Checkboxlist Repeatlayout Prop Webcontrol Image Alternatetext Prop Webcontrol Calendarday Date Prop Webcontrol Listitem Value Prop Webcontrol Calendar Shownextprevmonth Prop Webcontrol Linkbutton Onclientclick Prop Webcontrol Panel Defaultbutton Aspnet Tutorial Prop Webcontrol Table Cellspacing Control Htmlimage Prop Webcontrol Calendar Selectmonthtext Prop Webcontrol Panel Backimageurl Control Xml Razor Syntax Prop Webcontrol Standard Cssclass Met Websecurity Generatepasswordresettoken Control Htmltablecell Prop Webcontrol Bulletedlist Displaymode Control Checkbox Control Htmlinputfile Prop Webcontrol Imagebutton Postbackurl Prop Webcontrol Calendar Daystyle Control Rangevalidator Met Websecurity Requireroles Prop Webcontrol Bulletedlist Bulletstyle Prop Webcontrol Calendar Todaydaystyle Prop Webcontrol Listitem Text Control Radiobutton Prop Webcontrol Tablecell Text Prop Websecurity Currentuserid Control Dropdownlist Mvc Intro Prop Webcontrol Calendar Othermonthdaystyle Prop Webcontrol Textbox Rows Prop Webcontrol Calendarday Isothermonth Aspnet Masterpages Control Htmlinputradiobutton Prop Webcontrol Imagebutton Onclientclick Prop Webcontrol Radiobuttonlist Repeatlayout Prop Webcontrol Textbox Autocompletetype Control Htmltextarea Aspnet Viewstate Prop Webcontrol Style Height Met Websecurity Userexists Prop Webcontrol Checkbox Text Prop Webcontrol Calendar Caption Control Tablerow Prop Webcontrol Button Causesvalidation Prop Webcontrol Textbox Columns Prop Webcontrol Imagebutton Causesvalidation Prop Control Standard Clientid Control Htmltable Control Validationsummary Prop Webcontrol Linkbutton Validationgroup Control Htmlinputhidden Prop Webcontrol Textbox Maxlength Aspnet Dbconnection Met Websecurity Getcreatedate Razor Cs Variables Met Websecurity Login Prop Webcontrol Panel Direction Aspnet Sortedlist Prop Webcontrol Calendar Cellpadding Aspnet Button Prop Webcontrol Literal Text Prop Webcontrol Hyperlink Text Prop Websecurity Currentusername Prop Webcontrol Calendar Captionalign Prop Webcontrol Hyperlink Navigateurl Razor Vb Variables Control Listitem Prop Webcontrol Calendarday Daynumbertext Prop Webcontrol Checkboxlist Textalign Prop Control Standard Bindingcontainer Prop Control Standard Parent Prop Webcontrol Image Imagealign Met Websecurity Getuserid Prop Webcontrol Calendar Firstdayofweek Control Table Control Listcontrol Prop Webcontrol Calendar Nextprevstyle Prop Webcontrol Listcontrol Validationgroup Prop Webcontrol Calendar Cellspacing Prop Webcontrol Checkboxlist Repeatcolumns Webpages Objects Razor Vb Loops Aspnet Examples Prop Webcontrol Listbox Rows Prop Webcontrol Standard Accesskey Prop Control Standard Id Prop Webcontrol Linkbutton Text Prop Webcontrol Textbox Wrap Mvc App Control Calendar Prop Webcontrol Listitem Enabled Webpages Publish Aspnet Forms Webpages Ref Helpers Control Button Prop Webcontrol Style Forecolor Met Websecurity Requireauthenticateduser Aspnet Ref Validationcontrols Prop Webcontrol Standard Forecolor Prop Webcontrol Standard Prop Control Standard Prop Webcontrol Table Captionalign Prop Webcontrol Hyperlink Imageurl Prop Webcontrol Checkboxlist Cellpadding Aspnet Prop Control Standard Namingcontainer Met Websecurity Requireuser Prop Webcontrol Listcontrol Selecteditem Webpages Files Prop Webcontrol Tablerow Verticalalign Met Websecurity Initializedatabaseconnection Prop Webcontrol Listbox Selectionmode Prop Webcontrol Bulletedlist Firstbulletnumber Mvc Database Prop Webcontrol Calendar Selectionmode Mvc Views Prop Webcontrol Style Width Prop Webcontrol Tablerow Horizontalalign Mvc Controllers Webpages Examples Prop Webcontrol Checkboxlist Repeatdirection Aspnet Navigation Prop Webcontrol Checkboxlist Cellspacing Prop Webcontrol Standard Font Prop Webcontrol Calendar Dayheaderstyle Control Regularexpvalidator Mvc Publish Prop Webcontrol Xml Documentsource Aspnet Controls Prop Webcontrol Dropdownlist Selectedindex Prop Webcontrol Tablecell Horizontalalign Control Htmlanchor Aspnet Hashtable Webpages Forms Prop Webcontrol Standard Enabled Control Literal Prop Webcontrol Panel Scrollbars Mvc Htmlhelpers Prop Webcontrol Table Backimageurl Aspnet Pages Prop Webcontrol Radiobuttonlist Textalign Prop Webcontrol Calendarday Isselectable Prop Webcontrol Style Cssclass Prop Webcontrol Listcontrol Autopostback Prop Webcontrol Style Font Razor Cs Loops Prop Webcontrol Radiobuttonlist Cellspacing Prop Webcontrol Checkbox Checked Webpages Chart Control Textbox Aspnet Datalist Prop Webcontrol Listcontrol Datatextfield Control Htmlselect Prop Webcontrol Calendar Titlestyle Prop Webcontrol Button Usesubmitbehavior Prop Webcontrol Calendar Titleformat Prop Webcontrol Calendar Selecteddate Prop Webcontrol Listcontrol Selectedvalue Control Tablecell Aspnet Textbox Webpages Email Prop Webcontrol Panel Horizontalalign Control Htmlgeneric Control Htmlbutton Prop Webcontrol Calendar Showtitle Prop Webcontrol Calendar Daynameformat Prop Webcontrol Calendar Visibledate Control Htmltablerow Prop Webcontrol Radiobuttonlist Cellpadding
❮ Prop Webcontrol Bulletedlist Firstbulletnumber Prop Webcontrol Calendar Selectionmode ❯

ASP.NET MVC - SQL Database

To learn ASP.NET MVC, we will build an Internet application.

Part 6: Adding a Database.

Creating a Database

Visual Web Developer comes with a free SQL database called SQL Server Compact.

This database required for the tutorial can be created with a few simple steps:

* If the SQL Server Compact Local Database is not in the options, it means you haven't installed SQL Server Compact on your computer. Please install it through the following link: SQL Server Compact

Visual Web Developer will automatically create the database in the App_Data folder.

Note: For this tutorial, you need to have some basic knowledge about SQL databases. If you want to learn this topic first, please visit our SQL Tutorial.

Adding a Database Table

Double-click the Movies.sdf file in the App_Data folder to open the Database Explorer window.

To create a new table in the database, right-click the Tables folder and select Create Table.

Create the following columns:

Column Type Allow Null
ID int (primary key) No
Title nvarchar(100) No
Director nvarchar(100) No
Date datetime No

Explanation of columns:

ID is an integer (all numbers) used to identify each record in the table.

Title is a text column with a length of 100 characters, used to store the movie's name.

Director is a text column with a length of 100 characters, used to store the director's name.

Date is a date column used to store the movie's release date.

After creating the above columns, you must set the ID column as the primary key (record identifier). To do this, click the column name (ID) and select Primary Key. In the Column Properties window, set the Identity property to True.

When you have created the table columns, save the table and name it MovieDBs.

Note:

We deliberately named the table "MovieDBs" (ending with an 's'). In the next chapter, you will see the "MovieDB" used for the data model. This may seem a bit strange, but this naming convention ensures that the controller connects to the database table, and you must use it.

Adding Database Records

You can use Visual Web Developer to add some test records to the movie database.

Double-click the Movies.sdf file in the App_Data folder.

Right-click the MovieDBs table in the Database Explorer window and select Show Table Data.

Add some records:

ID Title Director Date
1 Psycho Alfred Hitchcock 01.01.1960
2 La Dolce Vita Federico Fellini 01.01.1960

Note: The ID column will update automatically, you don't need to edit it.

Adding a Connection String

Add the following element to the <connectionStrings> element in your Web.config file:

❮ Prop Webcontrol Bulletedlist Firstbulletnumber Prop Webcontrol Calendar Selectionmode ❯