KEMBAR78
DOTNET | PDF | C Sharp (Programming Language) | Microsoft Sql Server
0% found this document useful (0 votes)
17 views33 pages

DOTNET

This document is an internship report for a DotNet Developer Internship Program at Little Flower Polytechnic College, detailing the curriculum and training received during the internship. It covers various topics such as .NET framework, C# programming, decision-making statements, loops, collections, and HTML basics. The report serves as a partial fulfillment for the Diploma in Computer Engineering for the academic year 2024-2025.

Uploaded by

yjas22799
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
17 views33 pages

DOTNET

This document is an internship report for a DotNet Developer Internship Program at Little Flower Polytechnic College, detailing the curriculum and training received during the internship. It covers various topics such as .NET framework, C# programming, decision-making statements, loops, collections, and HTML basics. The report serves as a partial fulfillment for the Diploma in Computer Engineering for the academic year 2024-2025.

Uploaded by

yjas22799
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 33

LITTLE FLOWER POLYTECHNIC COLLEGE

MOULIVAKKAM, CHENNAI-600125

INTERNSHIP REPORT ON
DOTNET DEVELOPER INTERNSHIP PROGRAM
IN PARTIAL FULFILLMENTS ON REQUIREMENT FOR THE AWARD OF

DIPLOMA IN COMPUTER ENGINEERING

TRAINING CENTRE

2024-2025
LITTLE FLOWER POLYTECHNIC COLLEGE
LAWRENCE NAGAR, MOULIVAKKAM, CHENNAI-600125.

BONAFIDE CERTIFICATE
This is to certify that the internship titled DOTNET DEVELOPER
INTERNSHIP PROGRAM submitted in partial fulfillment for the award of
“DIPLOMA IN COMPUTER ENGINEERING by Directorate of Technical
Education is a bonafide record of Internship carried out.
NAME:

REGNO:

During the Academic Year 2024-2025

HEAD OF THE DEPARTMENT

Submitted for practical and viva – voce Examination of “FINAL’’ Semester


DIPLOMA IN COMPUTER ENGINEERING held on ………………

INTERNAL EXAMINER EXTERNAL EXAMINER


DATE: 14.5.2024

DAY 1: Introduction to .Net

What is .NET?

.NET is a free, open-source, cross-platform framework developed by


Microsoft for building a variety of applications, including web, desktop, mobile,
cloud, gaming and IoT applications. It supports multiple programming
languages such as C#, F#, and VB.NET.

Key Features of .NET


1. Cross-Platform – Runs on Windows, Linux, and macOS.
2. Multiple Languages – Supports C#, F#, and VB.NET.
3. Unified Platform – A single framework for web, desktop, cloud,
mobile, and more.
4. Performance – Highly optimized for speed and scalability.
5. Security – Provides built-in security mechanisms.
6. Large Ecosystem – Supported by a vast community and Microsoft.
7. Integration with Modern Technologies – Works well with cloud
computing, AI, and micro services.
.NET Versions and Components

1. .NET Framework – The original Windows-only framework.

2. .NET Core – A cross-platform, open-source framework.

3. .NET 5+ – A unified platform combining .NET Core and .NET


Framework.
4. ASP.NET Core – For building web applications and APIs.

5. Xamarin/MAUI – For mobile app development (iOS, Android).

6. Entity Framework Core – ORM (Object-Relational Mapper) for


database operations.
Common Use Cases of .NET
 Web applications (ASP.NET Core)
 Desktop applications (Windows Forms, WPF)
 Mobile applications (Xamarin, .NET MAUI)
 Cloud-based applications (Azure)
 Gaming (Unity)
 IoT applications

INTRODUCTION TO C#

C# (pronounced "C-Sharp") is a simple, modern, general-purpose, object-


oriented programming language developed by Microsoft within its .NET
initiative led by Anders Hejlsberg. It is widely used for the following:

 Web Development (ASP.NET)


 Desktop Applications (Windows Forms, WPF)
 Game Development (Unity)
 Cloud & AI Applications

Write, Compile, & Run C# Code Instantly

