+91-90427 10472
         
Dot net training in Chennai

Planning a Better Career in Life with Dot Net Training Programs

Software training courses are necessary for the students who want to get better jobs in leading companies. They mainly aim at imparting the skills required for a project to complete it on time with high accuracy levels. There are different types of programs available for final year students to nourish their abilities effectively. Dot net is a software framework introduced by Microsoft that aims at enhancing the interactive capability of the websites with synchronized details. It is widely used platform for data access, cryptography, networking communication and other purposes to get desired results. Students willing to become .net expert in their life must focus on attending a training program in a reputed institute for increasing the skills efficiently.

On the other hand, identifying a coaching center is not an easy going job which requires proper research. The internet today provide methods for knowing details of the best dot net training institute in Chennai easily for selecting a course accordingly. This will help in developing the abilities of a student with professional teams for achieving better results. They even offer .net training courses with real- time projects enabling the students to achieve their goals. Most coaching centers cover modern facilities for learning lessons in a comfortable environment to focus more on their objective. In addition to that, they conduct training programs online with experienced teachers for getting more benefits. Dot net coaching is extremely useful for those who want to start a bright career in their life.

Moreover, it plays a significant role in improving the capabilities of working employees to upgrade their knowledge. Different types of programs are available for the students to select a right one depending upon the needs. The .net training in Chennai makes it possible for the freshers to sharpen their skills with highly qualified instructors. It involves various modules allowing the students to gain more exposure. Another advantage of undergoing a training course is that it gives ways for acquiring a certificate at flexible prices. The coaching programs are an ideal one for passing the interview test in reputed companies. Furthermore, they help to learn the lessons with the study materials and expert mentors by addressing essential needs.

Dot net training institute offer courses to students with flexible batch timings to ensure more advantages. It is necessary to know the syllabus and other details of a course before the joining procedure. Dot net training institute in Chennai allows the students to experience a better learning in a comfortable environment. Apart from that, it helps to carry out the tasks correctly by minimizing the errors and mistakes. Dot net course Chennai is a must one for the college students to get placed in various companies with high salaries. It is possible to evaluate the needs of students with the course for making them more effective in a project. The online courses are an ideal choice for those who want to learn the lessons in their home and other places for obtaining a certificate at the earliest.

Dot net CRUD operation with Ms access database

Create a new MS database access file
Save the MS access db as db1.mdb file (Access 2000 Database file format) as shown below.

  • Create a table tblUserDetails in MS access with below columns.


Create a table tblStudentDetails with the below columns.

Create a new windows Application project MsAccessCRUD

Add a windows form AddLoginDetails.cs

Design the form as below,

Replace the AddLoginDetails class file as below,

public partial class AddLoginDetails : Form
{
public AddLoginDetails()
{
InitializeComponent();
}
private void btnLogin_Click(object sender, EventArgs e)
{
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection();
conn.ConnectionString = @”Provider=Microsoft.Jet.OLEDB.4.0;” +
@”Data source= D:\db1.mdb”;
OleDbCommand cmd = new OleDbCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = @”Insert Into tblUserDetails(UserName,[Password])VALUES(‘”+txtUserName.Text+”‘,'”+txtPassword.Text+”‘)”;
cmd.Connection = conn;
conn.Open();
cmd.ExecuteNonQuery();
System.Windows.Forms.MessageBox.Show(“Record Successfully Created”);
StudentLogin objStudentLogin = new StudentLogin();
objStudentLogin.Show();
this.Hide();
conn.Close();
}
}

Add New form StudentLogin.cs and design as below,

Replace the StudentLogin Class with below code,

public partial class StudentLogin : Form
{
public StudentLogin()
{
InitializeComponent();
}
private void Button2_Click(object sender, EventArgs e)
{
// txtUserName.Text
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection();
conn.ConnectionString = @”Provider=Microsoft.Jet.OLEDB.4.0;” +
@”Data source= D:\db1.mdb”;
OleDbCommand cmd = new OleDbCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = @”select * from tblUserDetails where Password='” +txtPassword.Text +”‘”;
cmd.Connection = conn;
conn.Open();
OleDbDataReader OleDBDR = cmd.ExecuteReader();
while (OleDBDR.Read())
{
string value= OleDBDR[0].ToString();
System.Windows.Forms.MessageBox.Show(“Login Successful”);
ShowStudentDetails objform = new ShowStudentDetails();
objform.Show();
this.Hide();
}
conn.Close();
}
private void Button1_Click(object sender, EventArgs e)
{
}
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
AddLoginDetails obj = new AddLoginDetails();
obj.Show();
this.Hide();
}
}

