Friday 29 June 2012

.Net Helpful Site

http://www.dotnetfunda.com/tutorials/controls/

http://www.w3schools.com/aspnet/

http://www.startvbdotnet.com/aspsite/controls/default.aspx

http://www.dotnet-guide.com/

ASP.net links

www.dotnetfunda.com/tutorials/controls/  

================================================================
www.w3schools.com/aspnet/

 ===============================================================


http://www.startvbdotnet.com/aspsite/controls/default.aspx

=================================================================

http://www.dotnet-guide.com/

=================================================================

 http://www.tutorialspoint.com/asp.net/index.htm

=================================================================

http://www.dotnetspider.com/tutorials/AspNet-Tutorials.aspx

=================================================================

http://www.java2s.com/Tutorial/ASP.NET/0060__ASP.net-Controls/Catalog0060__ASP.net-Controls.htm

=================================================================

http://devexpress.com/Products/NET/Controls/ASP/?gclid=CJ3agMKU87ACFYka6wod2CH7LQ#main|controls

================================================================

http://www.asp.net/web-forms/tutorials/master-pages

===================================================================

http://asp.net-tutorials.com/

===================================================================

http://www.aspnettutorials.com/tutorials/controls/

===================================================================

http://net.tutsplus.com/tutorials/create-asp-net-server-controls-from-scratch/

====================================================================

http://aspalliance.com/articles/LearnASPNET.aspx

=====================================================================

http://www.codeguru.com/csharp/.net/net_asp/controls/

=====================================================================

http://www.telerik.com/support/documentation-and-tutorials/step-by-step-tutorial-for-winforms.aspx

======================================================================

All Subject material

http://www.eazynotes.com/

Tuesday 12 June 2012

Assignment - 1 TYBCA 2012


  Assignment -1
   Submission Date: 20-Jun-2012
1 To Implement Add,subtraction,Multiplication and Division with two Label,textbox, DropDownList and Button  Control
2 To implement Table of given number and table is display in HTML Table
3 To Implement Simple interest and Compound Interest
4 To Display 1 to n number in Textbox
5 To Display Largest value from given three Textbox value
6 To Implement Fullname from given three textbox one is First Name,Middlename and Surname
7 To Insert EID,Ename,Salary and Joing Date in form and data store in Array with Enity Class and Data should be display in message box 
8 To Insert productid,prodname,qty,unitprice and total price in form and insert in Entity class and Display in HTML Table
9 To Insert productid,prodname,qty,unitprice and total price in form and insert in Entity class and Display in DridView control
10 To implement simple website through Master page concept 

Wednesday 6 June 2012

ASP.NET Page Life Cycle



ASP.NET ASSIGNMENT


ASP.NET PROJECT

Submission Date: 26th August,12

CRITERIA:
Create one group and group member is only 2.
Each group finds internal project submission topic yourself.
Refer all Concern ASP.NET book

Exercise 1:
Include below concept of asp.net
  1. Use Master Page
  2. Create Menu
2.1  Menu items Home, service, gallery, contact us, about us
2.2  Menu is either in horizontal or in vertical
  1. Create Register Page of concern project topic
  2. Use Proper Web server control
  3. In Register Page, Use all Validation control of asp.net
  4. Create Entity class
  5. Create database class to store Entity class object and retrieve
  6. Create DataBinding to Display information GridView or DataList control using custom template

Exercise 2:

  1. Create One Page that page having one ListBox and one DropDownList when you select listBox item then item should display on same page and associated data will display in DropDownList using ViewState Demo
  2. Create Login Page using CrossPage Demo with suitable example
  3. Create Query String Demo
  4. Create Cookie Demo
  5. Create Session state Demo
  6. Create Application Demo
  
Exercise 3:

  1. Use point of exercise 1 in exercise 3
  2. Create Add, Update or Delete of database table using ADO.NET
  3. Data should display in GridView or DataList control 
  4. Create one page for image upload in Image folder
  5. Use ViewState and Session State

