19 Oct 2018 19 Oct 2018 0 Comments  76 Views
Here Mudassar Ahmed Khan has explained with an example, how to export Crystal Report to PDF programmatically in ASP.Net with C# and VB.Net.

Exporting Crystal Report to PDF programmatically means, exporting from Code-Behind without using the CrystalReportViewer control in ASP.Net.
19 Oct 2018 19 Oct 2018 0 Comments  66 Views
Here Mudassar Ahmed Khan has explained with an example, how to export Crystal Report to Word, Excel, PDF and CSV in Windows Forms (WinForms) Application using C# and VB.Net.

The Crystal Report will be populated using Typed DataSet in Windows Forms (WinForms) Application using C# and VB.Net.
17 Oct 2018 17 Oct 2018 0 Comments  252 Views
Here Mudassar Ahmed Khan has explained with an example, how to export Crystal Report and download in Word, Excel, PDF and CSV file formats in ASP.Net MVC Razor.

Entity Framework will be used to populate Crystal Reports from SQL Server database in ASP.Net MVC 5 Razor.
16 Oct 2018 16 Oct 2018 0 Comments  306 Views
Here Mudassar Ahmed Khan has explained with an example, how to display (embed) Excel Sheet on Web Page in ASP.Net using C# and VB.Net.

The Excel Sheet will be displayed (embedded) on Web Page with the help of IFRAME and Google Document Viewer in ASP.Net.
16 Oct 2018 16 Oct 2018 0 Comments  349 Views
ASP.Net  HTML  Email  Gmail
Here Mudassar Ahmed Khan has explained with an example, how to send Email using HTML Templates in ASP.Net with C# and VB.Net.

HTML Template is nothing but an HTML File whose contents will be read, modified and sent as Email.

HTML Templates are used to send newsletters and promotional emails. Such emails contain Rich Text content, images and animations.
12 Oct 2018 12 Oct 2018 0 Comments  387 Views
Here Mudassar Ahmed Khan has explained with an example, how to upload, read and display Excel file data using WebGrid in ASP.Net MVC Razor.

The uploaded Excel file data will be read using OLEDB library into a DataSet and then the DataSet will be used to populate WebGrid in ASP.Net MVC Razor.
11 Oct 2018 11 Oct 2018 0 Comments  410 Views
Here Mudassar Ahmed Khan has explained with examples, different ways to disable ViewState in ASP.Net.

ViewState can be disabled at the following levels:
1. Control Level.
2. Page Level.
3. Application Level.

This article will also explain how to completely remove the ViewState Hidden Field from the Page.
11 Oct 2018 11 Oct 2018 0 Comments  360 Views
Here Mudassar Ahmed Khan has explained what is ViewState in ASP.Net. This article will also cover the following information about ViewState: -

1. Where and how does ViewState store data.
2. Scope of ViewState.
3. Uses of ViewState.
4. Benefits of ViewState.
5. Disadvantages of ViewState.
10 Oct 2018 10 Oct 2018 0 Comments  322 Views
Here Mudassar Ahmed Khan has explained with an example, how to hide WebGrid Header Row in ASP.Net MVC Razor.

The Header Row will be hidden by setting displayHeader property to False in the GetHtml method of WebGrid in ASP.Net MVC Razor.
09 Oct 2018 09 Oct 2018 0 Comments  395 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement WebGrid with dynamic Columns in ASP.Net MVC Razor.

The list of Column names will be extracted from the Entity model using Reflection and will be used to create a List collection of WebGridColumn class.

The List collection of WebGridColumn class will be set in ViewBag object which will be later used in View to populate WebGrid with dynamic Columns in ASP.Net MVC Razor.
08 Oct 2018 08 Oct 2018 0 Comments  474 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement Column Wise search and filter in WebGrid using TextBox in ASP.Net MVC Razor.

An additional Header Row with TextBoxes for each Column will be inserted in WebGrid using jQuery and then the jQuery QuickSearch Plugin will be applied to each TextBox.

The jQuery QuickSearch Plugin will enable searching and filtering in WebGrid on KeyPress event of TextBoxes in ASP.Net MVC Razor.
05 Oct 2018 05 Oct 2018 0 Comments  547 Views
Here Mudassar Ahmed Khan has explained with an example, how to populate (bind) DropDownList using Stored Procedure in ASP.Net MVC Razor.

The records from the database will be fetched using Stored Procedure and populated into a Generic List collection of Model class objects and then will be saved into a ViewBag object.

Inside the View, the ViewBag object will be passed to the Html.DropDownList Helper function for populating the DropDownList in ASP.Net MVC Razor.
05 Oct 2018 05 Oct 2018 0 Comments  576 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement CRUD operations without using Entity Framework in ASP.Net MVC Razor.

