New version page

WVU IENG 423 - Web-Enabled Decision Support Systems

Upgrade to remove ads
Upgrade to remove ads
Unformatted text preview:

Web-Enabled Decision Support SystemsOverviewIntroductionSlide 4Database Application TypesDatabase Application OverviewDatabase Application ProcessesDatabase Application Data CycleSlide 9Create the ProjectCreate a Data SourceCreate a Data Source (cont.)Slide 13Slide 14Slide 15Slide 16Using a DataGridView ControlTest the ApplicationProperty Window ReviewCode ReviewSlide 21Auto-Created Objects in the Component TrayAuto-Created Objects in the Component Tray (cont.)Slide 24Setting the Controls to be CreatedSetting the Controls to be Created (cont.)Slide 27Slide 28Slide 29Slide 30Adding a PictureBox ControlAssociating the Picture Column and TestingSlide 33Slide 34Adding the Related Transcript TableEditing the Transcript DataGridViewEditing the Transcript DataGridView (cont.)Slide 38Slide 39Testing the ApplicationSlide 41Property Window Review (cont.)Slide 43Slide 44DataGridView ControlSorting with DataGridViewData BindingDataGridView: In DepthSlide 49Hands-On Tutorial: Creating a Search FormAdding a Parameterized QueryAdding a Parameterized Query (cont.)Slide 53Slide 54Slide 55Preview Data for Newly Added QueryPreview Data for Newly Added Query (cont.)Slide 58Slide 59Slide 60The Query BuilderSlide 62Linking the Department TableLinking the Department Table (cont.)Slide 65Slide 66Slide 67Slide 68Slide 69Data Binding Properties of a ComboBox ControlSlide 71In-Class AssignmentSlide 73SummarySummary (cont.)Slide 761Web-Enabled Decision Support SystemsDatabase Connectivity with ADO .NETDon McLaughlin [email protected] Virginia University (304) 293-0405x42582Overview14.1 Introduction14.2 Database Applications Overview14.3 Hands-On Tutorial: Creating a Simple Database Application14.4 Auto-Created Objects in the Component Tray14.5 Hands-On Tutorial: Displaying Data in Individual Windows Controls14.6 Hands-On Tutorial: Binding Data to Existing Controls 14.7 Hands-On Tutorial: Displaying Related Data on a Windows Form14.8 DataGridView Control14.9 Hands-On Tutorial: Creating a Search Form 14.10 The Query Builder14.11 Hands-On Tutorial: Creating a Look-up Table 14.12 Data Binding Properties of a ComboBox Control14.13 In-Class Assignment14.14 Summary3IntroductionA database application is a computer program that allow users to manipulate data in a DBMS through a user-friendly interface Examples:–Amazon.comOnline shopping–Mapquest.comDriving directions–University portalsTranscripts and tuition payment information4Overview14.1 Introduction14.2 Database Applications Overview14.3 Hands-On Tutorial: Creating a Simple Database Application14.4 Auto-Created Objects in the Component Tray14.5 Hands-On Tutorial: Displaying Data in Individual Windows Controls14.6 Hands-On Tutorial: Binding Data to Existing Controls 14.7 Hands-On Tutorial: Displaying Related Data on a Windows Form14.8 DataGridView Control14.9 Hands-On Tutorial: Creating a Search Form 14.10 The Query Builder14.11 Hands-On Tutorial: Creating a Look-up Table 14.12 Data Binding Properties of a ComboBox Control14.13 In-Class Assignment14.14 Summary5Database Application TypesWe classify database applications into the following three categories:–Display-oriented applicationsDisplay data retrieved from a relational database on forms or web pagesExamples: Online newspapers, portal to view student transcript and grades, mapping websites–Transaction-oriented applicationsInvolve frequent transfer of data to and from a databaseExamples: Online shopping, portal for university faculty to enter student grades–Communication-oriented applications Communicate with other applications or processesExamples: Application with underlying optimization software, Crystal Reports, Map Point6Database Application OverviewA VB .NET database application involves connectivity between a database and a graphical user interface (GUI)Achieved through ActiveX Data Objects (ADO) .NET–A collection of objects (classes) designed to support data access and manipulation –The ADO .NET architecture forms the basis of VB .NET database applications–ADO .NET object examples:Connection objectTableAdapter objectDataSet object7Database Application Processes1. Connecting to the database–Establish a two-way communication channel via Connection object2. Fetching data using database queries–Bring data into an application in the desired format (filtered, sorted, etc.) via TableAdapter object3. Temporarily storing the result somewhere–Via DataSet object4. Displaying data on Windows forms–Data binding5. Editing data in the application6. Saving updated data back in the database8Database Application Data CycleDatabase Application Data Cycle9Overview14.1 Introduction14.2 Database Applications Overview14.3 Hands-On Tutorial: Creating a Simple Database Application14.4 Auto-Created Objects in the Component Tray14.5 Hands-On Tutorial: Displaying Data in Individual Windows Controls14.6 Hands-On Tutorial: Binding Data to Existing Controls 14.7 Hands-On Tutorial: Displaying Related Data on a Windows Form14.8 DataGridView Control14.9 Hands-On Tutorial: Creating a Search Form 14.10 The Query Builder14.11 Hands-On Tutorial: Creating a Look-up Table 14.12 Data Binding Properties of a ComboBox Control14.13 In-Class Assignment14.14 Summary10Create the ProjectHow-to: Create a Simple Database Application1. In Visual Studio, choose the File | New Project option from the Main menu to open the New Project dialog box.2. Make sure to select the Windows Application icon in the Templates area. 3. Name the project DatabaseConnectivity and click OK.11Create a Data Source4. Choose the Data | Show Data Sources option from the Main menu.5. In the Data Sources Window, click Add New Data Source to start the Data Source Configuration Wizard.Opening the Data Sources Window Invoking the Data Sources Configuration Wizard12Create a Data Source (cont.)6. Select the Database icon on the Choose a Data Source Type page of the wizard. Click Next.Choosing a Data Source Type13Create a Data Source (cont.)7. On the Choose Your Data Connection page, click New Connection to open the Choose Data Source dialog box.Specifying the Data Connection14Create a Data Source (cont.)8. Select the Microsoft Access Database File in the Data Source list box. Click on Continue.9. In the Add Connection dialog box that opens, select the


View Full Document
Download Web-Enabled Decision Support Systems
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view Web-Enabled Decision Support Systems and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Web-Enabled Decision Support Systems 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?