Archive for February 2017
web.config - connection string
web.config
<?xml version="1.0" encoding="utf-8"?>
<!--
For more information on how to configure your ASP.NET application, please visit
http://go.microsoft.com/fwlink/?LinkId=169433
-->
<configuration>
.
ADO.NET DropDownlist binding
SQL Queries
create Table Tbl_Category (CategoryId bigint Primary key identity, CategoryName varchar(100),CreatedTime datetime)
insert Tbl_Category values('Electronics',getdate())
insert Tbl_Category values('Home Appliances',getdate())
insert Tbl_Category.
GridView Edit Update Delete
SQL Queries
create table Tbl_Admin(Aid int identity primary key, Username varchar(50),Pwd varchar(50),PhoneNumber varchar(20),createdtime datetime)
insert into Tbl_Admin values('sudhir','sud',999898898,getdate())
insert into Tbl_Admin values('raj','raj123',999898897,getdate())
insert.