Add a new form ShowStudentDetails.cs and design the form as below,

Replace the ShowStudentDetails.cs class file with below code,

public partial class ShowStudentDetails : Form
{
public ShowStudentDetails()
{
InitializeComponent();
}
private void ShowStudentDetails_Load(object sender, EventArgs e)
{
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection();
conn.ConnectionString = @”Provider=Microsoft.Jet.OLEDB.4.0;” +
@”Data source= D:\db1.mdb”;
OleDbCommand cmd = new OleDbCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = @”select * from tblStudentDetails”;
cmd.Connection = conn;
conn.Open();
OleDbDataAdapter ada = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
ada.Fill(ds);
dgvStudentdetails.DataSource = ds.Tables[0];
conn.Close();
}
}

The solution explorer will look as below,

Replace the connection string for Ms access database before running the solution, now its d:\db1.mdb

The Output as below,

Click on Sign Up,

Click Add.

Ms Access DB as below,

Click below to download the solution,

https://1drv.ms/u/s!ArddhCoxftkQg9NHjhgsr8veFi056A

Maria Academy – Best Dot net Training Institute in Chennai

Maria Academy is highly professionalized and experienced in providing best Dot net training courses in Chennai. Out of all other, why exactly .Net? As a platform, .Net has a lot of advantages over other platforms just like how we an edge over all others providing .Net training courses in Chennai. To list few, .Net allows multiple languages, horizontal scalability, easier interface and consistent Ul practices. With growing scope of .Net in various business functions like CRM, Supply management, Finance, having a grip on .Net is going to be a huge add on to your knowledge hub. Knowing dot net is known to double your chances of getting right into the field. With the growing competition if your hunt for best Dot net training institute has just begun, without any further hesitations, enter our premises for best dot net training and gain multiple advantages.

 

With training comes knowledge and with us it’s experienced and processed knowledge that is going to reach you.  We at Maria Academy are proudly holding a team of highly qualified and experienced faculty team for your best dot net training. Be it basics or ProLevel, we will always ensure you an excellent coverage and training. We are offering you a wonderful opportunity to do your .Net courses with our easily approachable and simple team who have produced brilliant results and have always ensured smoother running of all our training institutes. We believe in providing a quicker and easier understanding and aid your learning process more effectively.

 

We provide a complete course on dot net that prepares you to directly get on to working with dot net with ease and perfection. We also ensure you a trouble-free admission and learning process and a friendly environment for your course period. At Maria Academy your goal becomes our duty, and your betterment becomes our goal. We will tirelessly work to ensure your learning process becomes easier and fruitful for your entry into the most competitive IT field.  For best dot.net training courses and guidance instantly, feel free to reach us at our contact number.

 

We at Maria Academy have committed ourselves to provide best .Net training to ensure you with knowledge and experience. In this busy and huge city, our .Net training institutes are easily accessible and are located at various prime locations. Find our centres for dot net courses in Chennai here. With a very economical budget, you can easily complete your .Net course with added advantages and boost your career and multiply your chances of getting a good entry into Software field. Nothing worth comes easy, but an exception is our offer of dot net courses which comes easy Into your hands and gets your hands earn more and our hands responsible for your development. For further assistance and guidance on .Net, contact us.

MVC Training in Chennai

