Aptech Batch-CF201209B

This is a fake account with my name. Please report and block it.🙏

Precious moments of life saying alot in a little.....
Admins: , , # ,

Officially Single Log Hello Everyone! Welcome To Our page , Which is Officially for Them "Jinhain Kisi Ny Mun Ni Lagaya":'

The Dream School Of Education, Sukkur “Education is the key that unlocks the golden door to freedom.”We are trying our best to provide quality education.We have a chain of Schools under the supervision of experienced ProfessorGhulam Hussain Manganhar.
Admission Are offered
From PG To Matric

create database SoftZoom

use SoftZoom

create table Courses
(
CourseId int identity(1,1) primary key,
Name varchar(30) not null,
crateDate datetime,
remarks varchar(100) null,
[status] bit
)

sp_rename 'Courses.crateDate', 'CreateDate'

select * from Courses

alter table Courses
drop column status

alter table Courses
add Status bit

select * from Courses

insert Courses(Name,createDate,remarks,status)
values('Short Course',GETDATE(),'no',1)

create table Subjects
(
CourseId int,
SubjectId int identity(1,1) primary key,
Name varchar(30) not null,
createDate datetime,
remarks varchar(100),
status bit
)
select * from Courses
select * from Subjects

insert into Subjects(CourseId,Name,createDate,remarks,status)
values(3,'Network',GETDATE(),'no',1)

delete from Subjects where SubjectId = 12

select * from Subjects

update Subjects set Name = 'C++' where SubjectId=3

--JOINs----

---- there are 4 types of joins----

1. Self Join
2. inner join

3. outer join
i. left outer join
ii. right outer join
iii. full join
4. cross join

create table Emp
(
EmployeeId int identity(1,1) primary key,
Name varchar(30) not null,
ManagerId int
)

insert into Emp(Name,ManagerId)
values('Awais',3)

select * from Emp e

select e1.Name as 'Manager', e2.Name as 'Employee' from Emp e1
inner join Emp e2
on e1.EmployeeId = e2.ManagerId

select * from Courses
select * from Subjects

select c.Name as 'Course Name', s.Name as 'Subject' from Courses c
inner join Subjects s
on
c.CourseId = s.CourseId

Assalam o alikum to everyone,
we are arranging the party on Monday at aptech computer education sukkur so join us and enjoy the party thanks to all by: Maqsood Ali :)

Classes And Mathods C #

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;

namespace ClassesMethodDemo
{


public class Human
{
public Human()
{
Console.WriteLine("Human Constructor");
}

public static void Eat()
{
Console.WriteLine("Human Eat ");
}
public void Sleep()
{
Console.WriteLine("Human Sleep ");
}
}

class EmployeeInfo
{

SqlConnection con;
SqlCommand cmd;

public static string name;
public static string addr;
public static int age;

public EmployeeInfo()
{
con = new SqlConnection("Data Source=MAQSOOD; User Id=sa; Password=123; Database=Test");
}

public void RecordStoreInDB()
{
cmd = new SqlCommand("Insert into EmployeeInfo(name,address,age) values('"+name+"','"+addr+"',"+age+")", con);
cmd.Connection.Open();

if (cmd.ExecuteNonQuery() > 0)
{
Console.WriteLine("Record Inserted int DB");
}

}

public static void SetName(string n)
{
name = n;
}
public static string GetName()
{
return name;
}

public static void SetAddress(string a)
{
addr = a;
}
public static string GetAddress()
{
return addr;
}

public static void SetAge(int a)
{
age = a;
}
public static int GetAge()
{
return age;
}



}
class Registration
{
public int n;

public Registration()
{
Title("REGISTRATION MANAGEMENT SYSTEM");
ListMenu();

}

public void ListMenu()
{
Console.WriteLine("\n\n\t1. Registration");
Console.WriteLine("\t2. Show Records");
Console.WriteLine("\t3. Delete Record");
Console.WriteLine("\t4. Update Records");

}
public void Title(string t)
{
Console.WriteLine("\t\t"+t);

}

}

class Program
{
static void Main(string[] args)
{


Registration r = new Registration();

Console.Write("\n\t Select Item as above List: ");
r.n = Convert.ToInt32( Console.ReadLine() );

if (r.n == 1)
{
Console.Clear();
r.Title("EMPLOYEE INFORMATION");

Console.Write("\n\nName:\t");
EmployeeInfo.SetName(Console.ReadLine());

Console.Write("\nAddress:\t");
EmployeeInfo.SetAddress(Console.ReadLine());

Console.Write("\nAge:\t");
EmployeeInfo.SetAge(Convert.ToInt32( Console.ReadLine() ));

EmployeeInfo ei = new EmployeeInfo();
ei.RecordStoreInDB();

/*
Console.WriteLine(EmployeeInfo.GetName());
Console.WriteLine(EmployeeInfo.GetAddress());
Console.WriteLine(EmployeeInfo.GetAge());
*/
}

/*
Human h = new Human();
h.Sleep();
Human.Eat();
*/



/*
string[] ar = new string[5];

ar[0] = "Ali";
ar[1] = "Adil";
ar[2] = "Ahmed";
ar[3] = "Hussain";
ar[4] = "khalid";

foreach (string s in ar)
{
Console.WriteLine(s);
}
*/

Console.ReadKey();

}
}
}

here is an IO program
try it

import java.io.*;
import java.util.*;

public class InputStreamDemo
{

static void getFile(String path)
{
File f = new File(path);
File[] files = f.listFiles();
int a =0;

while(a

download the demo from chat

This program shows how to get input in java
try this

import java.util.Scanner;
class Input
{
public static void main(String [] arg)
{
String name;

Scanner ob=new Scanner(System.in);
System.out.println("Enter your name");
name=ob.nextLine();
System.out.println("my name is "+name);

System.out.println("Enter any Number");
int no=ob.nextInt();

System.out.println("Your number is "+no);

}

}

Why Java Program uses Thread?

Every Java program has at least one thread the main thread. When a Java program starts, the JVM creates the main thread and calls the program's main() method within that thread.

The JVM also creates other threads that are mostly invisible to you -- for example, threads associated with garbage collection, object finalization, and other JVM housekeeping tasks