ADO.Net Articles

Category - ADO.Net

03 Jan 2023 Mudassar Khan 0 Comments 3371 Views

ASP.Net ADO.Net SQL Server Entity Framework MVC Web API Core

Here Mudassar Khan has explained with an example, how to use Web API without Entity Framework in ASP.Net Core MVC.

This article makes use of ADO.Net as an alternative to Entity Framework for connecting Web API to SQL Server database.

03 Jan 2023 Mudassar Khan 0 Comments 1242 Views

ASP.Net ADO.Net SQL Server Entity Framework MVC Web API

Here Mudassar Khan has explained with an example, how to use Web API without Entity Framework in ASP.Net MVC.

This article makes use of ADO.Net as an alternative to Entity Framework for connecting Web API to SQL Server database.

09 Dec 2022 Mudassar Khan 0 Comments 2085 Views

ASP.Net ADO.Net SQL Server Core Razor Pages

Here Mudassar Khan has explained with an example, how to display data from Database using ADO.Net in ASP.Net Core Razor Pages.

09 Dec 2022 Mudassar Khan 0 Comments 1204 Views

ASP.Net ADO.Net SQL Server MVC Core

Here Mudassar Khan has explained with an example, how to display data from Database using ADO.Net in ASP.Net Core MVC.

09 Dec 2022 Mudassar Khan 0 Comments 1249 Views

ASP.Net ADO.Net SQL Server MVC

Here Mudassar Khan has explained with an example, how to display data from Database using ADO.Net in ASP.Net MVC.

09 Dec 2022 Mudassar Khan 0 Comments 2326 Views

ASP.Net ADO.Net DataTable DataSet Model Core Razor Pages

Here Mudassar Khan has explained with an example, how to use a DataSet or DataTable as Model in Razor Page in ASP.Net Core Razor Pages.

Though it is not a good practice to use to use DataSet or DataTable as Model in Razor Page in Core architecture, thus user’s please make a note that this is just an informative article and does not recommend to use DataSet or DataTable as Model in ASP.Net Core Razor Pages.

07 Dec 2022 Mudassar Khan 0 Comments 1443 Views

ASP.Net ADO.Net SQL Server DataTable DataSet WebGrid Core Razor Pages

Here Mudassar Khan has explained with an example, how to bind DataTable (DataSet) to WebGrid in ASP.Net Core Razor Pages.

The DataTable (DataSet) will be populated from Database Table using ADO.Net and then, used for populating WebGrid in ASP.Net Core Razor Pages.

07 Dec 2022 Mudassar Khan 0 Comments 1063 Views

ASP.Net ADO.Net SQL Server DataTable DataSet MVC WebGrid Core

Here Mudassar Khan has explained with an example, how to bind DataTable (DataSet) to WebGrid in ASP.Net Core MVC.

The DataTable (DataSet) will be populated from Database Table using ADO.Net and then, used for populating WebGrid in ASP.Net Core MVC.

06 Dec 2022 Mudassar Khan 0 Comments 1091 Views

ASP.Net ADO.Net SQL Server DataTable DataSet SqlDataAdapter WebGrid Core Razor Pages

Here Mudassar Khan has explained with an example, how to populate (bind) WebGrid using ADO.Net in ASP.Net Core Razor Pages.

Inside the Razor PageModel, the records from the Database Table will be fetched using traditional ADO.Net method i.e. using SqlConnection, SqlCommand, SqlDataAdapter, etc.

The fetched records will be populated into a DataSet which will be used to populate the WebGrid in ASP.Net Core Razor Pages.

06 Dec 2022 Mudassar Khan 0 Comments 906 Views

ASP.Net ADO.Net SQL Server DataTable DataSet SqlDataAdapter MVC WebGrid Core

Here Mudassar Khan has explained with an example, how to populate (bind) WebGrid using ADO.Net in ASP.Net Core MVC.

Inside the Controller, the records from the Database Table will be fetched using traditional ADO.Net method i.e. using SqlConnection, SqlCommand, SqlDataAdapter, etc.

The fetched records will be populated into a DataSet which will be used to populate the WebGrid in ASP.Net Core MVC.

29 Jul 2021 Mudassar Khan 0 Comments 5557 Views

ASP.Net ADO.Net SQL Server Charts Google MVC Core

Here Mudassar Ahmed Khan has explained with an example, how to use, implement and populate Charts from database using Google Charts API in ASP.Net Core MVC.

