Bind data and display datatable on aspx page using Jquery/JSON in asp.net

Introduction:

In this article I will explain how to bind data to datatable and display it on our aspx page using JQuery or JSON in asp.net.

Description:
  
In previous article I explained how to bind data to gridview with JQuery. Now I am using same concept to explain how to bind data to datatable using JQuery/JSON and display it on aspx page in asp.net.

Bind data to gridview with JQuery or JSON in asp.net

Introduction:

Here I will explain how to bind data to asp.net gridview with JQuery or JSON using c#, vb.net or bind data to gridview with JQuery or JSON in asp.net using c#, vb.net.

Description:
  
In previous article I explained JQuery UI AutoComplete textbox with database and call asp.net pagemethods in JQuery. Now I am using those concepts to explain how to bind data to gridview using JQuery/JSON and display it on aspx page in asp.net.

How to call asp.net page methods from JSON or JQuery

Introduction:

In this article I will explain how to use JQuery and JSON to call asp.net page methods.

Description:
  
In previous article I explained JQuery UI AutoComplete textbox with database in that I declared page method directly in code behind and used it in our application. Now I am using same concept to create web methods and call those methods in our page using JQuery.

JQuery UI autocomplete textbox with database in asp.net

Introduction:

In this article I will explain how to implement Asp.net autocomplete textbox with database using JQuery.

Description:
  
In previous articles I explained Ajax autocomplete extender example and JQuery autocomplete textbox with images in asp.net. Now I will explain another article relating to autocomplete textbox with JQuery UI in asp.net.

Dynamically create datable and bind to gridview in asp.net

Introduction:

Here I will explain how to create datatable dynamically and bind to gridview in asp.net using c#, vb.net or create temporary table and bind data to columns in datatable dynamically using asp.net in c#, vb.net.

Description:

In Previous posts I explained lot of articles regarding Asp.net, Gridview, SQL Server, Ajax, JavaScript etc. In many of articles I used datatable to bind data from database but in one situation I got requirement like dynamically build and bind data to datatable in asp.net.

Increase/Decrease or Zoom in /out options to change font size in visual studio

Introduction:

In this article I will explain how to increase / decrease or zoom in /zoom out options to change font size in visual studio.

Description:

During work with visual studio unexpectedly I pressed some of keys in keyboard because of that my application font size increased to reduce that font size I search for options in visual studio after sometime I find different options available based on visual studio versions. 

using statement example in asp.net uses of using statement

Introduction:

In this article I will explain uses of using statement and how to declare and use using statement in asp.net.

Description:

In Previous posts I explained lot of articles regarding Asp.net, Gridview, SQL Server, Ajax, JavaScript etc. In many of articles I used connectionStrings to get data from database. 

Generally in our applications we will write code like create connection object to handle connectionstring after that open a connection and create command object etc. to interact with database to get data that would be like this 

Set Username and Password for a database in SQL Server

Introduction:

In this article I will explain how to create credentials or set userid and password for a particular database in SQL server.

Description:

In our asp.net web applications generally we used database connection strings like “Data Source=MyServer; Initial Catalog=MySampleDB;uid=test;pwd=test” to connect with SQL server database to get data.

How to reset identity column value in sql server

Introduction:

In this article I will explain how to reset identity column value of table in in SQL server.

Description:

In previous post I explained how set identity or auto increment column in SQL server. After set identity property on particular column I inserted few records in table and that value automatically increase whenever I inserted data that would be like this

JQuery Display/show average rating with decimal values from database in asp.net

Introduction:

In this article I will explain how to show average rating with decimal values in asp.net using JQuery.

Description:
  
In previous post I explained Ajax rating example with database in asp.net . If we use ajax rating control to display rating we have one disadvantage that is if we get average rating like 4.3 or 2.7 etc we don’t have chance to show rating based on that value because ajax rating supports only integer values to solve this problem I am writing this article to display average rating including decimal values using JQuery in asp.net.