Tuesday, April 30, 2013

Clear all textbox values inside a container using JQuery

JQuery has definitely made the lives of programmers easy in many ways. One of the features we will discuss in this article is how to clear values in all textboxesinside a container with just a click of a button, using JQuery. The container can be either a “DIV” a “Panel” or a “Table”.


$('#btClearAll').click(function() {     });


Continue reading...

Thursday, February 21, 2013

Multiple File Upload in Asp.Net

Microsoft’s .Net has a come a long way when it comes to uploading various types of files. With Asp.Net version 2.0, it has introduced the “FileUpload” server side control for the very first time. This has virtually simplified the file uploading process.

Continue reading...

Sunday, February 17, 2013

SQL Server – Saving changes is not permitted.

It can be annoying when you have installed a brand new software on your PC, and it refuses to function the way you expect it to.




Continue reading ...


Thursday, February 14, 2013

Asp.Net – How to do a Partial PostBack using UpdatePanel and ScriptManager Controls?

“Asynchronous Java and XML” also known as the “AJAX” has come a long way. It has always been very useful since the Classic ASP era. And it has definitely made web browsing very easy and thrilling.







Continue reading...

Tuesday, February 12, 2013

Asp.Net - How to Bind a DropDownList to a Database table in GridView?

An Asp.Net DropDownList control holds a collection of data which allows the user to select a single data from a drop down list. This control can either be used as standalone control on a web page or can be embedded in another control, like a GridView control.

Continue reading...

Saturday, February 9, 2013

Check if Any GridView Row With RadioButton is Selected Using JQuery.

We have used the GridView control in Asp.Net for various purposes in our projects, time and again for a long very time now. But we know that most of its features are available at the server side. Using JQuery we can do some useful validations at the client side on the GridView control.




Continue reading...

Monday, February 4, 2013

Copy Data from One DataGridView to Another in Vb.Net

Single row or multiple rows can be transferred from one DataGridView to another with help of few lines of code. Why would somebody do that? We have come across a situation where we had to upgrade details about existing records with new details without changing the original one.


Continue reading...

Friday, February 1, 2013


Bind and Show a ComboBox in a DataGridView Cell – Windows Application


DataGridView control is used to display data in tabular format. Its use is not limited to just displaying data, but it’s a perfect tool for doing data manipulation by binding it with a database. With its many useful features the DataGridView can be made to function like an Excel sheet.



Tuesday, January 22, 2013

Import data from Excel in Asp.Net


There are various ways to import data from an Excel file to a Sql Server database table. We can use either a “DataSet” to import data into a table or by using the “SqlBulkCopy” class available in the namespace System.Data.SqlClient.



Continue reading...

Tuesday, January 15, 2013

Export data to Excel in Asp.Net – All Excel versions

Data can be exported to other file formats using various ways. We are not talking about printing the data, but to export it to an excel file, word and even text files, so the files can be emailed or copied to any other source. One of most popular source is the Excel file and we have an example for doing that in Vb.Net.




Continue reading...

Friday, January 11, 2013

Joins in SQL Server

As a programmer we have all had access to databases and an instinct to fetch data from it. So we started looking for various means to achieve it. SQL JOINS are one of those means which allows us to fetch a combination of data from one or more tables in a database. An entire RDBMS (Relational Database Management System) relies on JOINS.


FULL OUTER JOIN





Continue reading...

Thursday, January 10, 2013

Create a PDF file using Crystal Report in Asp.Net

A Portable Document Format (PDF) file can be used for various purposes particularly for sharing data on the web. Following few steps, we can create a PDF file using Crystal Report in Asp.Net.




Continue reading...

Saturday, January 5, 2013

CSS Animated Dropdown Menu Without JavaScript

CSS (Cascading Style Sheets) has revolutionised web desiging with its great features. Styling the web pages took lot of effort before CSS came in, obviously with the help of mordern browsers. And it is definitely going to stay for a very long time.


Continue reading...

Wednesday, January 2, 2013

Dropdown Menu Using JavaScript.

Dropdown menus in a website are an important element when it comes to affective navigation of webpages. It is basically an encapsulation of many links which allow the users to browse the many pages and contents of a website. Web designers have always looked for user-friendly “Dropdown” menus and sub-menus.


Learn more...


Bind data with GridView using SqlDataSource in Asp.Net

Accessing a remote database in .Net is relatively simple as compared to what we did during the Classic ASP era. One of .Net’s most powerful controls is theSqlDataSource, which allows web controls to easily access the database and its objects. SqlDataSource can be bound with another popular and useful control, the GridView control.

Learn more about "SqlDataSource"

GridView – Highlight a row on mouse over using Asp.Net

Highlighting a GridView row is more than just to make it look good. It helps to identify and focus on a particular row, since the GridView shows many rows of data at a time.



Learn more about it.