TECH-POST: August 2016

GridView Using StoredProcedure With Templatefield In ASP.NET

In this article i show you how to use gridview with templatefields in asp.net
step1:-Create table
CREATE TABLE tblEmp
(
Id int primary key identity,
FirstName varchar(50),
LastName varchar(50),
Designation varchar(50),
Salary int,
City varchar(50),
)
Step2:-Insert some data in table

INSERT INTO tblEmp VALUES('SIVA','Garika','UiDeveloper',15000,'Hydarabad')
INSERT INTO tblEmp VALUES('Narayana','Garika','Developer',25000,'Hydarabad')
INSERT INTO tblEmp VALUES('Kiran','Thota','Developer',35000,'Hydarabad')
INSERT INTO tblEmp VALUES('Madhu','Thota','Developer',19000,'Hydarabad')
INSERT INTO tblEmp VALUES('Manasa','Javisetty','Testar',15000,'Hydarabad')
INSERT INTO tblEmp VALUES('Malavika','Dongari','Developer',15000,'Hydarabad')
INSERT INTO tblEmp VALUES('Mounika','Javisetty','Testar',15000,'Hydarabad')
INSERT INTO tblEmp VALUES('Anji','Dongari','Developer',25000,'Hydarabad')
INSERT INTO tblEmp VALUES('Aravind','Choodi','Developer',32000,'Hydarabad')
INSERT INTO tblEmp VALUES('Avinash','Choodi','Developer',26000,'Hydarabad')

GridView Using StoredProcedure With DataBoundControls In ASP.NET

In this article i show you how to use gridview with sqldatareader and databound controls in asp.net
step1:-Create table
CREATE TABLE tblEmp
(
Id int primary key identity,
FirstName varchar(50),
LastName varchar(50),
Designation varchar(50),
Salary int,
City varchar(50),
)
Step2:-Insert some data in table

INSERT INTO tblEmp VALUES('SIVA','Garika','UiDeveloper',15000,'Hydarabad')
INSERT INTO tblEmp VALUES('Narayana','Garika','Developer',25000,'Hydarabad')
INSERT INTO tblEmp VALUES('Kiran','Thota','Developer',35000,'Hydarabad')
INSERT INTO tblEmp VALUES('Madhu','Thota','Developer',19000,'Hydarabad')
INSERT INTO tblEmp VALUES('Manasa','Javisetty','Testar',15000,'Hydarabad')
INSERT INTO tblEmp VALUES('Malavika','Dongari','Developer',15000,'Hydarabad')
INSERT INTO tblEmp VALUES('Mounika','Javisetty','Testar',15000,'Hydarabad')
INSERT INTO tblEmp VALUES('Anji','Dongari','Developer',25000,'Hydarabad')
INSERT INTO tblEmp VALUES('Aravind','Choodi','Developer',32000,'Hydarabad')
INSERT INTO tblEmp VALUES('Avinash','Choodi','Developer',26000,'Hydarabad')

GridView Using StoredProcedure With Dataset In ASP.NET

In this article i show you how to use sqldatareader in asp.net
step1:-Create table
CREATE TABLE tblEmp
(
Id int primary key identity,
FirstName varchar(50),
LastName varchar(50),
Designation varchar(50),
Salary int,
City varchar(50),
)
Step2:-Insert some data in table

INSERT INTO tblEmp VALUES('SIVA','Garika','UiDeveloper',15000,'Hydarabad')
INSERT INTO tblEmp VALUES('Narayana','Garika','Developer',25000,'Hydarabad')
INSERT INTO tblEmp VALUES('Kiran','Thota','Developer',35000,'Hydarabad')
INSERT INTO tblEmp VALUES('Madhu','Thota','Developer',19000,'Hydarabad')
INSERT INTO tblEmp VALUES('Manasa','Javisetty','Testar',15000,'Hydarabad')
INSERT INTO tblEmp VALUES('Malavika','Dongari','Developer',15000,'Hydarabad')
INSERT INTO tblEmp VALUES('Mounika','Javisetty','Testar',15000,'Hydarabad')
INSERT INTO tblEmp VALUES('Anji','Dongari','Developer',25000,'Hydarabad')
INSERT INTO tblEmp VALUES('Aravind','Choodi','Developer',32000,'Hydarabad')
INSERT INTO tblEmp VALUES('Avinash','Choodi','Developer',26000,'Hydarabad')

GridView Using StoredProcedure With Sqldatareader In ASP.NET

How to restrict textbox values in angularJS

In this article i show you how to get textbox value in angulaJS. First we need to add angularJS reference
in html page
Step1:- add angularJS reference in html page
<script src="Scripts/angular.js"></script>
<script src="Scripts/Script1.js"></script>
Script1.js is the javascript file for declaring module and controller

/// <reference path="angular.min.js" />
var app = angular.module("myapp",[])
.controller("mycontroller", function ($scope)
{
})
add reference to the javascriptfile
step2:-Add html page.In angularJS we have two directives ng-mimilenth ang ng-maxlenth for restricting textbox values.We are using expressions for getting textbox value.Expressions are declared by using bracess
<div ng-app="myapp">
<div ng-controller="mycontroller">
<input type="text" ng-model="name" ng-maxlength="12" ng-minlength="5" />
<br />
<br />
{{name}}
</div>
</div>

How to get textbox value in angularJS

In this article i show you how to get textbox value in angulaJS. First we need to add angularJS reference
in html page
Step1:- add angularJS reference in html page
<script src="Scripts/angular.js"></script>
<script src="Scripts/Script1.js"></script>
Script1.js is the javascript file for declaring module and controller

/// <reference path="angular.min.js" />
var app = angular.module("myapp",[])
.controller("mycontroller", function ($scope)
{
})
add reference to the javascriptfile
step2:-Add html page.We are using expressions for getting textbox value.Expressions are declared by using bracess
<div ng-app="myapp">
<div ng-controller="mycontroller">
<input type="text" ng-model="name" />
<br />
<br />
{{name}}
</div>
</div>

Home