Our C# tutorial allows you to execute code inline without leaving the page
unlike other sites. Learn C# hands-on with real-time coding experience right
here!

 Main features of this tutorial:


 Best for Beginners & Experienced Developers
 Covers Basic to Advanced Topics
 Interactive Compilation - No Setup Needed!
DATE: 15.5.2024

DAY 2: C# - Basic Syntax

C# is an object-oriented programming language. In Object-Oriented Programming


methodology, a program consists of various objects that interact with each other
by means of actions. The actions that an object may take are called methods.
Objects of the same kind are said to have the same type or, are said to be in
the same class.

Basic Structure of a C# Program

Every C# program has a basic structure. Here a simple example:

Example

For example, let us consider a Rectangle object. It has attributes such as length and
width. Depending upon the design, it may need ways for accepting the values of
these attributes, calculating the area, and displaying details.Let us look at
implementation of a Rectangle class and discuss C# basic
syntax

– Sample

Code

using

System

namespace RectangleApplication

class Rectangle
{

// member variables

double length;

double width;

public void Acceptdetails()

length = 4.5; width = 3.5;

public double GetArea()

{return length * width;} public

void Display ()

{ Console.WriteLine("Length: {0}", length); Console.WriteLine("Width:

{0}", width);

Console.WriteLine("Area: {0}", GetArea());

}}

class ExecuteRectangle { static

void Main(string[] args)

{ Rectangle r = new Rectangle(); r.Acceptdetails();

r.Display(); Console.ReadLine();

}}}
Sample Output

Length: 4.5
Width: 3.5
Area: 15.75
DATE: 16.5.2024

DAY 3 - C# - Operators

An operator is a symbol that tells the compiler to perform specific mathematical


or logical manipulations. C# has rich set of built-in operators and provides the
following type of operators –

 Arithmetic Operators
 Relational Operators
 Logical Operators
 Bitwise Operators
 Assignment Operators
 Misc Operators
Arithmetic Operators

C# arithmetic operators perform mathematical operations such as addition,


subtraction, multiplication, division, and modulus between numeric data types.
These operators are binary operators, which need two operands to perform the
operation.

Relational Operators

C# relational operators compare two operands and return either true or false.
These operators are useful for decision-making. Following table shows all the
relational operators supported by C#. Assume variable A holds 10 and variable
B holds 20.
Logical Operators
C# logical operators combine Boolean expressions. These operators are useful
when you have multiple conditions and want to combine and check them. The
result of these operators is either true or false; i.e., these operators return only
Boolean values. Following table shows all the logical operators supported by
C#.
DATE: 17.5.2025

DAY 4: C# - Decision-making Statements

Decision making structures requires the programmer to specify one or more


conditions to be evaluated or tested by the program, along with a statement or
statements to be executed if the condition is determined to be true, and
optionally, other statements to be executed if the condition is determined to be
false. Following is the general form of a typical decision making structure
found in most of the programming languages.

Sample code

using System;

namespace DecisionMaking

class Program {

static void Main(string[] args)

{ // Define a local variable

int temperature = 30; // Check the condition using an if statement if

(temperature > 25){

Console.WriteLine("It's a hot day."); }


Console.WriteLine($"Current temperature: {temperature} degree C");
}

}
DATE: 18.5.2024

DAY 5 - C# - Loops

There may be a situation, when you need to execute a block of code several
number of times. In general, the statements are executed sequentially: The first
statement in a function is executed first, followed by the second, and so on.
Programming languages provide various control structures that allow for more
complicated execution paths.

Sample Code

using

System;

class

Example

{ static void Main(string[] args)

int[] number = { 1, 2, 3, 5, 6 };

for (int i = 0; i < number.Length; i++) {

Console.WriteLine(number[i]);

}}}
DATE: 20.5.2024

DAY 6 - C# - Loops

The while loop repeats a statement or a group of statements while a given condition
is true. It tests the condition before executing the loop body.

The below is an example of a while loop in C#:

using System;

namespace Loop Example

class Program

static void Main(string[] args)

while (i <= 5)

Console.WriteLine("Number: " + i); i+

