Snake Ladder Game in windows Form C# (PART-1)

Load event:

pictureBox3.Image
= Image.FromFile(@"C:\Users\salman\Documents\Visual Studio
2013\Projects\WindowsFormsApplication3\WindowsFormsApplication3\Resources\roll.png");

           pictureBox3.SizeMode = PictureBoxSizeMode.StretchImage;

roll dice button:

label2.Text = logics.rolldice(pictureBox3).ToString();

class:

using System;

using System.Collections.Generic;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace WindowsFormsApplication3

{

    class logics

    {

        public static int rolldice(PictureBox px)

        {

            int dice = 0;

            Random r = new Random();

            dice = r.Next(1, 7);

            px.Image = Image.FromFile(@"C:\Users\salman\Documents\Visual Studio
2013\Projects\WindowsFormsApplication3\WindowsFormsApplication3\Resources\" + dice + ".png");

            px.SizeMode = PictureBoxSizeMode.StretchImage;

            return dice;

       

       

        } //roll dice
method end................

    }

}

Learn Sql server in hindi/urdu part-10 (Like and WildCards in sql Server)

select  *from employee



  insert into employee values('Abid',15000,1)





  select * from employee where emp_name like 'A%'



  select * from employee where emp_name like '%a'



  select * from employee where emp_name like '%a%n'



  select * from employee where emp_name like '__n%'



  select * from employee where emp_name like  's_%'



  select * from employee where emp_name like  's%a'

Learn Sql server in hindi/urdu part-9 (Sum ,Top and Subquery on differen...

 select * from employee

  select * from department





  --display top 3 records from employee table.

  select top 2 * from employee  where emp_id < (select max(emp_id) from employee)  order by emp_salary desc





  select * from employee order by emp_salary asc





  --dispaly sum of salary of those employees who are working in Marketing department



  select sum(emp_salary) from employee e inner join department d on d.dept_id=e.dem_deptid

  where d.dept_name='Marketing'







  --display top 5 records of employees  who are working in Hr and Marketing

  select top 5 * from employee e inner join department d on d.dept_id=e.dem_deptid

  where d.dept_name='Marketing' or d.dept_name='Hr'

Learn Sql server in hindi/urdu part-8 Aggregate function with inner joi...

use sql1707b1





select * from sys.tables



select * from employee

select * from department





--display maximum salary from employee table

select max(emp_salary)from employee





--display minimum salary from employee table

select min(emp_salary) from employee





--display avg salary from employee table



select avg(emp_salary) from employee





--display no.of employees record from employee table

select count(emp_id) from employee







--display, how many employees are working in Hr Department with salary >10000



 select count(e.emp_id) from employee e inner join

  department d on d.dept_id=e.dem_deptid where e.emp_salary>10000 and d.dept_name='HR'



;

Learn Sql server in hindi/urdu part-7 (Left & right Join in Sql Server)

create table department

(

dept_id int identity primary key,

dept_name nvarchar(20) not null,

)



select * from department





insert into department

values('Hr')



insert into department

values('Admin')



insert into department

values('Marketing')



insert into department

values('Faculty')



insert into department

values('Managers')







create table employee

(

emp_id int identity primary key,

emp_name nvarchar(20) not null,

emp_salary int,

dem_deptid int foreign key references department(dept_id)



)





insert into employee

values('Ali',40000,3)



insert into employee

values('Ali',30000,1)



insert into employee

values('sami',50000,2)



insert into employee

values('sana',20000,2)



insert into employee

values('kamran',70000,4)



insert into employee

values('sumaira',10000,1)





insert into employee

values('moosa',10000,10)





select * from employee

select * from department





select e.emp_id,e.emp_name,e.emp_salary,d.dept_name,d.dept_id,e.dem_deptid from

employee e inner join department d on d.dept_id=e.dem_deptid







select * from department d inner join employee e on d.dept_id=e.dem_deptid



select * from department d left join employee e on d.dept_id=e.dem_deptid





select * from employee e right join department d on d.dept_id=e.dem_deptid

Learn Sql server in hindi/urdu part-6 (Inner Join in Sql Server)

create table department

(

dept_id int identity primary key,

dept_name nvarchar(20) not null,

)



select * from department





insert into department

values('Hr')



insert into department

values('Admin')



insert into department

values('Marketing')



insert into department

values('Faculty')



insert into department

values('Managers')







create table employee

(

emp_id int identity primary key,

emp_name nvarchar(20) not null,

emp_salary int,

dem_deptid int foreign key references department(dept_id)



)





insert into employee

values('Ali',40000,3)



insert into employee

values('Ali',30000,1)



insert into employee

values('sami',50000,2)



insert into employee

values('sana',20000,2)



insert into employee

values('kamran',70000,4)



insert into employee

values('sumaira',10000,1)





insert into employee

values('moosa',10000,10)





select * from employee

select * from department





select e.emp_id,e.emp_name,e.emp_salary,d.dept_name,d.dept_id,e.dem_deptid from

employee e inner join department d on d.dept_id=e.dem_deptid







select * from department d inner join employee e on d.dept_id=e.dem_deptid

5- Variables in JavaScript (Diffrence b/w strongly type and loosely type...

—<!DOCTYPE
html>

—<html>

—<body>

—  <h1>Demo: JavaScript Variables
</h1>

— 

—  <p id="p1"></p>

—

—  <script>

—  var
one =1;  // number value

—

—  one= 1.1; // 
decimal value

— 

—  one = true; // Boolean value

— 

—  one = null; // null value

— 

—  one = 'one'; // string value

—

—

—  document.getElementById("p1").innerHTML
= one;

—    </script>

—</body>

—</html>