Assignment - 1


Submission Date: 9th June,2012

create following tables and insert given records


DATABASE TABLES:
=========================================================================
Campus (CampusID, CampusName, Street, City, State, Zip, Phone, CampusDiscount)

Position (PositionID, Position, YearlyMembershipFee)

Members (MemberID, LastName, FirstName, CampusAddress, CampusPhone, CampusID, PositionID, ContractDuration)
    
Prices (FoodItemTypeID, MealType, MealPrice)

FoodItems (FoodItemID, FoodItemName, FoodItemTypeID)
   

Orders (OrderID, MemberID, OrderDate)
    
OrderLine (OrderID, FoodItemsID, Quantity)
    
==========================================================================

DATA TO BE INSERTED:
==========================================================================
Campus:
'1','IUPUI','425 University Blvd.','Indianapolis', 'IN','46202', '317-274-4591',.08
'2','Indiana University','107 S. Indiana Ave.','Bloomington', 'IN','47405', '812-855-4848',.07
'3','Purdue University','475 Stadium Mall Drive','West Lafayette', 'IN','47907', '765-494-1776',.06

Position:
'1','Lecturer', 1050.50
'2','Associate Professor', 900.50
'3','Assistant Professor', 875.50
'4','Professor', 700.75
'5','Full Professor', 500.50

Members:
'1','Ellen','Monk','009 Purnell', '812-123-1234', '2', '5', 12
'2','Joe','Brady','008 Statford Hall', '765-234-2345', '3', '2', 10
'3','Dave','Davidson','007 Purnell', '812-345-3456', '2', '3', 10
'4','Sebastian','Cole','210 Rutherford Hall', '765-234-2345', '3', '5', 10
'5','Michael','Doo','66C Peobody', '812-548-8956', '2', '1', 10
'6','Jerome','Clark','SL 220', '317-274-9766', '1', '1', 12
'7','Bob','House','ET 329', '317-278-9098', '1', '4', 10
'8','Bridget','Stanley','SI 234', '317-274-5678', '1', '1', 12
'9','Bradley','Wilson','334 Statford Hall', '765-258-2567', '3', '2', 10
Prices:  Note - Remember that these Primary Key Values should be entered using the Sequence (autonumber)
'1','Beer/Wine', 5.50
'2','Dessert', 2.75
'3','Dinner', 15.50
'4','Soft Drink', 2.50
'5','Lunch', 7.25
FoodItems:
'10001','Lager', '1'
'10002','Red Wine', '1'
'10003','White Wine', '1'
'10004','Coke', '4'
'10005','Coffee', '4'
'10006','Chicken a la King', '3'
'10007','Rib Steak', '3'
'10008','Fish and Chips', '3'
'10009','Veggie Delight', '3'
'10010','Chocolate Mousse', '2'
'10011','Carrot Cake', '2'
'10012','Fruit Cup', '2'
'10013','Fish and Chips', '5'
'10014','Angus Beef Burger', '5'
'10015','Cobb Salad', '5'

Orders:
'1', '9', 'March 5, 2005'
'2', '8', 'March 5, 2005'
'3', '7', 'March 5, 2005'
'4', '6', 'March 7, 2005'
'5', '5', 'March 7, 2005'
'6', '4', 'March 10, 2005'
'7', '3', 'March 11, 2005'
'8', '2', 'March 12, 2005'
'9', '1', 'March 13, 2005'

OrderLine:
'1','10001',1
'1','10006',1
'1','10012',1
'2','10004',2
'2','10013',1
'2','10014',1
'3','10005',1
'3','10011',1
'4','10005',2
'4','10004',2
'4','10006',1
'4','10007',1
'4','10010',2
'5','10003',1
'6','10002',2
'7','10005',2
'8','10005',1
'8','10011',1
'9','10001',1

SQL Book Demo

http://www.ivanbayross.com/mybooks/70-oraclebooks.html#hiddendiv8