+91-90427 10472
         
Dot net training in Chennai

Real Time Dot Net Training Centers in Chennai

There is a wide market for freshers in software companies, especially in dot net field. Many real time dot net training centers are available in Chennai. Experts in dot net training centers train students in Microsoft technologies to excel in IT sector. Trainers in dot net training centers have more than four years of experience in IT sector. The real time dot net training centers provide three types of services which include dot net training, share point training and web development.  Training on dot net is given to students for job assistance purpose and training is given till the students are familiar with the technology. The training centers give a complete guidance on software development life cycle. Regular workshops on dot net technology have been conducted for students and students have their own choice of choosing timing.

Trainers in dot net training centers provide assistance for Microsoft certification such as Microsoft certified technology specialist for dot net and SQL server. Both online and offline training classes are available for dot net.  Online sessions are conducted via Skype, students can save money and time by adopting online dot net training. The dot net course include dot net architecture, OOPS concept, web and windows application with visual studio, connect Sql server database using ado.net, entity framework. Apart from this dot net training centers give training in web services, deploying dot net applications, to build Asp.net web application with MVC architecture.

Practices on design patterns based on dot net with programming share point 2010 application. C# dot net programming with real time examples and web applications. Dot trainers mainly focus on training people to excel well in dot net to meet world class standards. The real time dot net centers have well equipped classrooms, broad band facilities, course materials. Students can get real time exposure as all trainers are good at their teaching skills. The training centers provide course materials for all students who enroll under the training program, apart from this they also train persons for resume preparation. Experts in real time dot net training centers train persons based on current technology requirement. Based on market strategy students can avail the best options from experts and can develop themselves in dot net technology.

Training batches are small so that trainers give more attention to each individual to train persons to become expert in that field and also they can clarify student doubts. Based on their flexi timing students can avail the training. The trainers in dot net training centers prepare students to face the interview. Apart from coaching they train students from interview point. Students can have both course based training as well as interview based training. Certificates are issued to all the students after their successful completion of the course. The certificates enable the students to get placed in software companies. Students who have been trained by the dot net training centers excel well in programming skills. In addition to this they develop knowledge in software related to dot net applications.

State management in Asp.net

Document by Vairavan – Ganesanva@hotmail.com – +919042710472

There are 2 types of state management
1.Server side
2.Client Side
Client Side

  1. View State
  2. Hidden Fields
  3. Cookies
  4. Query strings

Server Side

  1. Application state
  2. Session state

View state
It allows to maintain the value with in the page
Hidden Fields
It is the control in Asp.net used to store value with in the page. It does not shows visibility in the page.
Cookies
It is the small amount of data stored in client browser session
Query string
IT allows to pass the data from one page to another in the browser URL.
Application state:
Asp.net allows to save values using Application state in HttpApplicationstate class.
Session State:
It allows to store data in the server side using HttpSessionState class.
Create a new Project File –>New Project in Visual studio

Click ok.
Right Click on the solution and Add New Item.
Select Web form and Name GetValues.aspx.

Add one another form as SetValues.aspx
Put / Replace the below HTML in SetValues.aspx

<!DOCTYPE html>
<html xmlns=”http://www.w3.org/1999/xhtml”>
<head runat=”server”>
<title></title>
</head>
<body>
<form id=”form1″ runat=”server”>
<div>
<asp:TextBox ID=”txtsessionvalue” runat=”server”></asp:TextBox>
<asp:Button ID=”btnSetSession” runat=”server” Text=”Set Session Value” OnClick=”btnSetSession_Click” />
</div>
</form>
</body>
</html>

Put / Replace the below code in SetValues.aspx.cs

public partial class SetValues : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnSetSession_Click(object sender, EventArgs e)
{
Session[“Uservalue”] = txtsessionvalue.Text;
Response.Redirect(“GetValues.aspx?ID=2”);
}
}

Put / Replace the below HTML in GetValues.aspx

<!DOCTYPE html>
<html xmlns=”http://www.w3.org/1999/xhtml”>
<head runat=”server”>
<title></title>
</head>
<body>
<form id=”form1″ runat=”server”>
<div>
<asp:TextBox ID=”txtviewstate” runat=”server”></asp:TextBox>
<asp:Button ID=”btnGetSession” runat=”server” Text=”Get Session” OnClick=”btnGetSession_Click” />
<asp:Button ID=”btnSetViewState” runat=”server” Text=”Set View State” OnClick=”btnSetViewState_Click” />
<asp:Button ID=”btnGetViewState” runat=”server” Text=”Get View State” OnClick=”btnGetViewState_Click” />
<asp:Button ID=”btnGetQuerystringvalue” runat=”server” Text=”Get Query string Value” OnClick=”btnGetQuerystringvalue_Click” />
</div>
</form>
</body>
</html>

Put / Replace the below code in GetValues.aspx.cs

public partial class GetValues : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnGetSession_Click(object sender, EventArgs e)
{
string sessionvalue = (string)Session[“Uservalue”];
Response.Write(“The Session State value is ” + sessionvalue);
}
protected void btnSetViewState_Click(object sender, EventArgs e)
{
ViewState[“data”] = txtviewstate.Text;
}
protected void btnGetViewState_Click(object sender, EventArgs e)
{
string viewstatevalue = (string)ViewState[“data”];
Response.Write(“The view State value is “+viewstatevalue);
}
protected void btnGetQuerystringvalue_Click(object sender, EventArgs e)
{
string QueryStringvalue = (string)Request.QueryString[“ID”];
Response.Write(“The Query string value is ” + QueryStringvalue);
}
}

