Insert & Fetch Data from Access Database in Asp.net using C#, VB.NET

Introduction:

Here I will explain how to insert data into ms access database in asp.net using c#, vb.net or get or fetch or retrieve data from ms access database in asp.net using c#, vb.net.

Description:

In previous articles I explained jQuery drag and drop gridview rows in asp.net, jQuery custom dropdown with images in asp.net, jQuery multi select dropdownlist with checkboxes, Dynamically create temporary table in asp.net using c#, vb.net, export datagridview data to excel in windows application and many more articles related to asp.net using c#, vb.net. Now I will explain how to connect ms access database in asp.net using c#, vb.net.

To use ms access database in asp.net first we need to create database in ms access for that follow below steps.

How to Connect MS Access Database in Asp.net using C#, VB.NET

Introduction:

Here I will explain how to connect ms access database in asp.net using c#, vb.net. To use Microsoft (MS) access database to insert, update, delete data in asp.net we need to use System.Data.OleDb namespace reference in c#, vb.net.

Description:

In previous articles I explained jQuery drag and drop gridview rows in asp.net, jQuery custom dropdown with images in asp.net, jQuery multi select dropdownlist with checkboxes, Dynamically create temporary table in asp.net using c#, vb.net, export datagridview data to excel in windows application and many more articles related to asp.net using c#, vb.net. Now I will explain how to connect ms access database in asp.net using c#, vb.net.

To use ms access database in asp.net first we need to create database in ms access for that follow below steps.

jQuery Fixed Header (DIV) on Page Scroll or Window Scroll with Example

Introduction: 
  
Here I will explain jQuery fixed header or div on scrolling example or jQuery fixed header or div on page scroll or windows scroll with example. jQuery fixed header on scroll is used to display header at the top of the web page at all times during page or window scroll.

Description:
  
In previous posts I explained jQuery floating fixed navigation menu example, jQuery fixed div header notification bar on scroll with fade in out, jQuery Google Currency Converter API Example, jQuery generate thumbnails from youtube videos, jQuery Change style of controls, jQuery Add fade in effect to webpage, and many articles relating to JQuery and modal popup. Now I will explain how to implement jQuery fixed header on page scrolling example.

Show (Display) Alert Message Box from Code Behind in Asp.net using C#, VB.NET

Introduction: 

Here I will explain how to show alert message box from code behind in asp.net using c# and vb.net or display alert message from code behind in asp.net using c# and vb.net.

Description:

In previous posts I explained call page methods from JSON string in asp.net, jQuery floating div on page scroll, jQuery generate years dropdown dynamically, asp.net Google currency converter and many articles relating to gridview, asp.net, c#. Now I will explain how to show alert message box from code behind in asp.net using c# and vb.net .

Delete (Remove) Multiple Selected Items from Listbox in Asp.net on Button Click using C#, VB.NET

Introduction:

Here I will explain how to remove or delete multiple selected items from listbox in on button click in asp.net using c#, vb.net with example or remove or delete multiple items from listbox items button click in asp.net using c#, vb.net.

Description:

In previous post I explained add textbox values to listbox in asp.net on button click, create and consume webservice in asp.net, simple cursor example in sql server, sitemap control example, send html page as mail body in asp.net, how to send mail with attachment in asp.net and many more articles related to asp.net using c#, vb.net. Now I will explain how to delete or remove multiple selected items from listbox on button click in asp.net using c#, vb.net with example.

Sort Asp.net Gridview Columns with Dropdownlist Selection in C# using Order By in SQL Server

Introduction:

Here I will explain how to sort gridview columns based on dropdownlist selection in asp.net using Order By clause in SQL Server. Whenever we are trying to sort a gridview or Repeater through the dropdownlist we used to add either switch case or if else condition. So there will be too many conditions as the list of the dropdownlist increases and every time you have to change in code behind (adding conditions or delete conditions). While doing one of my projects I found its solutions myself and going to share with you.

Description:

Previously we have discussed about Sorting Columns in Repeater Control in Asp.net using C#, How to show the up and down arrows during sorting of column in gridview using asp.net and today we will show how to sort gridview columns based on dropdownlist selection in asp.net using Order By clause in SQL Server.

Read(Get) Appsettings Value from App.Config File in C#, VB.NET

Introduction:

Here I will explain how to read or get appsettings values from app.config file in c#, vb.net. By using System.Configuration reference we can read or get appsettings values from app.config file in windows or console application in c#, vb.net.

Description:

In previous articles I explained export datagridview data to excel in windows application, create windows forms application setup file in c#, vb.net, delete windows service from system, create windows service in c#, vb.net and many more articles related to asp.net using c#, vb.net. Now I will explain how to read or get appsettings values from app.config file in c#, vb.net.

To read appsettings values from app.config file first create new windows application and open your app.config file and add appsettings string like as shown below

Get (Read) Connectionstring from App.Config File in C#, VB.Net

Introduction:

Here I will explain how to read or get connectionstring from app.config file in c#, vb.net. By using System.Configuration reference we can read or get connectionstring from app.config file in windows or console application in c#, vb.net.

Description:

In previous post I explained encrypt or decrypt connectionstring in app.config file, export datagridview to crystal report in windows application, convert currency or numbers to words in asp.net, angularjs bind dropdownlist with text and value, jQuery tag cloud example in asp.net and many more articles related to asp.net using c#, vb.net. Now I will explain how to read or get connectionstring from app.config file in c#, vb.net.