MVC training in Chennai has evolved by leaps and bounds in the last few years. Normally this course is designed as an 8 to 10 lecturer in a classroom session. There is a hand on lab exercises with the help of a live project which is evaluated by a trainer. To undertake this training you need to choose an institute of repute and the main point is that the learning environment has to be indeed good. They should provide you with a conducive learning environment where you can go on to understand the concepts of MVC in general. The training sessions needs to be a combination of theory and practical in details. It should be flexible and convenient as far as the timings are concerned. The course normally starts to begin with a demo view and an on student review. The instructors need to answer all the doubts of the student.

Real doting training is provided by most of the institutes in case of fresher’s to help them placed in software companies. The students are educated by the professional instructors in such a manner in the domain of Microsoft technologies so that they go on to become experts in this domain. Job assistance re provided to them so that they can stay ahead of the competition. From time to time workshops are conducted in the concept of .net technology. A good institute will not push the students into the course, and they are advised to undertake a free interactive session and then go on to decide which the best course of action is. All their efforts are channelized in the direction on how to go about fulfilling the dreams of the students.

What do you need to know about MVC in general?

MVC Training in Chennai is the best place to incorporate your skills in this domain. You can avail the services hands on of an experienced instructor and training on the latest version of MVC 5.0 is provided. In The focus is on theory and the main advantage of it over the web form is illustrated .Then one gets to know on to how to create a controller and then action. The MVC presentation has to start with some sort of diagram. When you are looking for something you tend to place a request that gets routed to a router. You need to understand the design pattern of MVC and then work on the module of ASP. NET framework and in this process, you tend to have an idea of developing lightweight web applications. You need to ensure that you have a suitable amount of walk thoughts and video tutorials as part of the program. Some of the features of this program are as follows

  • You can modulate using the areas
  • Work and develop areas that tend to be mobile compatible
  • Have a clear cut idea about the benefits of MVC design in comparison to the traditional ASP. NET web forms

 

To undertake the course it is suggested that prior knowledge of HTML is needed.

All About Dot Net Courses and Training available in Chennai

The .net courses are gaining in popularity and the developers have been able to create intelligent applications which can go on to integrate with other platforms within a limited time frame. Net training in Chennai has also soared the popularity charts in a big manner. Net is a concept that you would need on your windows PC to run the computer.

One of the main reasons on why you should undertake dot  net training in Chennai is because of the fact that it works out to be one of the popular programming languages that provides everything to be developed and you can go on to employ web based architectural deployment. More and more organizations are on the verge of implementing web services and .net technologies which helps to connect the business on a global platform. Another important aspect is that when you undertake dot net course Chennai you open your world of opportunities and gain employment to some of the top companies in the world.

When you undertake a dot net training institute in Chennai you will have hands on idea about the operating system, the fundamentals of programming along with the object oriented concepts. All the job aspirants who are pursuing graduation in IT or non IT stream who are looking to make the most of the job opportunities can go ahead and pursue this course. Roughly, this course spreads around 2126 hours.

To learn the, best dot net training institute in Chennai, there are some points that you need to give due consideration of sorts. Rather than rely on online training you can resort to the classroom led, instructor training. When there is a face to face interaction the focus not only improves but you are better faced to deal with employment chances. The institute that you should choose needs to have teaching staff with the proven level of experience. There should be a process where the teachers are handpicked and all their skills are tested, before they embark on the journey to provide their knowledge to the students. A good set up will undertake your periodic evaluation from time to time and you will be able to understand on where you stand currently. If you tend to miss any classes they will make arrangements that you attend the alternate classes and cover it up. In case of any doubts that might spring up, the faculty is always there to lend you a helping hand. If the situation permits you can also opt for extra classes and clear your doubts as well.

In the modern day world, with information being part and parcel of our life in a big way, choosing a good institute is an easy task. You just need to type the course name of dot net and a host of names will spring up in front of you. You need to do a research yourself and find out that in terms of value of money the course is right up there.

Send mail to users from gmail account using c#.net