The Output as below,






Click below to download the solution,
https://1drv.ms/u/s!ArddhCoxftkQg617pH3vPsuhyrHvDA

CRUD operation in PHP with MySQL

Download and install XAMPP from the below url
https://www.apachefriends.org/download.html

Run the Xampp Exe File as below,
xampp-win32-7.0.13-0-VC14-installer.exe

Install XAMPP in the Customised location as below in E:\ drive.
Run Xampp_control.exe from XAMPP folder,

Start Apache and Mysql in XAMPP Control Panel

Click on Admin to redirect to MySQL Page,

Create employeedetails Database by clicking on New.

Click on Create to create database.
Click on New to create a new table.

Click on Save to create a new table.
Put the PHP files in htdocs folder as below,

Create CRUD folder in htdocs.

Create db.php,AddEmployee.php,index.php as shown below in CRUD folder.

Add below code in db.php,

<?php
$servername = “localhost”;
$username = “root”;
$password = “”;
$dbname = “employeedetails”;
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
?>

Code in index.php,

<style type=”text/css”>
</style>
<?php
include(‘db.php’);
?>
<a href=”AddEmployee.php” value=”Create Employee” >Create</a>
<table cellspacing=”5″ cellpadding=”5″>
<tr>
<th>
Employee Id
</th>
<th>
Employee Name
</th>
<th>
Age
</th>
</tr>
<?php
$sql =”select * from employeedata”;
$result1 = $conn->query($sql);
if ($result1->num_rows > 0) {
// output data of each row
while($row = $result1->fetch_assoc())
{
?>
<tr>
<td>
<?php echo $row[“EmpId”]?>
</td>
<td>
<?php echo $row[“EmpName”]?>
</td>
<td>
<?php echo $row[“EmpAge”]?>
</td>
<td>
<a href=”AddEmployee.php?edited=1&id=<?php echo $row[“EmpId”]; ?>”>Edit</a>
</td>
<td>
<a href=””>Delete</a>
</td>
</tr>
<?php
}
}else {
echo 0;
}
?>
</table>

Code in AddEmployee.php as below,

<?php
include(‘db.php’);
$EmployeeID=”;
$EmployeeName=”;
$Age=”;
$Operation=’Create’;
if(isset($_POST[‘btnSave’]))
{
if($_POST[‘txtoperation’] ==”Create”)
{
$EmpId=$_POST[‘txtEmployeeID’];
$EmpName=$_POST[‘txtEmployeeName’];
$Age=$_POST[‘txtAge’];
$sql=”INSERT INTO Employeedata(EmpId, EmpName, EmpAge) VALUES (‘$EmpId’,’$EmpName’,’$Age’)”;
if ($conn->query($sql) === TRUE) {
echo “New record created successfully”;
header(‘Refresh:0; index.php’);
} else {
echo “Error: ” . $sql . “<br>” . $conn->error;
}
}
else
{
$EmpId=$_POST[‘txtEmployeeID’];
$EmpName=$_POST[‘txtEmployeeName’];
$Age=$_POST[‘txtAge’];
$sql=”UPDATE Employeedata SET EmpName=’$EmpName’,EmpAge=’$Age’ WHERE EmpId='{$_GET[‘id’]}'”;
if ($conn->query($sql) === TRUE) {
echo “New record updated successfully”;
header(‘Refresh:0; index.php’);
} else {
echo “Error: ” . $sql . “<br>” . $conn->error;
}
}
}
if(isset($_GET[‘edited’]))
{
$sql =”select * from employeedata where EmpId='{$_GET[‘id’]}'”;
$result1 = $conn->query($sql);
if ($result1->num_rows > 0) {
// output data of each row
if($row = $result1->fetch_assoc())
{
$EmployeeID=$row[“EmpId”];
$EmployeeName=$row[“EmpName”];
$Age=$row[“EmpAge”];
$Operation=”Edit”;
}
}
}
?>
<form action=”” method=”post”>
<table>
<tr>
<td>Employee Id</td>
<td><input type=”text” name=”txtEmployeeID” value=”<?php echo $EmployeeID; ?>” />
<input type=”hidden” name=”txtoperation” value=”<?php echo $Operation; ?>” />
</td>
</tr>
<tr>
<tr>
<td>Student Name</td>
<td><input type=”text” name=”txtEmployeeName” value=”<?php echo $EmployeeName; ?>” /></td>
</tr>
<tr>
<td>Age</td>
<td><input type=”text” name=”txtAge” value=”<?php echo $Age; ?>” /></td>
</tr>
<tr>
<td></td>
<td><input type=”submit” value=”save” name=”btnSave” /></td>
</tr>
</table>
</form>

The Output is as below,

http://localhost/CRUD/index.php

http://localhost/CRUD/AddEmployee.php


http://localhost/CRUD/AddEmployee.php?edited=1&id=2
Click below to download the solution,
https://1drv.ms/u/s!ArddhCoxftkQg6w5Te07v0wqAspR4g