Friday, 12 September 2014

                                         Ajax Auto Complete Tutorial With Source Code
                                                                    For Beginners


First We Have To Create An Database.I am Using Sql Server For Database.

create table CART
(
ITEM_ID int Primary key identity(1,1),
Item_Name varchar(50),
Quantity int
)
insert into CART Values('Milk',10)
insert into CART Values('Soap',10)
insert into CART Values('Juice',10)
insert into CART Values('Jelly',10)
insert into CART Values('Toffee',10)
insert into CART Values('Tea',10)
insert into CART Values('Ice Cream',10)
insert into CART Values('Coffee',10)
insert into CART Values('Rice',10)
insert into CART Values('Risk',10)


















Then You Open A Visual Studio And Select Asp Empty Website.
Then You Have To Create And Connection String So there Is web.config located there so open it

   <connectionStrings>
        <add name="ConnectionString" connectionString="Data Source=.; Initial Catalog=Practice2AutoComplete; Integrated Security=True"/>
    </connectionStrings>