(solution) CSCI 322 Fall 2 Homework – Unit 6 Homework 6 Learning Outcomes-

(solution) CSCI 322 Fall 2 Homework – Unit 6 Homework 6 Learning Outcomes-

I need help with my homework assignment, it is a wed programming project working with ASP.net, I am currently using VS-13, I would really appreciate it if you could include a word document that has the codes for all of the required pages, please see attached file for the assignment. I do need it asap. I’m moving and do not have internet access all of the time, so I would really appreciate your help.

CSCI 322 Fall 2 Homework ? Unit 6 Homework 6
Learning Outcomes- FOLLOW THE GENERAL HOMEWORK DIRECTIONS! 1. Manually bind simple data to web server controls and to out put the data on the web
page.
2. Use SQL and C# to create web pages to manually manage your data
(selecting, inserting, updating and deleting data)
3. Use command, connection and dataset objects and the DataAdapter, DataTables and
DataRows to manage data. Part 1
Learning Outcome 1. Manually bind simple data to web server controls and to out put the data on the web page
Directions
A) Provide the version of Visual Studio and SQL Server in the word document.
B) In the main menu, create a menu item named Database in the web.sitemap file. For each new page
in this homework, make sure there is a link to the page in the main web.sitemap file so that the links
will be displayed in the main menu. Make sure the menu or treeview you used, is formatted so that
it is easy to read and well-styled. Below is a sample of what you would do. Each time you create a
new page in this homework, add a link in the Database submenu. Provide a screen shot of the
sitemap file, as well as how the menu looks in your browser with this submenu shown!
References: http://www.codeproject.com/Articles/20163/ASP-NET-Menu-using-Sitemap-andMasterPage and http://www.w3schools.com/aspnet/aspnet_navigation.asp
<?xml version="1.0" encoding="ISO-­?8859-­?1" ?> <siteMap> <siteMapNode title="Home" url="home.aspx"> <siteMapNode title="Contact" url="contact.aspx" /> <siteMapNode title="Database" url="database.aspx"> <siteMapNode title="Pet Food List" url="RBLFoodList.aspx"/> <siteMapNode title="Pat List" url=" DDLFoodList.aspx"/> <siteMapNode title="Select Category" url="CategorySelect.aspx"/> <siteMapNode title=" " url=" .aspx"/> <siteMapNode title=" " url=" .aspx"/> </siteMapNode> </siteMapNode> </siteMap> CSCI 322 Fall 2 Homework C) In the lesson you learned how to bind data to controls, including data from the database. In this
example retrieve your data with the connection, command and reader objects and display the data
in a control.
Binding to a List Control- RadioButton
1. Create a page named RBLFoodList.aspx with the menu displayed as Pet Food List.
2. In the design view, insert a RadioButtonList control named rblFood.
3. Set the properties of the control so the number of columns is 3.
4. In the RBLFoodList.aspx.cs page, define a list (or array) named lstFood.
5. Insert this data into the list.
a.
b.
c.
d.
e.
f.
g.
h. Authority
AvoDerm Natural
Bil-Jac
Blue Buffalo
Castor & Pollux
Cesar
Dog For Dog
Eukanuba i.
j.
k.
l.
m.
n.
o.
p. Freshpet
Great Choice
Hill's
Iams
Kibbles 'n Bits
NUTRO
Natural Balance
Nature's q.
r.
s.
t.
u.
v.
w. Nulo
Nutro
Pedigree
Purina
Royal Canin
Simply Nourish
Wellness 6. Bind this list data to the RadioButtonList control. Display the data returned in a radio button list.
References: http://www.dotnetfunda.com/tutorials/controls/radiobuttonlist.aspx and
http://www.w3schools.com/aspnet/aspnet_arraylist.asp and https://msdn.microsoft.com/enus/library/system.web.ui.webcontrols.radiobuttonlist(v=vs.110).aspx
Binding to a List Control – DropDownList
1. Create a page named DDLFoodList.aspx with the menu displayed as Pet Food List.
2. In the design view, insert a DropDownList control named ddlFood.
3. In the DDLFoodList.aspx.cs page, define a list (or array) named lstFood.
4. Insert this data into the list.
5. Display the data returned in a DropDownList control in the browser
Part 1 Submission
1. Take a screen shot of the RBLFoodList.aspx and DDLFoodList.aspx in the browser showing
the list and place it in Part 1 of the Word document.
2. Take a screen shot of the markup and CS code for both RBLFoodList.aspx and
DDLFoodList.aspx.
Reference: http://www.dotnetfunda.com/tutorials/controls/dropdownlist.aspx and
https://msdn.microsoft.com/enus/library/system.web.ui.webcontrols.dropdownlist(v=vs.110).aspx CSCI 322 Fall 2 Homework Part 2
Learning Outcome
2. Use SQL and C# to create web pages to manually manage your data
Directions
1. Create web pages to manage the Categories table. Make sure to update the Database submenu as
described earlier.
a. CategorySelect.aspx (Select Category) will only display the data from the category page.
So, manually write the code using the connection, command and reader that display the
simple list of categories in a dropdown list control! b. CategoryInsert.aspx (Insert Category) will be used to create a new record. The form,
which you create, contains fields for each of the fields in the Categories table. When the
user clicks on the submit button, you will create a new SQL statement and insert a new
record in the Categories table. Once the data is inserted, display a message that the record
was inserted successfully and the values that were entered, formatted nicely!
c. CategoryUpdate.aspx (Update Category) will retrieve the list of categories and populate
them in a dropdown list. When the user selects a category, the data for that category is
populated in the update form. The form you create contains fields for each field in the
Categories table. When the user clicks the submit button, once the data is updated, display
a message the record was updated successfully and updated values formatted nicely!
Reference: http://www.devmanuals.com/tutorials/ms/aspdotnet/updatedataindatabase.html d. CategoryDelete.aspx (Delete Category) will retrieve the list of categories and populate
them in a dropdown list. When the user selects a category, the data for that category is
immediately deleted from the database. Once the data is deleted, display a message that
the record was deleted successfully and deleted values formatted nicely!
Part 2 Submissions
1. Take screen shots and insert in Part 2 of the Word document for the CategorySelect.aspx page
showing the list of Pets, CategoryInsert.aspx showing the category was inserted,
CategoryUpdate.aspx showing the category was updated, CategoryDelete.aspx showing the
category was deleted.
2. Take a screen shot or copy the code for each code file (CS files) for each of these pages into
part 2 of the Word document. CSCI 322 Fall 2 Homework Part 3
Learning Outcome 3. Use command, connection and dataset objects and the DataAdapter, DataTables
and DataRows to manage data
Directions
A) Create a new page named DataSet.aspx named Customer DataSet in the web site menu.
B) Use the DataAdapter, DataSet and DataTables to manage the Products table.
a. Create Connection object b. Create the SQL Statement to retrieve the Products table
c. Create a Command Object d. Create Data Adapter
e. Create DataSet f. DataAdapter Fills DataSet with a table g. Rotate through DataRows in DataTables and display the data!
Part 1 Submission
1. Take a screen shot of the DataSet.aspx in the browser showing the list of customers in Part 3 of
the Word document
2. Take a screen shot or copy the CS code from the DataSet.aspx into the Part 3 of the Word
document. CSCI 322 Fall 2 Homework Grading Criteria
Part Part 1
Create the Database
submenu LO Exceeds 1 Points Web.sitemap 10` 1 30
All pages created
All data functions worked.
Displayed all messages.
2 Points
Part 3
Use command, connection
and dataset objects and the
DataAdapter, DataTables and
DataRows to manage data. Two binding examples worked, with
data displayed and the properties
set (i.e. number of columns).
RBLFoodList.aspx
DDLFoodList.aspx Points
Part 2
Use SQL and C# to create
web pages to manually
manage your data
(selecting, inserting, updating
and deleting data) CategorySelect.aspx
CategoryInsert.aspx
CategoryUpdate.aspx
CategoryDelete.aspx
30 3 Did not provide the version of
Visual Studio and SQL Server
with your word document! * 8 4 0 Only one example
worked and displayed
data correctly. No example worked or correct
but attempt was made to
display the data controls * 21 18 0 All pages created Only displayed the data so only
the select function worked. Only 3 management
functions worked.
Displayed at least 2
messages.
21 Did not create or correctly
create the pages and code to
manage the database manually * Displayed at least 1 message.
18 0 * DataSet.aspx
30 Total NE Provided the version of
Visual Studio and SQL
Server with your word
document! Used the correct objects, Dataset,
Adapter, DataTables and displayed Did use all of the objects
Did not use the DataSet or
the data.
correctly or did not
DataAdapter or did not display
display the data correctly
the data Points Does not Meet All pages listed in the menu as a
Database submenu and the links All the pages listed or did
Did not create the submenu or
work.
not create a submenu.
list the pages correctly. Provided the version of Visual
Studio and SQL Server with your
word document! Part 1
Manually bind simple data to
web server controls and to
out put the data on the web
page Meets 100 21 18 0
0