how to create a setup in vb.net ? ?

Nel Desai

cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\solutionvs10\test\test\bin\Debug\db2.mdb;Jet OLEDB:Database Password=secret")

cn.Open()
''# codes
cn.Close()

I used V S 2010 The above is my code......u can see that it is Ms Access DataBase....(password protection) How i can create a setup .....that can be easy to install other computer.........
Can i Create such a setup ???

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Hirendra Sisodiya15y ago
You can easily add Access database file in your setup project with target path and than you can use .Config file in your application.

thanks
0
Sam Hobbs16y ago
Will there be data that must be put into the database or does the new application just need an empty database to start with?
0
Shahan Ayyub16y ago
Is this an ASP.Net Website or a Windows application in VB.Net ???

for Asp.Net you can see the other experts' comment, for Windows application I would recommend you to place the db2.mdb in projects' BIN folder and for that use connectionstring like this:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\db2.mdb;Jet OLEDB:Database Password=secret;
0

Jiteendra Sampathirao16y ago

Hi,
In web.config file declare the code like:

Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\solutionvs10\test\test\bin\Debug\db2.mdb;Jet OLEDB:Database Password=secret"/>

And 
    Public Shared Function getConnectionString() As String 
        Return ConfigurationManager.AppSettings("MSACCESS")
    End Function

write like this when creating a connectionstring:

 conn = New OleDbConnection((getConnectionString())

-----------------------------------------------------------------------------------------------------------
If this post helped you, then tick the "Do you like this Answer" checkbox which is placed at above this post.