This article will illustrate how to implement CRUD operations i.e. Select, Insert, Edit, Update and Delete using ADO.Net in ASP.Net MVC Razor.
05 Oct 2018 05 Oct 2018 0 Comments  515 Views
Here Mudassar Ahmed Khan has explained with an example, how to create Dynamic Google Bar Chart in ASP.Net using C# and VB.Net.

The Google Bar Chart will be dynamically populated from Database using jQuery AJAX and Web Method in ASP.Net.
04 Oct 2018 04 Oct 2018 0 Comments  514 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement Date of Birth (Age) Validation using Regular Expressions (Regex) in JavaScript.

There will be two types of Validations:
1. Date format dd/MM/yyyy validation: The Date of Birth (DOB) will be first validated for dd/MM/yyyy format using Regular Expression (Regex).
2. 18+ Minimum Age validation: The difference between the age entered in the TextBox and the Current Date is minimum 18 years.
04 Oct 2018 04 Oct 2018 0 Comments  675 Views
Here Mudassar Ahmed Khan has explained with an example, how to import Excel data to SQL Server Database using Stored Procedure in ASP.Net using C# and VB.Net.

The Excel file will be first uploaded and copied to a folder on Server. Then using Stored Procedure and OLEDB, the data from Excel file will be read and imported into SQL Server Database Table.
04 Oct 2018 04 Oct 2018 0 Comments  443 Views
Here Mudassar Ahmed Khan has explained with an example, how to import Excel data to SQL Server Database in ASP.Net using C# and VB.Net.

The Excel Sheet data will be read into a DataTable and then then DataTable data will be imported into SQL Server Database using SqlBulkCopy in ASP.Net.
04 Oct 2018 04 Oct 2018 0 Comments  353 Views
Here Mudassar Ahmed Khan has explained with an example, how to validate Date in dd/MM/yyyy format using Regular Expression (Regex) in JavaScript.

There will be two types of Validations:
1. Date format dd/MM/yyyy validation: The Date of Birth (DOB) will be first validated for dd/MM/yyyy format using Regular Expression (Regex).
2. 18+ Minimum Age validation: The difference between the age entered in the TextBox and the Current Date is minimum 18 years.
03 Oct 2018 03 Oct 2018 0 Comments  437 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement Scroll to Top and Bottom of Page with UP and DOWN Arrow Keys using plain jQuery and no additional jQuery Plugins.

The HTML Body element will be assigned jQuery KeyDown event handler and when the UP or DOWN Arrow Keys are detected, the Page will be smooth scrolled to Top or Bottom using jQuery.

In order to make the Scroll action smooth, jQuery animation has been used.
02 Oct 2018 02 Oct 2018 0 Comments  578 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement Nested WebGrid with Expand Collapse in ASP.Net MVC Razor.

The Nested WebGrid will be a combination of Parent – Child Table where Child WebGrid will be placed inside the Parent WebGrid and the Child WebGrid will be shown and hidden using Expand-Collapse feature in ASP.Net MVC Razor.

The Nested WebGrid will be populated from database using Entity Framework and the Expand-Collapse feature will be implemented using jQuery.
01 Oct 2018 01 Oct 2018 0 Comments  511 Views
Here Mudassar Ahmed Khan has explained with an example, how to make the ListView Scrollable i.e. Freezed or Fixed ListView Header Row and add a vertical Scrollbar for scrolling the Data rows in ASP.Net using C# and VB.Net.

The ListView will be displayed as HTML Table and the Header will be freezed (fixed) and Data rows will be made Scrollable using the ASPSnippets Scrollable Table jQuery Plugin.
01 Oct 2018 01 Oct 2018 0 Comments  502 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement Nested HTML Table with Expand Collapse in ASP.Net MVC Razor.

The Nested HTML Table will be a combination of Parent – Child Table where Child Tables will be placed inside the Parent Table and the Child Table will be shown and hidden using Expand-Collapse feature in ASP.Net MVC Razor.

The Nested Tables will be populated from database using Entity Framework and the Expand-Collapse feature will be implemented using jQuery.
21 Sep 2018 21 Sep 2018 0 Comments  728 Views
Here Mudassar Ahmed Khan has explained with an example, how to populate TreeView from Database in Windows Forms (WinForms) Application using C# and VB.Net.

This article will illustrate how to use Recursion i.e. recursively call the same function to add Parent and Child Nodes to the TreeView control.
21 Sep 2018 30 Sep 2018 0 Comments  538 Views
Here Mudassar Ahmed Khan has explained with an example, how to make TreeView Node not Clickable in ASP.Net with C# and VB.Net.

This article will illustrate how to make TreeView Node not Clickable in ASPX page as well as from Code-Behind in ASP.Net.
21 Sep 2018 21 Sep 2018 0 Comments  687 Views
Here Mudassar Ahmed Khan has explained with an example, how to populate TreeView from Database using Recursion in ASP.Net with C# and VB.Net.

First the data from database will be fetched into a DataTable and the Nodes will be added to the TreeView and if the Node has children then the child Nodes will be added through Recursion i.e. by recursively calling the same function.