Read config file

[diablo21]

How to make this to be readed from the .ini file config.ini

con.ConnectionString = "Data Source=localhost;Initial Catalog=MuOnline;Persist Security Info=True;User ID=sa;Password=passwordX"

.ini
[Settings]
Host = localhost
Username = sa
Password = passwordX
Database = MuOnline

Public Sub createTable(ByVal vdbs As String, ByVal file As String)
    username = frmlogin.txtusername.Text
    password = frmlogin.txtusername.Text
    vsvr = vServer
    vdb = Trim$(vdbs)
    strCon1 = "Server=" & vsvr & ";Database=" & vdb & ";uid=" & username & ";pwd=" & password & ";"
   sqlCon1 = New SqlClient.SqlConnection(strCon1)
    sqlCon1.Open()
    Dim arr() As String
    arr = Split(readTextFile(file), " GO ")
    Dim i As String

For Each i In arr
        If i <> "" Then
            Dim cmd2 As New SqlClient.SqlCommand("" & i & "", sqlCon1)
            cmd2.CommandType = CommandType.Text
            cmd2.ExecuteNonQuery()
        End If
    Next
End Sub
 Public Function readTextFile(ByVal file As String) As String
    Dim fso As New System.Object
    Dim ts As Scripting.TextStream
    Dim sLine As String

    fso = CreateObject("Scripting.FileSystemObject")
    ts = fso.openTextFile(file)

    Do Until ts.AtEndOfStream
        sLine = sLine & " " & ts.ReadLine

    Loop
    ts.Close()
    fso = Nothing
    readTextFile = sLine

End Function

[diablo21]

I had created 1 Class.vb for ReadIni
What next to do ?

http://www.mentalis.org/soft/class.qpx?id=6

[wes4dbt]

Just Google "visual basic read text file" lots of examples.

But why? You could you your project settings to store that information. Open up the project properties page and click on the Settings tab.

[diablo21]

because i want to be custom configuration, not only me will use this simply program for edit database stuff
some people too, so fast and easy way is to add settings from .ini file so they edit and Boom all okey they start to edit

If i want to add my configs for my sql no point to ask here right?
So i'm waiting someone atlast to help me out with this

[wes4dbt]

Are you saying that every user will be using a different database?

If i want to add my configs for my sql no point to ask here right?

There are lots of different ways to store that information. Remember an ini file is a text file.

[diablo21]

i will just use then trusted connection will connect to sql server without asking username and password

[wes4dbt]

If your just wanting to store the username and password, then add a table to your database to store the information and then add a logon form to your project. Google "visual basic login form sql database"

[techgnome]

because i want to be custom configuration, not only me will use this simply program for edit database stuff
some people too, so fast and easy way is to add settings from .ini file so they edit and Boom all okey they start to edit

If i want to add my configs for my sql no point to ask here right?
So i'm waiting someone atlast to help me out with this

The built-in config file is also just a text file... it happens to be in XML format. You can set up the settings as User-level, which means each user would have their own settings... the reading & writing of it is baked right into the framework, making it easy-peasy to use. You also don't need to worry about folder security getting in the way - there's limits on where you can write info and Program Files is one of those. Since your app isn't writing, that's probably less of a problem.

That said... the easiest way to read a text file - using IO.File.ReadAllText ... returns a string array containing the contents of the file. From there it's a simple matter of looping through it, seeing what each one StartsWith and capturing the right values.

some thing like this - I'm shooting from the hip here, this is untested ...

Dim IniFile as String() = IO.File.ReadAllLines("Path to the INI file here")
Dim dbLocation, dbUser, dbPwd, dbName as String

for each s as string in IniFile
    If s.StartsWith("Host") Then
        dbLocation = s.Split("="c)(0).Trim
    ElseIf s.StartsWith("UserName") Then
        dbUser = s.Split("="c)(0).Trim
    ElseIf s.StartsWith("Password") Then
        dbPwd = s.Split("="c)(0).Trim
    ElseIf s.StartsWith("Database") Then
        dbName = s.Split("="c)(0).Trim
    end if

Next

'Use dbLocation, dbUser, dbPwd, dbName to assemble the connection string

-tg

[techgnome]

If your just wanting to store the username and password, then add a table to your database to store the information and then add a logon form to your project. Google "visual basic login form sql database"

Except that the OP is looking to store the username and password for the connection to the database... not the app... Actually, that might still work, just don't need the table... just ask for the login info, use it to build the connection string and Bob's you're uncle's cousin's former roommate.

-tg