Category - DataSet
Results 21 - 39 of 39
21 Sep 2017 21 Sep 2017 0 Comments  30298 Views
Here Mudassar Ahmed Khan has explained with an example, how to filter DataSet based on Column value using C# and VB.Net.

Actually it’s the DataTable inside the DataSet which will be filtered based on Column value using the DataTable.DefaultView.RowFilter property in C# and VB.Net.
27 Feb 2017 28 Jun 2021 2 Comments  42609 Views
Here Mudassar Ahmed Khan has explained with an example, how to display (show) DataSets and DataTables in Grid format in View in ASP.Net MVC Razor.

Though it is not a good practice to use DataSets and DataTables as Model in MVC architecture, hence user’s please make a note that this is just an informative article and does not recommend to use DataSets and DataTables in ASP.Net MVC Razor.
27 Feb 2017 28 Jun 2021 0 Comments  17634 Views
Here Mudassar Ahmed Khan has explained with an example, how to use DataSets and DataTables in ASP.Net MVC Razor.

Though it is not a good practice to use DataSets and DataTables as Model in MVC architecture, hence user’s please make a note that this is just an informative article and does not recommend to use DataSets and DataTables in ASP.Net MVC Razor.
27 Feb 2017 28 Jun 2021 0 Comments  25113 Views
Here Mudassar Ahmed Khan has explained with an example, how to pass (send) DataSet or DataTable from Controller to View in ASP.Net MVC Razor.

Though it is not a good practice to use DataSet or DataTable as Model and pass DataSet or DataTable from Controller to View in MVC architecture, hence user’s please make a note that this is just an informative article and does not recommend to pass (send) DataSet or DataTable from Controller to View in ASP.Net MVC Razor.
02 Feb 2017 28 Jun 2021 3 Comments  57979 Views
Here Mudassar Ahmed Khan has explained with an example, how to use a DataSet or DataTable as Model in View in ASP.Net MVC Razor.

Though it is not a good practice to use DataSet or DataTable as Model in View in MVC 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 MVC.
02 Aug 2016 02 Aug 2016 0 Comments  47571 Views
Here Mudassar Ahmed Khan has explained with an example, how to add (insert) multiple DataTables to a 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.
31 Mar 2016 31 Mar 2016 0 Comments  64962 Views
Here Mudassar Ahmed Khan has explained with an example, how to execute multiple SQL Queries in one Statement using C# and VB.Net.
This article will illustrate how two SELECT queries separated by semicolon character are executed simultaneously in one Statement using C# and VB.Net.
31 Mar 2016 31 Mar 2016 0 Comments  18669 Views
Here Mudassar Ahmed Khan has explained with an example, how to add (insert) multiple DataTables to a DataSet in ASP.Net using C# and VB.Net.
The DataTables will be populated with records of different Tables from Database and then will be inserted into a DataSet.
24 Feb 2016 24 Feb 2016 1 Comments  61069 Views
Here Mudassar Ahmed Khan has explained with an example, how to return DataSet (DataTable) from WebMethod (PageMethod) to JavaScript or jQuery in ASP.Net using C# and VB.Net.
In this example, the DataSet (DataTable) will be populated from database and it will be returned as XML string by the WebMethod (PageMethod) to jQuery AJAX function.
08 Jan 2016 08 Jan 2016 0 Comments  76249 Views
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.
08 Jan 2016 08 Jan 2016 0 Comments  56924 Views
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.
08 Jan 2016 08 Jan 2016 5 Comments  95730 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.
06 Oct 2015 06 Oct 2015 0 Comments  47264 Views
Here Mudassar Ahmed Khan has explained with an example, how to fill (populate) DataSet using SqlDataAdapter in C# and VB.Net.
30 Jul 2015 30 Jul 2015 0 Comments  51035 Views
Here Mudassar Ahmed Khan has explained with an example, how to populate ASP.Net Repeater client side by fetching DataSet or DataTable from server as XML using jQuery AJAX.
Using jQuery AJAX and WebMethod, the records will be fetched using DataSet received as XML string and then the XML string will be used to populate the ASP.Net Repeater on Client Side using jQuery.
25 Jul 2015 25 Jul 2015 0 Comments  105755 Views
Here Mudassar Ahmed Khan has explained with an example, how to populate (fill) DataTable and DataSet using DataReader (SqlDataReader) in C# and VB.Net.
The DataTable and DataSet will be populated with records from the DataReader using Load method of the DataTable.
12 Jul 2015 12 Jul 2015 1 Comments  82039 Views
Here Mudassar Ahmed Khan has explained with an example, how to bind / fill / populate DataGridView control with DataSet in Windows Forms (WinForms) Application in C# and VB.Net.
05 May 2015 05 May 2015 0 Comments  89675 Views
Here Mudassar Ahmed Khan has explained how to convert / copy DataReader (SqlDataReader) data to DataTable and DataSet using C# and VB.Net.
The DataTable and DataSet will be populated with records from the DataReader using Load method of the DataTable.
22 Oct 2013 24 Sep 2020 5 Comments  116490 Views
Here Mudassar Ahmed Khan has explained step by step with an example, how to display binary images stored in database in Crystal Report in ASP.Net using C# and VB.Net.

The Binary Data field will be displayed using Photo field in Crystal Reports and using an Image handler, the Images from Database Table will be fetched and displayed in Crystal Report.
20 Dec 2011 07 Mar 2019 7 Comments  169412 Views
Here Mudassar Ahmed Khan has explained with an example, how to populate (bind) GridView using jQuery AJAX in ASP.Net with C# and VB.Net.

This article will illustrate how to populate ASP.Net GridView control from SQL Server Database on Client Side by calling WebMethod using jQuery AJAX in ASP.Net with C# and VB.Net.
Results 21 - 39 of 39