hi

how can i use excel file in the database as when i connect to database ,first i can use the value of excel file in the data base and then after cinnecting show in the form in the datagideviwe

thanks for your answer

Hi,

There are a couple of ways.

One would be to add a COM reference to Excel and read worksheet data, and then show those data with DataGridView.

The other may be to use OleDb to connect to the spreadsheet, and then show with DataGridView.

And you can refer to following thread for sample code.

https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2104957&SiteID=1

Hope this helps!

Hi,

There are a couple of ways.

One would be to add a COM reference to Excel and read worksheet data, and then show those data with DataGridView.

The other may be to use OleDb to connect to the spreadsheet, and then show with DataGridView.

And you can refer to following thread for sample code.

https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2104957&SiteID=1

Hope this helps!