To read connectionstring from app.config file first create new windows application and open your app.config file and add conneciton string like as shown below

C# - The Connectionstring Property has Not been Initialized in Asp.net

Introduction:

Here I will explain how to solve the problem of “the connectionstring property has not been initialized in asp.net while sending request to connect SQL Server” using c#.net, vb.net.

Description:

In previous posts I explained read connection string from web.config file in asp.net, read appsettings from web.config file in asp.net, use multiple web.config files in asp.net with example, encrypt and decrypt connection string in asp.net and many articles relating to solve errors in asp.net, SQL Server, IIS, etc. Now I will explain how to solve the problem of “the connectionstring property has not been initialized in asp.net while sending request to connect SQL Server”.

Encrypt and Decrypt Connection String in App.Config File in Windows / Console Applications

Introduction:

Here I will explain how to encrypt and decrypt connection string in app.config file in windows or console application using c#.net, vb.net. we can do encryption and decryption for connection string using aspnet_regiis.exe command line tool in file system website.

Description:

In Previous articles I explained add textbox items to listbox on button click in asp.net, difference between dispose and finalize methods in c#, vb.net, difference between page_load and page_init methods in asp.net, convert numbers or rupees to words in asp.net and many articles related to Asp.net, Gridview, SQL Server, Ajax, JavaScript. Now i will explain how to encrypt and decrypt connection string in app.config file in windows or console applications. 

Generally in all applications we will use connectionStrings section in web.config or app.config file to store database connection. The connectionStrings section contains sensitive information of database connections including username and password of database. Is it secured to store the sensitive information of database connections in plain text files called web.config and machine.config files? 

jQuery Currency Conversion as per Exchange Rates using Google Finance API Web Service in ASP.Net

Introduction: 

Here I will explain how to implement currency conversion as per exchange rates in asp.net using Google finance api web service in jQuery or jQuery Google currency conversion finance api web service to convert currency as per exchange rates in asp.net.

Description:
  
In previous articles I explained jQuery upload multiple files using uploadify plugin, jQuery Shake or Vibrate or Rotate image, Change the style of tooltip in jQuery, jQuery Countdown timer script example, jQuery Increase or Decrease font size of website, Redirect to another page after some time delay and many articles relating to jQuery and asp.net. Now I will explain how to implement currency conversion as per exchange rates in asp.net using Google finance api webservice in jQuery. To implement this functionality we can use Google Currency conversion API.

jQuery Refresh DIV Content Without Reloading Page using setTimeout Function

Introduction: 

Here I will explain how to use jQuery to refresh or reload div content without reloading page for every 10 seconds with example using setTimeout function or jQuery reload or refresh div for every 10 seconds without reloading page or Refresh div content without reloading page using jQuery.

Description:
  
In previous articles I explained Different methods to reload / refresh page using jQuery, jQuery reload iframe for every 10 or 5 seconds, jQuery reload or refresh iframe, jQuery different methods to reload or refresh div, Javascript call function for every 5 or 10 seconds using setinterval function and many articles relating to AngularJS, jQuery, JavaScript and asp.net. Now I will explain how to use jQuery to refresh or reload div content without reloading page for every 10 seconds with example using setTimeout function.

By using setTimeout function we can refresh div content without reloading page for every 10 seconds using jQuery like as shown below

jQuery Refresh (Reload) Div For Every 10 Seconds with Example using setTimeout

Introduction: 

Here I will explain how to auto load and refresh div for every 10 seconds using jQuery with example using setTimeout function or jQuery reload or refresh div for every 10 seconds or jQuery reload or refresh div for every 10 seconds using setTimeout function.

Description:
  
In previous articles I explained jQuery reload iframe for every 10 or 5 seconds, jQuery reload or refresh iframe, jQuery different methods to reload or refresh div, Javascript call function for every 5 or 10 seconds using setinterval function and many articles relating to AngularJS, jQuery, JavaScript and asp.net. Now I will explain how to reload or refresh div for every 10 seconds using jQuery with example.

By using setTimeout function we can refresh or reload div for every 10 seconds using jQuery like as shown below

Angularjs Hide Particular Column in UI Grid with Example

Introduction: 

Here I will explain how to hide particular column in AngularJS UI grid with example or AngularJS hide particular column in UI Grid with example or UI Grid example in AngularJS.

Description:
  
In previous articles I explained bind dropdownlist in angularjs, Angularjs convert lower case to upper case while typing text, Angularjs refresh div for every 1 second using interval mode and many articles relating to AngularJS, jQuery, JavaScript and asp.net. Now I will explain how to hide particular column in AngularJS UI grid with example.

To hide particular column in AngularJS UI grid we can use visible: false property like as shown below

Add (Send) TextBox Values to ListBox in ASP.Net on Button Click using C#, VB.NET

Introduction:

Here I will explain how to add or send textbox values to listbox in asp.net  on button click using c#, vb.net or bind textbox values to listbox on button click in asp.net using c#, vb.net with example.

Description:

In previous post I explained convert currency or numbers to words in asp.net, angularjs bind dropdownlist with text and value, jQuery tag cloud example in asp.net, sitemap control example, send html page as mail body in asp.net, how to send mail with attachment in asp.net and many more articles related to asp.net using c#, vb.net. Now I will explain how to add or send textbox values to listbox in asp.net  on button click using c#, vb.net with example.