+;} } } }

Sample code:

Number: 1
Number: 2
Number: 3
Number: 4
Number: 5
The for Loop

The for loop executes a sequence of statements multiple times and


abbreviates the code that manages the loop variable.

The below is an example of a for loop in C#: using

System;

namespace LoopExample

class Program

{ static void Main(string[] args)

// Using a for loop to print numbers from 1 to 5

for (int i = 1; i <= 5; i++)

Console.WriteLine("Number: " + i);

}}}}

Sample Code :

Number: 1
Number: 2
Number: 3
Number: 4
Number: 5
The do while Loop

The do...while loop is similar to a while statement, except that it tests the condition
at the end of the loop body.

The below is an example of a do-while loop in C#:

using System;

namespace Loop Example

{ class Program

static void Main(string[] args)

do

Console.WriteLine("Number: " + i); i+

+; }

while (i <= 5);

}}}

Sample code:

Number: 1
Number: 2
Number: 3
Number: 4
Number: 5
DATE: 21.5.2024

DAY 7: Collections in C#

Collections standardize the way of which the objects are handled by your
program. In other words, it contains a set of classes to contain elements in a
generalized manner. With the help of collections, the user can perform several
operations on objects like the store, update, delete, retrieve, search, sort etc.
Generic collection in C# is defined in System.Collection.Generic namespace. It
provides a generic implementation of standard data structure like linked lists,
stacks, queues, and dictionaries.
These collections are type-safe because they are generic means only those items
that are type-compatible with the type of the collection can be stored in a
generic collection, it eliminates accidental type mismatches. Generic collections
are defined by the set of interfaces and classes.

System.Collections.Generic namespace:

using System;
using System.Collections.Generic; class
Geeks
{
// Main Method
public static void Main(String[] args)
{
// Creating a List of integers List<int>
mylist = new List<int>();
// adding items in mylist
for (int j = 5; j < 10; j++) {
mylist.Add(j * 3);
}
// Displaying items of mylist
// by using foreach loop
foreach(int items in mylist)
{
Console.WriteLine(items);
}
}
}

15

18

21

24

27

System. Collections Classes


Non-Generic collection in C# is defined in System. Collections
namespace. It is a general-purpose data structure that works on object
references, so it can handle any type of object, but not in a safe-type manner.
Non-generic collections are defined by the set of interfaces and classes.
// C# to illustrate the concept

// of non-generic collection using Queue

using System;

using System.Collections;

