When the application launches, Lab Assignment help
When the application launches, Lab Assignment help
Project:
For this project in addition to you form, you will need to make 2 separate classes. one for manipulating your Excel
file and the other for reading your access file. This project combines the ability to read from an Access file and the
ability to write to an Excel file.
CLASS1: Reading Access table
Your can download a set of databases from this site here, It’s what I did but you are more than free to make your
own database. The point here is to transfer a table to your datagridview box and display the database.
Link to databases:
http://www.msaccess2010.
com/tutorials/download.html
Here is the code for doing that:
‘Don’t forget to import System.Data.OleDb
Dim MyConnection As OleDbConnection
Dim MyDataAdapter As OleDbDataAdapter
Dim myDataSet As DataSet
Dim Mytables As DataTableCollection
Dim mySource As New BindingSource
Function GetDatabase(Address As String, SetName As String) As DataView
MyConnection = New OleDbConnection
MyConnection.ConnectionString = “Provider=Microsoft.ACE.OLEDB.12.0; Data Source=” & Address
myDataSet = New DataSet
Mytables = myDataSet.Tables
Dim Comand As String = “Select * from [” & SetName & “]”
MyDataAdapter = New OleDbDataAdapter(Comand, MyConnection)
MyDataAdapter.Fill(myDataSet, SetName)
Dim ViewofDatabase As New DataView(Mytables(0))
Return ViewofDatabase
End Function
CLASS2: Opening and saving an excel file
This class is basically your last class exercise, you need to open an excel file or make a new one and then
populate it given a file directory and a Boolean stating if a file exist or not. I will leave that last part for you to figure
out. hint: The dialog box gives it to you
Here is code example for the excel manipulation part
"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.
Discount Code: CIPD30
Click ORDER NOW..
