Posts

Showing posts from January 27, 2014

Retrieve Data from SQL Server and Dispaly using Jquery in Asp.net

Image
Take the look at this: In the previous example we saw, How to insert data in database using jquery in asp.net ? now we will see how to display data in jquery in asp.net. Here we will use html page and a aspx.cs file. First Step: CreateTable with column name " Name " and " Email " Second Step:  Create a new project Third Step: Add a html file in your project. Fourth Step: Create input textbox and a button with id "Button1". Fifth Step: Add the following code in the aspx.cs file [ WebMethod ]     public static string InsertMethod( string Name)     {         string shashi = "" ;          StringBuilder sb = new StringBuilder ();         SqlConnection con = new SqlConnection ( "Data Source=PREETI-PC;Initial Catalog=Record;Integrated Security=True" );         {             SqlCommand cmd = new SqlCommand ( "select * from Test where Name='" +Name+ "'" , con)

Dictionary Search Algorithm to Store Data in Database and Search

Image
One day I was searching the meaning of an English word in dictionary and I got this in less span of time. As we all know that dictionary contains thousands of words and with the help of this we get them easily and quickly. What if we arrange our data in server in same manner then it will be very easy for our server to find it quickly with the help of this we can save the processing time of server and thus it will be user friendly. So, here we will design the data in same pattern i.e. we will arrange data in dictionary like. For this assume there is a web application which stores the primary information of user like Name, Email ID, Mobile No. , address and to arrange this like a dictionary we will create 26 tables with name A,B,C,D…up to Z. like this   And now will be insert data in database using jquery in asp.net . To do this first we will create a new project in visual studio 2010 and named it DictionarySearch we will include css and js folder in our project an