Document by Alagappan -ganesanva@hotmail.com – + 919042710472

Click on File –> New Project in Visual Studio. Enter the solution name as MailUser.

Click OK
Right Click on the Project and add new item.
Add new form with name SendEmail.aspx

Put / Replace the below code in SendEmail.aspx

<!DOCTYPE html>
<html xmlns=”http://www.w3.org/1999/xhtml”>
<head runat=”server”>
<title></title>
</head>
<body>
<form id=”form1″ runat=”server”>
<div>
<table border=”0″ cellspacing=”2″ cellpadding=”2″>
<tr>
<td>
Email To
</td>
<td>
<asp:TextBox ID=”txtMailTo” runat=”server”></asp:TextBox>
</td>
</tr>
<tr>
<td>
Subject
</td>
<td>
<asp:TextBox ID=”txtSubject” runat=”server”></asp:TextBox>
</td>
</tr>
<tr>
<td>
Body
</td&gt
<td>
<asp:TextBox ID=”txtBody” runat=”server” TextMode=”MultiLine”></asp:TextBox>
</td>
</tr>
<tr>
<td>
</td>
<td>
<asp:Button ID=”btnSend” runat=”server” Text=”Send” OnClick=”btnSend_Click” />
</td>
</tr>
</table>
</div>
</form>
</body>
</html>

Put / Replace the below code In SendEmail.aspx.cs

public partial class SendEmail : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnSend_Click(object sender, EventArgs e)
{
string result=SendEmailtousers(txtMailTo.Text, txtSubject.Text, txtBody.Text);
Response.Write(result);
}
protected string SendEmailtousers(string toAddress, string subject, string body)
{
string result = “Message Sent Successfully..!!”;
string senderID = WebConfigurationManager.AppSettings[“SenderID”];// use sender’s email id here..
string senderPassword = WebConfigurationManager.AppSettings[“SenderPassword”]; // sender password here…
try
{
SmtpClient smtp = new SmtpClient
{
Host = “smtp.gmail.com”,
Port = 587,
EnableSsl = true,
DeliveryMethod = SmtpDeliveryMethod.Network,
Credentials = new System.Net.NetworkCredential(senderID, senderPassword),
Timeout = 30000,
};
MailMessage message = new MailMessage(senderID, toAddress, subject, body);
message.CC.Add(WebConfigurationManager.AppSettings[“CCMail”]);
smtp.Send(message);
}
catch (Exception ex)
{
result = “Error sending email.!!!””;
}
return result;
}
}

Add the below code in web.config below Connectionstrings tag

<appSettings>
<add key=”SenderID” value=”ganesvija@gmail.com”/>
<add key=”SenderPassword” value=”*****”/>
<add key=”CCMail” value=”ganesanva@hotmail.com”/>
</appSettings>


Replace **** with actual password in key SenderPassword.
Run the solution.

The Output as below,



GMAIL inbox,

Note:
In order to trigger mail from client, Enable this on the From Address Gmail account.
Turn on Allow for Less Secure apps.

https://www.google.com/settings/security/lesssecureapps
Reference:
https://support.google.com/accounts/answer/6010255?hl=en
Click below to download the solution,
https://1drv.ms/u/s!ArddhCoxftkQg7UPuVICB-batxhXag

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

JQuery validation in Asp.net web application

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

Create a new Asp.net web application using File -> New Project

Solution Explorer looks as below,

Add new page AddEmployee.aspx
Put / replace the below code in AddEmployee.aspx

