Results 1 - 5 of 59
12 Oct 2018 12 Oct 2018 0 Comments  732 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.
19 Sep 2018 19 Sep 2018 0 Comments  1067 Views
Here Mudassar Ahmed Khan has explained with an example, how to display Excel file in Web Page in ASP.Net using C# and VB.Net.

The Excel File will be read into a DataTable using OLEDB and ADO.Net and the DataTable will be used to display the Excel File in ASP.Net GridView.
19 Sep 2018 19 Sep 2018 0 Comments  585 Views
Here Mudassar Ahmed Khan has explained with an example, how to add (insert) Please Select Option (Item) in ComboBox (DropDownList) in Windows Forms Application using C# and VB.Net.

First a DataTable will be populated from database and then the Please Select Option (Item) will be added to it, finally the ComboBox will be populated from DataTable in Windows Forms Application using C# and VB.Net.
24 Jul 2018 24 Jul 2018 0 Comments  1181 Views
Here Mudassar Ahmed Khan has explained with an example, how to read Excel file directly from FileUpload control without Saving file in ASP.Net using C# and VB.Net.

When the Excel file is uploaded, the Excel File data is available in the InputStream property of the FileUpload control.

Using ClosedXml library, the Excel file data can be easily read from the InputStream property.
29 Jun 2018 29 Jun 2018 1 Comments  2060 Views
Here Mudassar Ahmed Khan has explained with an example, how to bulk import CSV file data into SQL Server database using SqlBulkCopy in ASP.Net using C# and VB.Net.

The CSV file will be uploaded and its data will be read into a DataTable and the DataTable data will be inserted into database using SqlBulkCopy in ASP.Net.
Results 1 - 5 of 59