18 Oct 2014
1 Comments   352 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   989 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   505 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   870 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   921 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   828 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   1090 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   943 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   906 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   1059 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   1025 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   1234 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   1693 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   841 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   834 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   633 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   760 Views
Here Mudassar Ahmed Khan has explained DataKeyNames in GridView with example in ASP.Net.
25 Sep 2014
0 Comments   813 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   930 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   744 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   1024 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   2154 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   2653 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   2502 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   1188 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.