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