This article will illustrate how to populate Pie and Doughnut Charts from database using the Google Charts API in ASP.Net Core MVC.

28 Jun 2021 Mudassar Khan 0 Comments 17018 Views

ASP.Net ADO.Net SQL Server DataTable DataSet MVC Core

Here Mudassar Ahmed Khan has explained with an example, how to use a DataSet or DataTable as Model in View in ASP.Net Core MVC.

Though it is not a good practice to use to use DataSet or DataTable as Model in View in MVC Core architecture, thus user’s please make a note that this is just an informative article and does not recommend to use DataSet or DataTable as Model in View in ASP.Net Core MVC.

27 May 2021 Mudassar Khan 0 Comments 23476 Views

ASP.Net ADO.Net AJAX SQL Server AJAX Control Toolkit DropDownList ComboBox

Here Mudassar Ahmed Khan has explained with an example, how to create DropDownList with TextBox that allows user to type in ASP.Net using C# and VB.Net.

This article will illustrate use of ASP.Net AJAX ComboBoxExtender populated from SQL Server Database in ASP.Net with C# and VB.Net.

27 May 2021 Mudassar Khan 1 Comments 36105 Views

ASP.Net ADO.Net AJAX SQL Server AJAX Control Toolkit DropDownList ComboBox

Here Mudassar Ahmed Khan has explained with an example, how to create Searchable DropDownList in ASP.Net using C# and VB.Net.

This article will illustrate use of ASP.Net AJAX ComboBoxExtender populated from SQL Server Database in ASP.Net with C# and VB.Net.

27 May 2021 Mudassar Khan 0 Comments 18232 Views

ASP.Net ADO.Net AJAX SQL Server AJAX Control Toolkit DropDownList ComboBox

Here Mudassar Ahmed Khan has explained with an example, how to implement AutoComplete DropDownList using AJAX in ASP.Net with C# and VB.Net.

This article will illustrate use of ASP.Net AJAX AutoCompleteExtender populated from SQL Server Database in ASP.Net with C# and VB.Net.

07 Apr 2021 Mudassar Khan 0 Comments 27965 Views

ASP.Net ADO.Net SQL Server CheckBox CheckBoxList Core Razor Pages

Here Mudassar Ahmed Khan has explained with an example, how to implement CheckBoxes (CheckBoxList) in ASP.Net Core Razor Pages.

Group of multiple CheckBoxes (CheckBoxList) will be populated from SQL Server Database by looping through the Model.

The CheckBoxes are grouped by specifying common name for all CheckBoxes, this helps fetching their values as a collection in the Request header.

31 Mar 2021 Mudassar Khan 0 Comments 23068 Views

ASP.Net ADO.Net CheckBox CheckBoxList MVC Form Core

Here Mudassar Ahmed Khan has explained with an example, how to pass (send) multiple CheckBox values from View to Controller in ASP.Net Core MVC.

The CheckBoxes will be populated from SQL Server database and when the Form is submitted, the values of all the CheckBoxes (Checked and Unchecked) will be sent to the Controller in ASP.Net Core MVC.

30 Mar 2021 Mudassar Khan 0 Comments 4884 Views

ASP.Net ADO.Net SQL Server RadioButtonList MVC Core

Here Mudassar Ahmed Khan has explained with an example, how to pass (send) RadioButton value from View to Controller in ASP.Net Core MVC.

The RadioButtons will be populated from SQL Server database and when the Form is submitted, the value of the selected (checked) RadioButton will be sent to the Controller in ASP.Net Core MVC.

14 Mar 2021 Mudassar Khan 0 Comments 24223 Views

ASP.Net ADO.Net SQL Server CheckBox CheckBoxList MVC Core

Here Mudassar Ahmed Khan has explained with an example, how to bind CheckBox (multiple CheckBoxes) using Model in ASP.Net Core MVC.

The generic list collection of Model class will be populated from Database inside Controller and then it will be used to populate the list of multiple CheckBoxes inside View in ASP.Net Core MVC.

14 Mar 2021 Mudassar Khan 0 Comments 16588 Views

ASP.Net ADO.Net SQL Server CheckBox CheckBoxList MVC Model

Here Mudassar Ahmed Khan has explained with an example, how to bind CheckBox (multiple CheckBoxes) using Model in ASP.Net MVC Razor.

The Database data will be populated in generic list collection of Model class and then the Model will be sent to the View where it will be bound to the CheckBox in ASP.Net MVC Razor.