DOT NET ASSESSMENT EXAM
KEPT BY ONE OF
THE TOP Company in Vizag
1) Create a C# program to read
text from any file in PC and populate text into multi line text box.
Google Search Keywords
Read text file in c#
2) Create "Employees"
database & create "tblEmployees", "tblDepartments"
with Primary and Foreign Keys in SQL Server.
Database:
Employees
Tables:
tblEmployees Columns:
Id [INT][NOTNULL][IDENTITY(1,1)][PRIMARY KEY]
,FIRST NAME [NVARCHAR(50)][NOTNULL]
,MIDDLE
NAME [NVARCHAR(50)][NULL]
,LAST
NAME [NVARCHAR(50)][NOTNULL]
,GENDER [NVARCHAR(50)][NOTNULL]
,DATEOFBIRTH [DATETIME][NOTNULL]
,JOINING DATE [DATETIME][NOTNULL]
,SALARY [INT][NOTNULL]
,DEPTID [INT][NOTNULL][FOREIGN KEY]
,ISACTIVE
[BIT][NOTNULL]
tblDepartments Columns:
Id [INT][NOTNULL][IDENTITY(1,1)][PRIMARY KEY]
,DEPTNAME [NVARCHAR(50)][NOTNULL]
,ISACTIVE [BIT][NOTNULL]
Google search
keywords
Create
database using SQL Management Studio
Create
table using SQL Management Studio
3)Create Web Application using
visual studio and add gridview control in webform add columns into gridview
control(ex: Name - first name +middle name + last name,gender,date of
birth,joining date,salary,department) and bind data tables(tblemployees and tbldepartments)
using inner Join query.(Maintain connection string into application web.config
file)
Google
Search Keywords
Add gridview asp.net
Grid view binding in asp.net
4)Add new webform
in existing web application and add grid view control in webform. Add columns
into gridview control(ex: Name - first name +middle name + last
name,gender,date of birth,joining date,salary,department) and bind data
tables(tblemployees and tbldepartments) using inner Join query.(Maintain
connection string into application web.config file). ADD HTML table Control. In
HTML Control add textbox controls(Ex: First Name,Middle Name,Last Name and
Salary Controls). While clicking on
Name
|
Gender
|
Date of Birth
|
Joining Date
|
Salary
|
Department
|
|
Select
|
Rajesh Kumar V
|
Male
|
1/8/1974 12:00:00 AM
|
1/8/2003 12:00:00 AM
|
10000
|
Computers
|
Select
|
Avaneesh Varun
H
|
Male
|
2/9/1985
12:00:00 AM
|
2/9/2005
12:00:00 AM
|
15000
|
Mechanical
|
Select
|
Rani vishali B
|
Female
|
3/4/1987
12:00:00 AM
|
10/10/2003
12:00:00 AM
|
9000
|
Human
Resources
|
Employee
Record
First Name: | __________|
Middle Name: | __________|
Last Name: | __________|
Salary : | __________|
Select button in gridview populate those
record into textbox controls.
Google
Search Keywords:
Selected row