<html xmlns=”http://www.w3.org/1999/xhtml”>
<head runat=”server”>
<title></title>
<script src=”https://ajax.googleapis.com/ajax/libs/jquery/1.12.0/jquery.min.js”></script>
<script type=”text/javascript”>
function validate() {
if ($(‘#txtEmployeeName’).val() == “”) {
alert(‘Please enter Employee Name’);
return false;
}
if ($(‘#txtAge’).val() == “”) {
alert(‘Please enter Age’);
return false;
}
var radios = document.getElementsByName(‘Gender’);
var radioselected = ”;
for (var i = 0, length = radios.length; i < length; i++) {
if (radios[i].checked) {
// do whatever you want with the checked radio
radioselected = radios[i].value;
// only one radio can be logically checked, don’t check the rest
break;
}
}
if(radioselected ==””)
{
alert(‘Please select Gender’);
return false;
}
if ($(‘#ddlCity’).val() == “–Select–“) {
alert(‘Please select city’);
return false;
}
return true;
}
</script>
</head>
<body>
<form id=”form1″ runat=”server”>
<div>
<table border=”0″ cellspacing=”2″ cellpadding=”2″>
<tr>
<td>Employee Name
</td>
<td>
<asp:TextBox ID=”txtEmployeeName” runat=”server”></asp:TextBox>
</td>
</tr>
<tr>
<td>Age
</td>
<td>
<asp:TextBox ID=”txtAge” runat=”server”></asp:TextBox>
</td>
</tr>
<tr>
<td>Gender
</td>
<td>
<asp:RadioButton ID=”rbtnMale” runat=”server” GroupName=”Gender” Text=”Male” />
<asp:RadioButton ID=”rbtnFemale” runat=”server” GroupName=”Gender” Text=”Female” />
</td>
</tr>
<tr>
<td>City
</td>
<td>
<asp:DropDownList ID=”ddlCity” runat=”server”>
<asp:ListItem Text=”–Select–” Value=”–Select–“></asp:ListItem>
<asp:ListItem Text=”Chennai” Value=”Chennai”></asp:ListItem>
<asp:ListItem Text=”Madurai” Value=”Madurai”></asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td></td>
<td>
<asp:Button ID=”btnSave” runat=”server” Text=”Save” OnClientClick=”return validate();” OnClick=”btnSave_Click” />
</td>
</tr>
</table>
</div>
</form>
</body>
</html>

Replace the below code in AddEmployee.aspx.cs

public partial class AddEmployee : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnSave_Click(object sender, EventArgs e)
{
Response.Write(“Saved Successfully”);
}
}

On clicking Save button ,JQuery validation Fires as below.
The Output is as below,





Note
You can check the Jquery validation using Console in Chrome.

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

CRUD in ASP.net web application using Stored procedure

Document by Maria Academy – mariatrainingacademy@gmail.com – +919042710472

Create Database in SQL server as below,

Create database StudentDB

Create StudentDetails table using the below script,

CREATE TABLE [dbo].[StudentDetails](
[StudentId] [int] IDENTITY(1,1) NOT NULL,
[StudentName] [varchar](100) NULL,
[Age] [int] NULL
) ON [PRIMARY]

Run the below Stored Procedures in SQL Server,

create Proc [dbo].[Ins_StudentDetails]
@StudentName varchar(100),
@Age int
as
begin
INSERT INTO [StudentDetails]
([StudentName]
,[Age])
VALUES
(@StudentName
,@Age)
create Proc [dbo].[Select_StudentDetails]
as
begin
select * from StudentDetails
end
create Proc [dbo].[Update_StudentDetails]
@StudentId int,
@StudentName varchar(100),
@Age int
as
begin
UPDATE [StudentDetails]
SET [StudentName] = @StudentName
,[Age] = @Age
WHERE StudentId=@StudentId
end

Create a new Asp.net web application CRUDinProcedure as below,
File -> New Project

Click OK.
Solution Explorer as below,

Add new Page AddStudentDetails.aspx
Put / Replace the below code in AddStudentDetails.aspx

<html xmlns=”http://www.w3.org/1999/xhtml”>
<head id=”Head1″ runat=”server”>
<title></title>
</head>
<body>
<form id=”form1″ runat=”server”>
<div>
<table border=”0″ cellspacing=”2″ cellpadding=”2″>
<tr>
<td>
<asp:Label ID=”lblStudentName” runat=”server” Text=”Student Name”></asp:Label>
</td>
<td>
<asp:TextBox ID=”txtStudentName” runat=”server”></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID=”lblAge” runat=”server” Text=”Age”></asp:Label>
</td>
<td>
<asp:TextBox ID=”txtAge” runat=”server”></asp:TextBox>
</td>
</tr>
<tr>
<td></td>
<td>
<asp:Button ID=”btnSubmit” runat=”server” Text=”Submit” OnClick=”btnSubmit_Click” />
<asp:Button ID=”btnUpdate” runat=”server” Text=”Update” OnClick=”btnUpdate_Click” />
<asp:Button ID=”btnClear” runat=”server” Text=”Clear” OnClick=”btnClear_Click” />
<asp:HiddenField ID=”hfId” runat=”server”></asp:HiddenField>
</td>
</tr>
<tr>
<td colspan=”2″>
<asp:GridView ID=”grvStudentDetails” runat=”server” AutoGenerateColumns=”false”>
<Columns>
<asp:BoundField DataField=”StudentId” HeaderText=”StudentId” />
<asp:BoundField DataField=”StudentName” HeaderText=”StudentName” />
<asp:BoundField DataField=”Age” HeaderText=”Age” />
<asp:TemplateField>
<ItemTemplate>
<asp:Button ID=”btnEdit” runat=”server” Text=”Edit” OnClick=”btnEdit_Click” />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>

Replace the below code in AddStudentDetails.aspx.cs,

public partial class AddStudentDetails : System.Web.UI.Page
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[“DefaultConnection”].ToString());
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BindGrid();
}
}
private void BindGrid()
{
btnSubmit.Visible = true;
btnUpdate.Visible = false;
SqlCommand cmd = new SqlCommand(“Select_StudentDetails”, con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter ada = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
ada.Fill(ds);
grvStudentDetails.DataSource = ds.Tables[0];
grvStudentDetails.DataBind();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = new SqlCommand(“Ins_StudentDetails”, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(“@StudentName”, SqlDbType.VarChar).Value = txtStudentName.Text;
cmd.Parameters.Add(“@Age”, SqlDbType.Int).Value = txtAge.Text;
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
Response.Write(“Inserted Successfully”);
}
con.Close();
BindGrid();
btnClear_Click(null, null);
}
protected void btnEdit_Click(object sender, EventArgs e)
{
Button btn = (Button)sender;
//Get the row that contains this button
GridViewRow gvr = (GridViewRow)btn.NamingContainer;
hfId.Value = gvr.Cells[0].Text;
txtStudentName.Text = gvr.Cells[1].Text;
txtAge.Text = gvr.Cells[2].Text;
btnSubmit.Visible = false;
btnUpdate.Visible = true;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = new SqlCommand(“Update_StudentDetails”, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(“@StudentId”, SqlDbType.Int).Value = hfId.Value;
cmd.Parameters.Add(“@StudentName”, SqlDbType.VarChar).Value = txtStudentName.Text;
cmd.Parameters.Add(“@Age”, SqlDbType.Int).Value = txtAge.Text;
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
Response.Write(“Updated Successfully”);
}
con.Close();
BindGrid();
btnClear_Click(null, null);
}
protected void btnClear_Click(object sender, EventArgs e)
{
txtStudentName.Text = string.Empty;
txtAge.Text = string.Empty;
hfId.Value = string.Empty;
}
}

