Convert datatable/dataset to arraylist in asp.net

Introduction:

In this article I will explain how to convert datatable or dataset data to arraylist using asp.net.

Description:
  
I explained many articles relating to Asp.net, C#.NET, Gridview, JQuery etc. During working with those articles I came across one situation that is converting datatable to arraylist and dataset to arraylist to use it in applications. During that time I realized it would helpful for others if I write post on this. Please check the below methods to convert datatable to arraylist and dataset to arraylist in asp.net. 

Read/Write appsettings from web.config file in asp net

Introduction:

In this article I will explain how to read or write appsettings in web.config file using asp.net.

Description:

In Previous article I explained clearly about how to read or write connectionstrings from web.config file in asp.net. Now I will explain how to write appsettings in web.config file and how to read appsettings from web.config file using asp.net. 

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.