How to Export Dataset to Excel Using Microsoft.Interop VB.Net & SQL Server

Hi Jack

This post is a continuation of the previous post 

How to Export Dataset to Excel Using XML VB.Net & SQL Server 

this time we will use Microsoft.Interop to export from the dataset to excel file.

How to Export Dataset to Excel Using XML VB.Net & SQL Server

Hi Jack

How to Export Dataset to Excel Using XML VB.Net & SQL Server

In this post we will note how of database dataset exported into microsoft excel.

we will be using xml, and then on the next we ae going to use Microsoft Office Interop so we can compare the performance of both.

Post #9 : Programming " CRUD Part 3 - How to Update data in SQL Server using VB.net with sample project"

Hi. Jack


Now we will try to  change the data that we have input, we will work with one button that we have made in the first trial here.

we will combine save and update command in one button.

Post #8 : Programming " CRUD Part 2 - How to Select and Find data in SQL Server using VB.net"

Hi. Jack

now we will try to call the data that we have made in this post.

the scenario is, when we are typing the code in the code field and press enter the program will find the data in the database and display it if the code already exist in the database, if the code is not exist program will display "not found" message.

Post #7 : Programming " CRUD Part 1 - How to Insert or Create data in SQL Server using VB.net"

Hi Jack,

in the programming there is a very important process, no matter what the product is made, for dealing with the database CRUD definitely used.

CRUD what the heck is that ?

Post #5 : Programming "How to fill or add rows in DataGridView manually or automatically using VB.Net"

Hi Jack.

Today we will tried to enter data from database to a DataGridView.

What the heck DataGridView is ?, According mincrosoft listed here, DataGridView is a Control that have flexibility to display data in a table mode, you can make each columns readonly or write able, and there's many properties that can be used to embellish or making the presentation more informative.

Post #6 : Programming "How to add rows DataGridView manually using VB.Net"

Hi Jack.

We will try to fill or to add row DataGridView manually.
the steps are.

Post #4 : Programming "How to Create SQL Server Connection String Dynamic"

Hi Jack.

We meet again, today we will try to make SQL Server Connection String which we can change without changing the script.

Let's Start

Post #3 : Programming "How to import file excel into Datagridview in Visual Studio Using Visual Basic .Net"

Hi. Jack

Today we will try to import data from excel file "xls" or "xlsx" to datagridview, this script has been tested using visual studio 2010.

Q. Why do we have to import data from excel to a DataGridView ?

A. Sometimes many companies initially did all the needs of theirs data using excel, when they begin to migrate using application, it would be quite a hassle if you have to enter one by one manualy. Therefore, should we provide import function from excel to DataGridView to Database .

Okay let's start .

Post #2 : Programming "How to Add SQLite References in Visual Studio"

Hai Jack.

This is a post about how to add SQLite references into Visual Studio project.there are two ways to add a SQLite references into a project that we create.
SQLite Online Instalation 
First we can use the Nuget Package Manager Console, an you can see picture below to find out where the menu "Nuget Package Manager Console" 

and to do this task you need internet connection.