Screenshot as below,

The Output will be as below,




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

Dot Net Training Institute in Chennai

Dot net is a software program developed by Microsoft Corporation that plays a significant role in web development applications. Dot net employees are in great demand over the recent years and many companies recruit them who have undergone a training program. There are several private institutes that organize training classes for college students and working people to shape their skills effectively. However, it is necessary to identify a right one among them for developing the abilities considerably. This will help to start a bright career after completing college studies. There are several sources available for knowing the details of a coaching center in a location. On the other hand, it is essential to make a study on them from the internet for finding a institute accordingly.

Dot net training classes are extremely useful for the beginners who want to get jobs with good salaries in various fields. At the same time, it is advisable to check the prerequisites before choosing a training program. Dot net training institute in Chennai offers programs from basic to advanced levels which ultimately help students to focus more on their objectives. It provides excellent opportunities for the students to learn the lessons with latest concepts. Expert staffs and industry professionals will show ways for enhancing the skills of a student in a comfortable environment. Students can get also interact with them for knowing more about opportunities in various industries to start a bright future. Moreover, it is possible to build the skills with real time projects for getting a certificate with high grades.

Most training institutes organize full time, part time and week end classes for the students with excellent teaching faculties. Moreover, they can choose online classes to study the lessons from anywhere easily. Some even conduct seminars, workshops and conferences in order to evaluate the potentials of students. Dot net course Chennai enables the students to undergo training at affordable rates for reaching next levels. Apart from coaching, it offers job assistance services to students who have successfully finished a course. Anyone interested in knowing more about the programs can attend the introductory sessions in a center for gaining more ideas. This in turn gives ways for increasing the efficiency levels while applying for a job in a company.

