Here Mudassar Ahmed Khan has explained with example how to perform select, insert, edit, update, delete in Repeater control in ASP.Net using C# and VB.Net.
This process is also known as CRUD i.e. Create, Read, Update and Delete in Repeater control with SQL Server database backend in ASP.Net.
Here Mudassar Ahmed Khan has explained with an example, how to populate (bind) Repeater control using Stored Procedure in ASP.Net using C# and VB.Net.
Repeater will be populated using Stored Procedure in SQL Server database and will be displayed as HTML table on the page.
0 Comments   689 Views
Here Mudassar Ahmed Khan has explained with an example, how to bind (populate) Repeater control with JSON object using jQuery AJAX in ASP.Net using C# and VB.Net.
Using jQuery AJAX and WebMethod, the records will be fetched from database into a Generic list of property class object which will be received as JSON object on Client Side and then that JSON object will be used to populate the ASP.Net Repeater on Client Side using jQuery.
Here Mudassar Ahmed Khan has explained with an example, how to return value True if record exists and value False when record does not exist from Stored Procedure in SQL Server.
In order to return value the EXEC function will be used. The value will be returned as 1 (True) if record exists and 0 (False) is record does not exists.
Using the EXEC function returning value of a Stored Procedure to a variable is supported in all SQL Server versions i.e. 2000, 2005, 2008, 2008R2, 2012, 2014 or higher.
Here Mudassar Ahmed Khan has explained with an example, how to execute a Stored Procedure that Returns value and assign its returned value to a variable in SQL Server.
Using the EXEC function returning value of a Stored Procedure to a variable is supported in all SQL Server versions i.e. 2000, 2005, 2008, 2008R2, 2012, 2014 or higher.
Here Mudassar Ahmed Khan has explained with an example, how to return result value of EXEC function and save it to a variable in SQL Server.
The EXEC function supports returning value to a variable is supported in SQL Server versions i.e. 2000, 2005, 2008, 2008R2, 2012, 2014 or higher.
Here Mudassar Ahmed Khan has explained with an example, how to return JSON data from a Generic Handler in ASP.Net using C# and VB.Net.
The Generic HTTP Handler will pull records from database and return the records in JSON format to the client.
Here Mudassar Ahmed Khan has explained with an example, how to create a Generic HTTP Handler in ASP.Net that returns JSON data.
The Generic HTTP Handler will pull records from database and return the records in JSON format to the client.
Here Mudassar Ahmed Khan has explained with an example, how to prevent the Selected Item Value of ASP.Net DropDownList from getting Lost / Cleared / Reset on PostBack when the Submit button is clicked.
0 Comments   939 Views
Here Mudassar Ahmed Khan has explained the customError setting in the Web.Config file of ASP.Net application, how it works, what is its use and what are the different modes of the customError setting in the Web.Config file of ASP.Net application.
The customError setting in the Web.Config file has three modes Off, On and RemoteOnly.
Here Mudassar Ahmed Khan has explained how to resolve the following error message occurring in ASP.Net website or web application when it is hosted on a remote in IIS server.
An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.
0 Comments   1974 Views
Here Mudassar Ahmed Khan has explained with an example, how to display multiple data Fields (Columns) in GridView BoundField in ASP.Net.
By default, the BoundField column of GridView does not allow to show multiple data Fields (Columns), thus the solution is to use TemplateField or using the RowDataBound event, multiple data Fields (Columns) can be displayed in BoundField column of GridView.
Here Mudassar Ahmed Khan has explained with an example, how to bind (populate) GridView using DataSet in ASP.Net using C# and VB.Net.
DataSet is a collection of DataTables and is capable to hold data from multiple tables. Thus multiple GridViews will be populated using a single DataSet in ASP.Net.
Here Mudassar Ahmed Khan has explained with an example, how to fill (populate) DataSet with records of multiple Tables in ASP.Net using C# and VB.Net.
DataSet is a collection of DataTables and is capable to hold data from multiple tables. In order to fill (populate) DataSet with records of multiple Tables, multiple Select queries needs to be executed simultaneously.
0 Comments   1632 Views
Here Mudassar Ahmed Khan has explained with an example, how to export multiple DataTables of a DataSet to multiple Excel Sheets (Worksheets) in ASP.Net using C# and VB.Net.
Records of each DataTable in the DataSet will be exported to a different Sheet (Worksheet) of an Excel file using ClosedXml library in ASP.Net.
0 Comments   2014 Views
Here Mudassar Ahmed Khan has explained with an example, how to export GridView data to multiple Sheets (Worksheets) of same Excel file in ASP.Net using C# and VB.Net.
Records of each page of GridView with paging enabled will be exported to a different Excel sheets (worksheets) using ClosedXML and OpenXml Libraries.
Here Mudassar Ahmed Khan has explained how to install Windows Service build in C# or VB.Net on a Remote Server Machine using <>InstallUtil.exe file.
In order to install the Windows Service on a Remote Server Machine, first task is to locate the InstallUtil.exe file.
Here Mudassar Ahmed Khan has explained with an example, how to export DataTable to Excel using OpenXml and ClosedXml Excel conversion libraries in Windows Forms (WinForms) Applications using C# and VB.Net.
Here Mudassar Ahmed Khan has explained with an example, how to populate (bind) ASP.Net DropDownList using Array (ArrayList) in C# and VB.Net.
A For Loop will be executed over an ArrayList (Array) and one by one each item of the ArrayList will be added to the ASP.Net DropDownList.
Here Mudassar Ahmed Khan has explained with an example, how to add (insert) item in ASP.Net DropDownList using For Loop in C# and VB.Net.
A For Loop will be executed over an ArrayList (Array) and one by one each item of the ArrayList will be added to the ASP.Net DropDownList.
0 Comments   1432 Views
Here Mudassar Ahmed Khan has explained with an example, how to add item at Index 0 (First position) in ASP.Net DropDownList that already contains items (data) using C# and VB.Net.
0 Comments   1445 Views
Here Mudassar Ahmed Khan has explained with an example, how to add default (insert) Blank (Empty) item to DataBound DropDownList populated from Database in ASP.Net Code Behind using C# and VB.Net.
Generally we want to have a default selected item such as Please Select with Blank (Empty) value. This article will explain how to add such Blank (Empty) item in Code Behind when DropDownList is populated from database.
Here Mudassar Ahmed Khan has explained a tutorial with example on how to use the ASP.Net DropDownList control and populate it from database using SqlDataSource in ASP.Net.
Here Mudassar Ahmed Khan has explained with an example, how to populate (bind) DropDownList control using SqlDataSource in ASP.Net.
Here Mudassar Ahmed Khan has explained a tutorial with an example, how to use the ASP.Net DataList control for displaying data (records) from database using SqlDataSource control.