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 ...
The GridView control in Asp.Net can be used to display large data in a tabular format. This is a topic which we have discussed earlier. Here in this article we will show you how a GridView control can ...
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 ...
As a programmer we have all had access to databases and an instinct to fetch data from it. So we started looking for means to achieve it. SQL JOINS are one of those means which allows us to fetch a ...
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 ...
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 ...
Dropdown menus in a website is 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 contents of a ...
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 the SqlDataSource, which allows web controls to ...
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 ...
Data in an Excel file can be manipulated using Vb.Net without even opening the file. With few steps this can be done. Previously we have created Excel file from Vb.Net with auto formating technique ...