It is advisable to select a best dot net training institute in Chennai that provide classes with the updated syllabus. Students can enroll their names in a training course for learning the lessons with industry experts. Fresh graduates will benefit a lot with a training program for achieving goals. One must give importance to the reviews and testimonials before joining in an institute for meeting essential requirements. The main objective of dot net course is to make students to fulfill their dreams. Another advantage is that it helps to become familiar with the applications when seeking jobs in a software company. Training fees are an affordable one enabling the students to develop their abilities with innovative approaches. Dot net training paves ways for seeking jobs in reputed companies with high salaries.

Identifying Dot Net Coaching Institutes in Chennai for Shaping the Skills

Dot net training is an essential one for those who get jobs in leading IT companies and other firms with better salaries. There are many organizations that recruit employees based on their experience and skills. Some even conduct tests for analyzing the potentials of a job seeker. It is an essential one to undergo a training program in a leading institute for shaping the potentials efficiently. However, it is necessary to find a right training center properly for choosing a course depending upon the needs. The internet is a best platform for this purpose because it helps to compare the services offered by various institutes easily. With dot net coaching, it is possible to develop the potentials to reach high levels in career.

 

Most training centers organize the classes based on the requirements of a person to shape his or her abilities with excellence. Besides that, they focus more on conduct the program with industry experts and live projects for achieving better results. Dot not training in Chennai is a suitable for students, job seekers and employees to develop their skills at different levels. It gives ways for learning the lessons in a comfortable environment to meet exact needs. Apart from that, it contributes a lot in augmenting the programming and other potentials with expert teaching faculties. Anyone interested in knowing more about the coaching classes can get ideas from a counselor for selecting a program which perfectly suits their requirements.

 

Some institutes even assist the students to apply for the jobs in reputed companies. On the other hand, it is necessary to go through the testimonials and reviews before choosing a course in a center. This will help a lot for learning the lessons in a comfortable environment. Different types of coaching programs are available for the students to augment their abilities. Dot net training institute in Chennai mainly aims at developing self confidence levels of students with different types of tasks. In fact, it gives ways for analyzing their skills with theory and practice classes. Satisfaction guarantee is the primary aim of a coaching center in Chennai while offering services to students. Online training is also available for those who want to augment their skills anywhere.

 

Dot net training is a perfect one for both employees and employers to complete a project with more accuracy. They can learn more about problem solving techniques to gain more benefits. It is an important one to consider certain important facts before choosing an institute. Study materials offered by the institutes are extremely useful for ensuring desired outputs when executing a new project. Many training institutes allow students to pay their fees with flexible options. Besides that, they conduct exams for the students to correct their mistakes as soon as possible. It is possible to learn more about the training programs from the internet for seeking admission into a right one. The students can undergo coaching classes in a center with the latest computer applications for meeting essential needs in the learning procedure.