Tuesday, November 13, 2018
Monday, November 5, 2018
Tuesday, October 30, 2018
ASP .net Razor v.3 Database Demo
I found a interesting post about this type of site here:
WebPagesRazor W3Schools
In MS VisualStudio 19
1) Create a new web site pick ASP.NET Empty Web Site
2) Add ASP.NET folder App_Data
3) Find the member.accdb in the unit on blackboard download it and and add it to App_data
4) Add a NewItem Web Page (Razor v3)
5) Add the connection string in the Web.config file.
<connectionStrings>
<add connectionString="Provider=Microsoft.ACE.OleDb.12.0;Data Source=|DataDirectory|member.accdb;" name="member" providerName="System.Data.OleDb">
</add></connectionStrings>
6) Go into: Tools > NuGet Package Manager > Package Manager Console
And run the following command:
PM> Install-Package Microsoft.AspNet.WebPages.Data
then open the command prompt.
cd \Program Files (x86)\IIS Express
Then type the following command:
appcmd set config /section:system.webServer/directoryBrowse /enabled:true
7) Add this code (upto and including </body>) to your .cshtml file:
@using WebMatrix.Data;
@{
var db = Database.Open("member");
var selectQueryString = "SELECT * FROM memberTable ORDER BY LastName";
}
<html>
<body>
<h1>
Paleo Scriptology Club Members</h1>
<table border="1" style="width: 100%;">
<tr>
<th>Id</th>
<th>LastName</th>
<th>FirstName</th>
<th>PhoneNumber</th>
</tr>
@foreach (var row in db.Query(selectQueryString))
{
<tr>
<td>@row.StudentId</td>
<td>@row.LastName</td>
<td>@row.FirstName</td>
<td>@row.PhoneNumber</td>
</tr>
}
</table>
</body>
</html>
WebPagesRazor W3Schools
In MS VisualStudio 19
1) Create a new web site pick ASP.NET Empty Web Site
2) Add ASP.NET folder App_Data
3) Find the member.accdb in the unit on blackboard download it and and add it to App_data
4) Add a NewItem Web Page (Razor v3)
5) Add the connection string in the Web.config file.
<connectionStrings>
<add connectionString="Provider=Microsoft.ACE.OleDb.12.0;Data Source=|DataDirectory|member.accdb;" name="member" providerName="System.Data.OleDb">
</add></connectionStrings>
6) Go into: Tools > NuGet Package Manager > Package Manager Console
And run the following command:
PM> Install-Package Microsoft.AspNet.WebPages.Data
then open the command prompt.
cd \Program Files (x86)\IIS Express
Then type the following command:
appcmd set config /section:system.webServer/directoryBrowse /enabled:true
@using WebMatrix.Data;
@{
var db = Database.Open("member");
var selectQueryString = "SELECT * FROM memberTable ORDER BY LastName";
}
<html>
<body>
<h1>
Paleo Scriptology Club Members</h1>
<table border="1" style="width: 100%;">
<tr>
<th>Id</th>
<th>LastName</th>
<th>FirstName</th>
<th>PhoneNumber</th>
</tr>
@foreach (var row in db.Query(selectQueryString))
{
<tr>
<td>@row.StudentId</td>
<td>@row.LastName</td>
<td>@row.FirstName</td>
<td>@row.PhoneNumber</td>
</tr>
}
</table>
</body>
Paleo Scriptology Club Members
| Id | LastName | FirstName | PhoneNumber |
|---|---|---|---|
| @row.StudentId | @row.LastName | @row.FirstName | @row.PhoneNumber |
</html>
Tuesday, October 16, 2018
Schedule change
Due to the school cancellation last week the mid term was (10/16/2018) at 3.
Thursday will be a lab.
I will cover chapter 15 next Tuesday.
The syllabus has been updated.
Thursday will be a lab.
I will cover chapter 15 next Tuesday.
The syllabus has been updated.
Monday, June 11, 2018
Tuesday, February 27, 2018
CIST2342 Mid Term Review Spring 2018
Know about list box and combo box and the differences. (pg. 601/612)
Delegates signature (pg. 594)
Overriding a method (question about what cannot be in a base method) (pg. 707)
Property on a control to see if it is properly selected
Components in c# are implemented in ___________.
Good design principle for developing window applications. (pg. 512)
Two properties that can be used to retrieve items from a list box (selected items and text)
Writing a catch clause without an argument list
May not have an exception thrown (related to an operation and data type)
Try, catch, finally (pg. 804)
Keyword that tells the compiler to determine the type based on what is on the right of the initialization statement.
Retrieving multiple selections from a list box.
Calling base default constructor. (pg. 711)
Add dynamic link library. (pg 715)
Markers that tells the program to halt at that spot. (breakpoint) (pg. 788)
Exception class and its properties.
__________ objects have an added feature over a list box. (pg. 612)
Delegates signature (pg. 594)
Overriding a method (question about what cannot be in a base method) (pg. 707)
Property on a control to see if it is properly selected
Components in c# are implemented in ___________.
Good design principle for developing window applications. (pg. 512)
Two properties that can be used to retrieve items from a list box (selected items and text)
Writing a catch clause without an argument list
May not have an exception thrown (related to an operation and data type)
Try, catch, finally (pg. 804)
Keyword that tells the compiler to determine the type based on what is on the right of the initialization statement.
Retrieving multiple selections from a list box.
Calling base default constructor. (pg. 711)
Add dynamic link library. (pg 715)
Markers that tells the program to halt at that spot. (breakpoint) (pg. 788)
Exception class and its properties.
__________ objects have an added feature over a list box. (pg. 612)
Wednesday, January 17, 2018
Tuesday, January 16, 2018
HACKATHON IN AUGUSTA
HACKATHON IN AUGUSTA
On Friday, February 23rd, Rural Sourcing is joining forces with the United Way to code for a cause.
The United Way of the CSRA unites people and mobilizes community resources to create lasting changes that transform lives.
We need your help-- join us for an afternoon of volunteer coding that will greatly impact children in the CSRA!
What is a hack·a·thon you ask?
/ˈHAKəˌthän / noun: a Hackathon (also known as a hack-day, hackfest or codefest) is an event in which computer programmers and others in the field of software development,
like graphic designers, interface designers and project managers collaborate intensively on a software related project for a set amount of time
As always, there will be food, swag, and PRIZES! As a 2018 RSI hacker, you and your team will be given all the info needed to complete the coding project.
When the last bit of code is compiled and presented, winning teams will be selected.
To get started, grab your laptop and register. You can register as an individual or as part of a team (4 max! per team).
If you don’t have a team, no worries! We’ll pair you with other coders. If you are not able to participate,
we still welcome you to stop by, grab a bite and connect with our team and other coders from our community.
WHO: Students, Professionals, and Individuals with an interest in the field of SOFTWARE DEVELOPMENT
WHERE: Enterprise Mill, Starch Room
1450 Greene Street, Augusta, GA 30901
WHEN: Friday, February 23, 2018
TIME: Registration starts at 1:00 PM; Projects kick off at 2:00 PM; Hacking ends at 5:00 PM
Registration will close on February 9, 2018 at 6:00 EST. Click the below Link to Register now! HACKATHON
Subscribe to:
Posts (Atom)