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...

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 ...

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...

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...

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...

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...

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.

Continue reading...

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...

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...

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...