18 Oct 2014
0 Comments   231 Views
Here Mudassar Ahmed Khan has explained how to import data from Excel file’s sheet and display in DataGridView control in Windows Forms (WinForms) application using C# and VB.Net.

The Excel sheet data will be read into a DataTable which is then used to populate the DataGridView control.
15 Oct 2014
1 Comments   791 Views
Here Mudassar Ahmed Khan explained how to generate Mashape API key. Readers of this site are unable to create Mashape API keys and use it for Sending Free SMS from ASP.Net and hence he decided to write a short article explaining the same.
14 Oct 2014
0 Comments   429 Views
Here Mudassar Ahmed Khan has explained how to export DataGridView data to Excel file in Windows Forms (WinForms) Applications using OpenXml and ClosedXml Excel conversion libraries, C# and VB.Net.

DataGridView cannot be exported directly to Excel file and hence need to generate a DataTable and export the DataTable to Excel file.
13 Oct 2014
0 Comments   757 Views
Here Mudassar Khan has explained how to insert data in GridView without using database in ASP.Net using C# and VB.Net.

Multiple Rows and columns will be added to GridView with the help of DataTable in ViewState or Session thus the GridView is populated without using database.
11 Oct 2014
0 Comments   823 Views
Here Mudassar Ahmed Khan has explained how to display data from database in HTML Table in ASP.Net using C# and VB.Net.
11 Oct 2014
0 Comments   734 Views
Here Mudassar Ahmed Khan has explained how to populate GridView using WCF service or in other words bind data to GridView using WCF Service in ASP.Net using C# and VB.Net.
08 Oct 2014
0 Comments   1009 Views
Here Mudassar Ahmed Khan has explained how to add Watermark text to Images / Photos dynamically on the fly in ASP.Net using C# and VB.Net.

The Watermark text will be dynamically created on the Image / Photo with the help of Graphics Library of .Net.
08 Oct 2014
0 Comments   902 Views
Here Mudassar Ahmed Khan has explained how to display data of DataTable as HTML Table in ASP.Net using C# and VB.Net.
04 Oct 2014
0 Comments   850 Views
Here Mudassar Ahmed Khan has explained how to validate Terms and conditions CheckBox using JavaScript and CustomValidator in ASP.Net.
03 Oct 2014
0 Comments   952 Views
Here Mudassar Ahmed Khan has explained how to import / upload CSV file data to SQL Server database in ASP.Net using C# and VB.Net.

The CSV file data will be inserted into SQL Server database table using the SqlBulkCopy class.
03 Oct 2014
1 Comments   952 Views
Here Mudassar Ahmed Khan has explained how to copy data from Excel file or Clipboard and paste it to GridView in ASP.Net using C# and VB.Net.

We cannot paste the copied data from Excel file or Clipboard to GridView and hence we need to paste the data to an ASP.Net Multiline TextBox or TextArea and then populate GridView.
01 Oct 2014
0 Comments   1148 Views
Here Mudassar Ahmed Khan has explained how to perform select, insert, edit, update, delete in GridView using MySQL database in ASP.Net using C# and VB.Net.

This process is also known as CRUD i.e. Create, Read, Update and Delete in GridView with MySQL database backend in ASP.Net.
28 Sep 2014
1 Comments   1599 Views
Here Mudassar Ahmed Khan has explained how to use Google Chart APIs with database in ASP.Net using C#, VB.Net and jQuery.

In this example he has populated Pie chart, 3D Pie chart and Doughnut chart from database using jQuery AJAX and WebMethods in ASP.Net.
26 Sep 2014
0 Comments   783 Views
Here Mudassar Ahmed Khan has explained how to get the address from Latitude and Longitude using Google Maps V3.
26 Sep 2014
1 Comments   782 Views
Here Mudassar Ahmed Khan has explained how to use and connect to MySQL database in ASP.Net application with the help of MySQLConnector using C# and VB.Net.
26 Sep 2014
0 Comments   609 Views
Here Mudassar Ahmed Khan has explained how to use and connect to MySQL database in ASP.Net application with the help of MySQLConnector using C# and VB.Net.
25 Sep 2014
0 Comments   721 Views
Here Mudassar Ahmed Khan has explained DataKeyNames in GridView with example in ASP.Net.
25 Sep 2014
0 Comments   772 Views
Here Mudassar Ahmed Khan has explained how to export data (records) from GridView to Text (Notepad) file in ASP.Net using C# and VB.Net.

A loop will be executed over the GridView rows to generate a concatenated string which finally is exported to a Text file which can be viewed in Notepad.
24 Sep 2014
0 Comments   871 Views
Here Mudassar Ahmed Khan has explained how to export data (records) from SQL Server Table to Text (Notepad) file in ASP.Net using C# and VB.Net. This article will work for all SQL Server versions i.e. 2005, 2008, 2008R2, 2012, etc.

The data will be first fetched into a DataTable and then the DataTable will be exported to a Text file which can be viewed in Notepad.
24 Sep 2014
0 Comments   694 Views
Here Mudassar Ahmed Khan has explained how to export data (records) from SQL Server Table to CSV file in ASP.Net using C# and VB.Net. This article will work for all SQL Server versions i.e. 2005, 2008, 2008R2, 2012, etc.

The data will be first fetched into a DataTable and then the DataTable will be exported to a CSV file.
24 Sep 2014
0 Comments   956 Views
Here Mudassar Ahmed Khan has explained how to export data (records) from SQL Server Table to Excel file in ASP.Net using C# and VB.Net. This article will work for all SQL Server versions i.e. 2005, 2008, 2008R2, 2012, etc.

The data will be first fetched into a DataTable and then the DataTable will be exported into an Excel Sheet using OpenXml and ClosedXml Excel libraries.
19 Sep 2014
0 Comments   2021 Views
Here Mudassar Ahmed Khan has explained with an example, how to use / apply / set / enable / implement paging in DataList control in ASP.Net.

DataList control by default does not have paging (pagination) enabled hence we need to write custom stored procedure as well as develop a custom pager control in order to use / apply / set / enable / implement paging in DataList control in ASP.Net
18 Sep 2014
0 Comments   2522 Views
Here Mudassar Ahmed Khan explained how to insert comma separated / delimited values in a table in SQL Server using Split function.
18 Sep 2014
0 Comments   2341 Views
Here Mudassar Ahmed Khan explained how to split and convert a comma separated / delimited string to a table in SQL Server using Split function.
17 Sep 2014
0 Comments   1108 Views
Here Mudassar Ahmed Khan has explained with some examples, how to get value of DataKeyNames (DataKeys) in RowCommand and RowDataBound events of ASP.Net GridView using C# and VB.Net.