Posts

Komal Student Notes

  .net framework framework is a collection of tools and library which is used to applications development .net environment 1) programming environment 2) web environment 3) window environment 1) programming environment programming environment is represent console programming (c#) 2)web environment is represent using asp.net with c# 3) window environment :local application only software c# programming language :programming is a seris of valid step types of programming there are two types of programming language  1) code based programming language 2) form base    1) code based:-depend on code(c, c++, java etc)    2) form base :- based on tools(.net framework, android studio) programming environment user--->compiler(1.group 2.gives syntex error)---->interpriter(1.step by step 2.gives logical error) c# pure object oriented programming language 2) object oriented programming is based on class and object 3) structure of c#    header--->using ...

Joining Assignment , Insert into select , database backup

  create   table salesman ( salesman_id   int , name varchar ( 500 ), city varchar ( 500 ) , commission int   );     create   table customer ( customer_id   int , cust_name varchar ( 500 ) , city varchar ( 500 ), grade int , salesman_id   int );     create   table orders ( ord_no int , purch_amt   int , customer_id int , salesman_id int ) create   table orders ( ord_no int , purch_amt   int , customer_id int , salesman_id int , ord_date varchar ( 20 ))     insert into salesman values ( 101 , 'Ramesh' , 'Nagpur' , '12.23' ) insert into salesman values ( 102 , 'suresh' , 'pune' , '15.23' ) insert into salesman values ( 103 , 'mahesh' , 'delhi' , '16.23' ) insert into salesman values ( 104 , 'raj' , 'pune' , '16.23' ) insert into salesman values ( 105 , 'rahul' , 'mumbai' , '17.23' )     ...