You can define connection string in your code just before you want to connect to a database. So whenever you want to connect to a database, you can define it connection string and establish your connection. But if you want to use same connection in different places then you have to define a connection...
Read more →It is a great comfort for a user to be mouseless while navigating between web pages. They need shortcut keys to go to other page and also to do something on the current page. Keyboard shortcuts are easy to implement using jQuery in ASP.NET. Let’s take a look how we can achieve this task....
Read more →In Web Applications DataGrid is commonly used to display data and in the same way DataGridView control is used in Windows application. Initially, GridView was not there in WPF and it was used from WPF Toolkit but .NET frameword 4.0 has come with WPF DataGrid. This article is all about using WPF DataGrid. DataGrid...
Read more →I have explained in one of my previous articles that how to export data from DataTable to Excel C#. We also need data from excel and we might need it in DataTable so this article will explain how we can get data from Excel to DataTable C#. Well, the process of C# Excel to...
Read more →What is DataSet? A DataSet is an in-memory representation of data. It represents cache of data retrieved from database. DataSet is a disconnected architecture that means we only need connection with database for small amount of time to fill DataSet and close connection. Now we can manipulate data from DataSet without any connection to...
Read more →Getting GridView cell values using jQuery in ASP.NET is so simple. Let me show you how easily we can achieve it. Download any jQuery stable version and add to your project. Don’t forget to give reference to you jQuery file. Add a GridView, button and a label. Bind your GridView with data...
Read more →Auto increment identity column automatically insert record Id with the specified incremental value. Several times we need to get the last inserted record id. There are several ways to achieve this task. Let’s take a look how we can get last inserted record/row id value. @@IDENTITY Most common and important method used to get...
Read more →This is a series of articles about reading text files and the first article is about to read text file one line at a time. You can use ReadLine() method of StreamReader class to read line by line from a text file. StreamReader class actually has four methods to read text files. I will...
Read more →I have briefly explained in my previous article what web service is and how to create it and I have also explained how we can consume this web service. This article will explain how to consume web service using jQuery. jQuery is a JavaScript library that is used for less and simple JavaScript coding....
Read more →In this tutorial, we’ll show you 8 keyboard shortcuts for Windows 8 to become a power user and use the Windows 8 more efficiently and effectively. You can also watch the video to see these shortcuts in action. Windows Key + X shows context menu for Task Manager, Control Panel, File Explorer, Search and...
Read more →