class GFG {

// Driver code

public static void Main()

{
// Creating a Queue

Queue myQueue = new Queue();

// Inserting the elements into the Queue

myQueue.Enqueue("C#");

myQueue.Enqueue("PHP");

myQueue.Enqueue("Perl");

myQueue.Enqueue("Java");

myQueue.Enqueue("C");

Console.Write("Total number of elements present in the Queue are”)

}
DATE: 22.5.2024

DAY 8: Collections in C#

Collections standardize the way of which the objects are handled by your
program. In other words, it contains a set of classes to contain elements in a
generalized manner. With the help of collections, the user can perform several
operations on objects like the store, update, delete, retrieve, search, sort etc.

System.Collections.Generic namespace:

// adding items in mylist

for (int j = 5; j < 10; j++)


{ mylist.Add(j * 3);
}
Total number of elements present in the Queue are: 5

Beginning Item is: C#


DATE: 24.5.2024

DAY 9: HTML Tutorial

HTML is a standard markup language, which stands for Hyper Text Markup
Language. It is widely used language to create webpages. HTML invented by
Tim Berners-Lee in late 1991, but it's first version "HTML 1.0" was released in
1993, and "HTML 2.0" was the first standard HTML specification, which was
published in 1995. This HTML tutorial covers everything from basic HTML
fundamental
What is HTML?

HTML (HyperText Markup Language) is a standard markup language to design


the structure of a webpage. HTML is the combination of HyperText and
Markup Language. HyperText defines the internal links between webpages, and
Markup language defines the layout and presentation of text and media.

Basic HTML Structure

The basic structure of an HTML document contains the few mandatory tags,
that must be used to create a webpage. This structure must be followed to create
any type of HTML document. Here is the basic structure of an HTML
document –

 HTML stands for HyperText Markup Language.


 HTML is used to create web pages and web applications.
 HTML is widely used language on the web.
 We can create a static website by HTML only.
HTML Example with HTML Editor
In this tutorial, you will get a lot of HTML examples, at least one example for
each topic with explanation. You can also edit and run these examples, with our
online HTML editor. Learning HTML is fun, and it's very easy to learn

<!DOCTYPE html>
<html>
<head>
<title>Web page title</title>
</head>
<body>
<h1>Write Your First Heading</h1>
<p>Write Your First Paragraph.</p>
</body>
</html>
DATE: 25.5.2024
DAY 10: HTML <!DOCTYPE> tag

On the HTML document you have often seen that there is a <!DOCTYPE html>
declaration before the <html> tag. HTML <!DOCTYPE> tag is used to inform
the browser about the version of HTML used in the document. It is called as the
document type declaration (DTD). Technically <!DOCTYPE> is not a
tag/element, it just an instruction to the browser about the document type. It is a
null element which does not contain the closing tag, and must not include any
content within it

<!DOCTYPE html>

<html>
<head>
<title>This is the title</title>
</head>
<body>
This is the content of the document.
</body>
</html>
DATE: 27.5.2024

DAY 11: ASP.NET – Introduction

ASP.NET is a web application framework developed and marketed by


Microsoft to allow programmers to build dynamic web sites. It allows you to
use a full featured programming language such as C# or VB.NET to build web
applications easily. This tutorial covers all the basic elements of ASP.NET
that a beginner would require to get started.

What is ASP.NET Web Pages?

ASP.NET Web Pages is a simplified framework that we can use to build


ASP.NET content quickly and easily. It is one of the three programming models
for creating ASP.NET web sites and web applications. The other two
programming models are Web Forms and MVC
DATE: 28.5.2024

DAY 12: How to Create an Input Form?

Lets have a look into a simple example by creating a new cshtml file with
MyForm.cshtml name and replace the code with the following program.

<!DOCTYPE html>

<html>

<head>

<title>Customer Form</title>

</head>

<body>

<form method = "post" action = "">

<fieldset>

<legend>Add Student</legend>

<div>

<label for = "StudentName">Student Name: </label>

<input type = "text" name = "StudentName" value = "" />

</div>

<div>

<label for = "UniName">University Name:</label>

<input type = "text" name = "UniName" value = "" /></div>

<div><label for = "Address">Res. Address:</label>

<input type = "text" name = "Address" value = "" /></div>


<div><label>

</label><input type = "submit" value = "Submit" class = "submit"


/></div></fieldset>

</form>

</body>

</html>
DATE: 29.5.2024

DAY 13: Reading User Input from the Form

To read the user input from the form we will add some code that will read the
values from all the fields and then process them as we want. This procedure
shows you how to read the fields and display the user input on the page.

<!DOCTYPE html>

<html>

<head>

<title>Customer Form</title>

</head>

<body>

@{ if (IsPost)

string StudentName = Request["StudentName"];

string UniName = Request["UniName"];

string Address = Request["Address"];

<p>You entered: <br />

Student Name: @StudentName <br />

University Name: @UniName <br />

Res. Address: @Address <br />

</p> }

else{
<form method = "post" action = "">

<fieldset>

<legend>Add Student</legend>

<div>

<label for = y"StudentName">Student Name: </label>

<input type = "text" name = "StudentName" value = "" />

</div><div>

<label for = "UniName">University Name:</label>

<input type = "text" name = "UniName" value = "" />

</div><div>

<label for = "Address">Res. Address:</label>

<input type = "text" name="Address" value = "" />

</div><div><label>

</label>

<input type = "submit" value = "Submit" class = "submit" />

</div>

</fieldset>

</form>

}}

</body>

</html>
DATE: 30.5.2024

DAY 14: ASP.NET– Database

What is SQL Server


The SQL Server is a relational database management system (RDBMS) which
is developed by Microsoft. It is also called MS SQL Server. This product is
built on the basic function of storing and retrieving data as required by other
applications. It can be run either on the same computer or on another across a
network.

Displaying Data from Database

With Web Pages, you can easily display data from a database. You can connect
to an existing database, or create a new database from scratch. In this example
we will connect to an existing SQL Server Compact database.

ASP.NET Database Object Reference


DATE: 31.5.2024

DAY 15: Building Web Application

I created a Visual Studio Solution with an ASP.Net website where you can
work with the HR database that has been created up to this point in this series.
You can download the solution in the Next Steps section of this article.

Step 1: Open up Visual Studio and Create an ASP.Net website

Open Visual Studio, select Create a new project, choose ASP.NET Web
Application (.Net Framework) template, and click Next.
Step 2: Connection String in web.config File

