18 Sep 2018 18 Sep 2018 0 Comments  4 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement Grouped DropDownList using HTML OptGroup element in ASP.Net MVC Razor.

The Grouped DropDownList will be populated from database using Entity Framework in ASP.Net MVC Razor.

In HTML DropDownList OptGroup element, which is used to Group items (options) of a DropDownList while in MVC, the Grouping of DropDownList items (options) is done using SelectListItem class and SelectListGroup class.
18 Sep 2018 18 Sep 2018 0 Comments  16 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement RadioButton Group using Html.RadioButton Helper method in ASP.Net MVC Razor.

The RadioButtons will be populated from Database by looping through the Model.

The RadioButtons are grouped by specifying common name for all RadioButtons in ASP.Net MVC Razor.
18 Sep 2018 18 Sep 2018 0 Comments  18 Views
Here Mudassar Ahmed Khan has explained with an example, how to solve the problem of jQuery Live Click not working and giving error Live is not a function.

jQuery Live function has been depreciated i.e. removed from jQuery version 1.9 onwards and hence when you are using any newer jQuery version i.e. version 1.9 or above you will get error that Live is not a function.
14 Sep 2018 14 Sep 2018 0 Comments  263 Views
Here Mudassar Ahmed Khan has explained with an example, how to move selected Items to Top of ListBox using jQuery.

When an Item (Option) is selected in the ListBox, it will be removed from the List and again added to the ListBox at 0th Index (First Position) using jQuery.
14 Sep 2018 14 Sep 2018 0 Comments  241 Views
Here Mudassar Ahmed Khan has explained with an example, how to move selected Items to Top of ListBox using JavaScript.

When an Item (Option) is selected in the ListBox, it will be removed from the List and again added to the ListBox at 0th Index (First Position) using JavaScript.
14 Sep 2018 14 Sep 2018 0 Comments  225 Views
Here Mudassar Ahmed Khan has explained with an example, how to download Excel file (XLS and XLSX) using jQuery.

The HTML Table data will be converted and downloaded to Excel file with the help of the jQuery table2excel plugin.
14 Sep 2018 14 Sep 2018 0 Comments  198 Views
Here Mudassar Ahmed Khan has explained with an example, how to download Excel file (XLS and XLSX) using JavaScript.

The HTML Table data will be converted and downloaded to Excel file with the help of the jQuery table2excel plugin.
14 Sep 2018 14 Sep 2018 0 Comments  193 Views
Here Mudassar Ahmed Khan has explained with an example, how to convert Excel (XLS and XLSX) file data to JSON using jQuery.

Once File is selected in FileUpload control, it is read as Binary data and then the Binary data is read using the xlsx Excel plugin which returns the Excel file data in JSON array format.

Finally, JSON array is displayed as HTML Table using jQuery.
14 Sep 2018 14 Sep 2018 0 Comments  208 Views
Here Mudassar Ahmed Khan has explained with an example, how to convert Excel (XLS and XLSX) file data to JSON using JavaScript.

Once File is selected in FileUpload control, it is read as Binary data and then the Binary data is read using the xlsx Excel plugin which returns the Excel file data in JSON array format.

Finally, JSON array is displayed as HTML Table using JavaScript.
14 Sep 2018 14 Sep 2018 0 Comments  201 Views
Here Mudassar Ahmed Khan has explained with an example, how to dismiss (close) Bootstrap Modal Popup programmatically.

Bootstrap has provided a function named modal to which when called with the parameter value hide, dismisses (closes) the Modal Popup.
14 Sep 2018 14 Sep 2018 0 Comments  241 Views
Here Mudassar Ahmed Khan has explained with an example, how to read Excel File (XLS and XLSX) using AngularJS and HTML5 File API.

The Excel file (XLS and XLSX) will be selected in HTML FileUpload element and will be read using HTML5 FileReader API.

The read data will be parsed into a JSON Array using the xlsx Excel plugin and later the JSON Array will be used to populate a HTML Table using ng-repeat directive in AngularJS.
12 Sep 2018 14 Sep 2018 0 Comments  279 Views
Here Mudassar Ahmed Khan has explained with an example, how to read CSV File using AngularJS and HTML5 File API.

The CSV file (Comma separated Text file) will be selected in HTML FileUpload element and will be read using HTML5 FileReader API.

The read data will be parsed into a JSON Array which will be later used to populate a HTML Table using ng-repeat directive in AngularJS.
12 Sep 2018 12 Sep 2018 0 Comments  230 Views
Here Mudassar Ahmed Khan has explained with an example, how to close (hide) Bootstrap Modal Popup Window using jQuery.

The Close Button is assigned a jQuery Click event handler and when the Close Button is clicked, the Bootstrap Modal Popup Window will be hidden (closed) using modal function and passing the parameter value hide.
11 Sep 2018 11 Sep 2018 0 Comments  264 Views
Here Mudassar Ahmed Khan has explained with an example, how to close (hide) Bootstrap Modal Popup Window from Server Side (Code Behind) in ASP.Net using C# and VB.Net.

