Category - DataSet
Results 1 - 20 of 39
29 Jun 2021 29 Jun 2021 0 Comments  17387 Views
Here Mudassar Ahmed Khan has explained with an example, how to export DataSet or DataTable to Excel file in ASP.Net Core MVC.

The data from the database is fetched using ADO.Net into a DataTable.

Then the DataTable is exported and downloaded as Microsoft Excel file using ClosedXML Excel Library which is a wrapper for OpenXml Excel library.
28 Jun 2021 28 Jun 2021 0 Comments  13262 Views
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.
23 Mar 2020 23 Mar 2020 0 Comments  23785 Views
Here Mudassar Ahmed Khan has explained with an example, how to bind DataSet to RDLC Report in Windows Forms (WinForms) Application using C# and VB.Net.

The data from the Database will be loaded in a Typed DataSet which will be dynamically used to bind and populate the RDLC using Report Viewer in Windows Forms (WinForms) Application using C# and VB.Net.
19 Jun 2019 19 Jun 2019 0 Comments  15786 Views
Here Mudassar Ahmed Khan has explained with an example, how to bind (populate) ASP.Net CheckBoxList using DataTable (DataSet) in C# and VB.Net.

The data from the SQL Server Database Table will be fetched into a DataSet and then the DataTable of the DataSet will be used to bind (populate) ASP.Net CheckBoxList using C# and VB.Net.

This article will also illustrate how to fetch the selected values of ASP.Net CheckBoxList on Button Click using C# and VB.Net.
07 Mar 2019 07 Mar 2019 0 Comments  14906 Views
Here Mudassar Ahmed Khan has explained with an example, how to populate (bind) ListView using jQuery AJAX in ASP.Net with C# and VB.Net.

This article will illustrate how to populate ASP.Net ListView control from SQL Server Database on Client Side by calling WebMethod using jQuery AJAX in ASP.Net with C# and VB.Net.
29 Oct 2018 29 Oct 2018 0 Comments  13845 Views
Here Mudassar Ahmed Khan has explained with an example, how to filter Crystal Report in ASP.Net using C# and VB.Net.

Crystal Report data will be filtered on selection of DropDownList in ASP.Net.
12 Oct 2018 12 Oct 2018 0 Comments  21191 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.
22 Jun 2018 22 Jun 2018 0 Comments  7614 Views
Here Mudassar Ahmed Khan has explained with an example, how to populate (bind) WebGrid using ADO.Net in ASP.Net MVC Razor.

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 ultimately used to populate the WebGrid in ASP.Net MVC Razor.
22 Jun 2018 22 Jun 2018 0 Comments  6866 Views
Here Mudassar Ahmed Khan has explained with an example, how to bind (populate) WebGrid using dynamic DataTable (DataSet) in ASP.Net MVC Razor.

Inside the Controller, first a DataTable object is created with some dynamic Columns and then records are added to the DataTable.

Finally the DataTable is added to a DataSet which is later used to populate the WebGrid in ASP.Net MVC Razor.
30 May 2018 30 May 2018 0 Comments  25587 Views
Here Mudassar Ahmed Khan has explained with an example, how to populate Bar and Column Charts from database using ASP.Net Chart control in C# and VB.Net.
30 May 2018 30 May 2018 0 Comments  25525 Views
Here Mudassar Ahmed Khan has explained with an example, how to bind DataTable (DataSet) to Chart control in ASP.Net using C# and VB.Net.
21 Feb 2018 21 Feb 2018 0 Comments  17046 Views
Here Mudassar Ahmed Khan has explained with an example, how to bind DataTable (DataSet) to WebGrid in ASP.Net MVC Razor.

By default, WebGrid does not accept DataSet (DataTable) as source of data and hence the DataSet (DataTable) needs to be converted to Dynamic Anonymous Type collection using LINQ and then used for populating WebGrid in ASP.Net MVC Razor.
10 Nov 2017 10 Nov 2017 0 Comments  29482 Views
Here Mudassar Ahmed Khan has explained with an example, how to display (show) GridView data in RDLC report in ASP.Net using C# and VB.Net.

When the Button is clicked, the data from the rows of the GridView for which the CheckBox is checked (selected) will be copied to the Typed DataSet object and then the object of the Typed DataSet will be used to populate the RDLC report.
25 Oct 2017 25 Oct 2017 0 Comments  17283 Views
Here Mudassar Ahmed Khan has explained with an example, how to bind multiple GridViews using one single DataSet in ASP.Net using C# and VB.Net.

The records returned from multiple SELECT queries (statements) are populated into DataTables and then these DataTables will be inserted into a DataSet and finally the DataSet is used to populate multiple GridViews in ASP.Net.
22 Sep 2017 22 Sep 2017 0 Comments  44887 Views
Here Mudassar Ahmed Khan has explained with an example, how to use the LINQ to select multiple records from DataTable in C# and VB.Net.

The LINQ select query will be used to fetch multiple records from DataTable in C# and VB.Net.
22 Sep 2017 22 Sep 2017 0 Comments  76206 Views
Here Mudassar Ahmed Khan has explained with an example, how to use the LINQ to select multiple columns from DataTable in C# and VB.Net.
22 Sep 2017 22 Sep 2017 0 Comments  99834 Views
Here Mudassar Ahmed Khan has explained with an example, how to use the LINQ select query on DataTable in C# and VB.Net.

The LINQ select query will be used to fetch records from DataTable in C# and VB.Net.
22 Sep 2017 22 Sep 2017 0 Comments  104505 Views
Here Mudassar Ahmed Khan has explained with an example, how to use the LINQ to select specific columns from DataTable in C# and VB.Net.
22 Sep 2017 22 Sep 2017 0 Comments  88442 Views
Here Mudassar Ahmed Khan has explained with an example, how to use the LINQ WHERE clause with DataTable in C# and VB.Net.

The LINQ WHERE clause is used to filter records of the DataTable in C# and VB.Net.
22 Sep 2017 22 Sep 2017 0 Comments  35577 Views
Here Mudassar Ahmed Khan has explained with an example, how to filter DataTable (DataSet) based on Column value using LINQ in ASP.Net, C# and VB.Net.

Actually it’s the DataTable inside the DataSet which can be filtered based on Column value using the LINQ WHERE clause in C# and VB.Net and hence this article is applicable for both DataTables and DataSets.
Results 1 - 20 of 39