 Datasource

 HRDatabase

 HRDBLogin

 MyPassword - make sure the password is like the one created in the SQL script

Step 3: Add Three Web Pages


Create three webforms by right-clicking on the HRProject, Add, Webform
 Default
 Companies
 Employees
SAMPLE CODE:
using System.Configuration; using
System.Data;
using System.Data.SqlClient; using
System.Web.UI;
using System.Web.UI.WebControls;
namespaceHRWebsite

{
public partial class Companies : System.Web.UI.Page
{
int Comp_ID;
SqlConnectionmyCon=newSqlConnection(ConfigurationManager.
ConnectionStrings["HRDBConnection"].ConnectionString); protected
void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DoGridView();
}
}
private void DoGridView()
{
try
{
myCon.Open();
using(SqlCommandmyCom=new SqlCommand("dbo.usp_GetComp anies",
myCon))
{
myCom.Connection = myCon;
myCom.CommandType= CommandType.StoredProcedure;
SqlDataReader myDr = myCom.ExecuteReader();
gvCompanies.DataSource = myDr;
gvCompanies.DataBind();
myDr.Close();
}
}
catch (Exception ex)
{ lblMessage.Text = "Error in Companies doGridView: " + ex.Messa ge; }
finally { myCon.Close(); }
}
protected void lbNewComp_Click(object sender, EventArgs e)
{
try
{
txtCompanyName.Text = "";
txtCompAddress.Text = "";
txtCompContactNo.Text = "";
lblCompanyNew.Visible = true;
lblCompanyUpd.Visible = false;
btnAddCompany.Visible = true;
btnUpdCompany.Visible = false;

ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "


openCoDetail();", true);
}
catch (Exception) { throw; }
}
protected void btnAddCompany_Click(object sender, EventArgs e)
{
try
{
UpdCompany();
DoGridView();
}
protectedvoidgvCompanies_RowCommand(objectsender, GridView
CommandEventArgs e)
{
if (e.CommandName == "UpdCompan
{
txtCompAddress.Text = "";
txtCompContactNo.Text
lblCompanyNew.Visible = false;
lblCompanyUpd.Visible = true;

btnAddCompany.Visible = false:
btnUpdCompany.Visible = true;
GetCompany(Comp_ID);
}
}
protectedvoidgvCompanies_RowDeleting(Objectsender, GridViewD
eleteEventArgs e)
{
Comp_ID = Convert.ToInt32(gvCompanies.DataKeys[e.RowIndex].
Value.ToString());

try
{
myCon.Open();
using(SqlCommandcmd=new SqlCommand("dbo.usp_DelCompany ",
myCon))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = Comp_ID;
cmd.ExecuteScalar();
{

{
txtCompanyName.Text=myDr.GetValue(1).ToString(); txtCompAddress.Text
= myDr.GetValue(2).ToString(); txtCompContactNo.Text =
myDr.GetValue(3).ToString(); lblCompID.Text = Comp_ID.ToString();
}
}
}
}
catch (Exception ex)
{lblMessage.Text="ErrorinCompaniesGetCompany:"+ ex.Message;
}
finally { myCon.Close();
}
private void UpdCompany()
{
Try
{
myCon.Open();
}
Click on Companies or Employees to go to those pages.

You might also like