The Bootstrap Modal Popup is closed (hidden) by calling the modal function with parameter value hide using RegisterStartupScript method of ClientScript class on Sever Side (Code Behind) in ASP.Net.
07 Sep 2018 07 Sep 2018 0 Comments  624 Views
Here Mudassar Ahmed Khan has explained with an example, how to get Client IP Address and Location in ASP.Net using C# and VB.Net.

First the IP Address of the Visitor will be determined and then using the IP Address and the IPInfoDB IP to Location API, the Client Geographic location details like Country, City, Region, Zip Code, Latitude, Longitude and Time zone will be determined in ASP.Net using C# and VB.Net.
07 Sep 2018 07 Sep 2018 0 Comments  367 Views
Here Mudassar Ahmed Khan has explained with an example, how to read the CSV File and convert its data to JSON Array in jQuery using HTML5 File API.

The CSV file (Comma separated Text file) will be selected in HTML5 FileUpload element and will be read using HTML5 FileReader API.

The read data is split into Rows and a loop is executed over the Rows and the data from each Row is stored into a JSON object and it is added to an Array using jQuery.
07 Sep 2018 07 Sep 2018 0 Comments  375 Views
Here Mudassar Ahmed Khan has explained with an example, how to send Email from Trigger in SQL Server.

This article will illustrate how to send email from Trigger using sp_send_dbmail Stored Procedure in SQL Server by using GMAIL SMTP settings.

This article is applicable to following SQL Server versions i.e. 2008, 2008R2, 2012, 2014, 2016 and 2017.
06 Sep 2018 06 Sep 2018 0 Comments  555 Views
Here Mudassar Ahmed Khan has explained with an example, how to send email in SQL Server using Stored Procedure.

This article will illustrate how to send email using sp_send_dbmail Stored Procedure in SQL Server by using GMAIL SMTP settings.

This article is applicable to following SQL Server versions i.e. 2008, 2008R2, 2012, 2014, 2016 and 2017.
05 Sep 2018 05 Sep 2018 1 Comments  513 Views
Here Mudassar Ahmed Khan has explained with an example, how to solve the problem of Bootstrap Modal Popup Auto Closes on PostBack in ASP.Net using C# and VB.Net.

Bootstrap Modal Popup is opened from Client Side and hence when PostBack happens and Page refreshes, the Bootstrap Modal Popup disappears.

Hence in order to keep the Bootstrap Modal Popup across PostBacks, it has to be re-opened after PostBack from Server Side (Code Behind) using RegisterStartupScript method of ClientScript class.
05 Sep 2018 05 Sep 2018 0 Comments  414 Views
Here Mudassar Ahmed Khan has explained with an example, how to Show and Hide (Open and Close) Bootstrap Modal Popup Window using jQuery.

There will be two Buttons i.e. first to show (open) the Bootstrap Modal Popup Window on Client Side using jQuery while second Button will be placed inside the Bootstrap Modal Popup Window and will be used to hide (close) the Bootstrap Modal Popup Window using jQuery.
05 Sep 2018 05 Sep 2018 0 Comments  292 Views
Here Mudassar Ahmed Khan has explained with an example, how to open (show) Bootstrap Modal Popup Window using jQuery.

The Button will be assigned a jQuery Click event handler. When the Button is clicked, the Bootstrap Modal Popup Window is opened (shown) on Client Side using jQuery.
05 Sep 2018 05 Sep 2018 0 Comments  439 Views
Here Mudassar Ahmed Khan has explained with an example, how to open (show) Bootstrap Modal Popup Window on Page Load in ASP.Net using C# and VB.Net.

Inside the Server Side Page Load event handler, the RegisterStartupScript method of ClientScript class is used to register a call to the JavaScript function which will open (show) Bootstrap Modal Popup Window on Client Side using jQuery.
05 Sep 2018 05 Sep 2018 0 Comments  399 Views
Here Mudassar Ahmed Khan has explained with an example, how to open (show) Bootstrap Modal Popup Window from Server Side (Code Behind) in ASP.Net using C# and VB.Net.

When the Button is clicked, the Server Side Button Click event handler is triggered in Code Behind and then using RegisterStartupScript method of ClientScript class, the Bootstrap Modal Popup Window is opened (shown) on Client Side using jQuery.
04 Sep 2018 04 Sep 2018 0 Comments  351 Views
Here Mudassar Ahmed Khan has explained with an example, how to embed (display) CSV File in Web Page (Browser) using JavaScript and HTML5 File API.

First the CSV file i.e. Comma separated Text file, will be read using HTML5 FileReader API as String.

Then the String will be parsed into Rows and Columns and will be displayed as HTML Table on Web Page in Browser.
04 Sep 2018 04 Sep 2018 0 Comments  269 Views
jQuery  HTML  HTML5  Table
Here Mudassar Ahmed Khan has explained with an example, how to import CSV File to HTML Table using jQuery and HTML5 File API.

First the CSV File i.e. Comma separated Text file, will be read using HTML5 FileReader API as String.

Then the String will be parsed into Rows and Columns and will be displayed in HTML Table.