I want to do this: after my module has been installed i want the user to have option in settings to specify custom database connection string and when he does that i want my module to run .sql script files on this database.

simpel task but i cant find how its done with dnn/asp

Solved it, here is the function for anyone who might need it:

' returns "" on success, error message string on error
Public Shared Function ExecuteSqlFile(connectionString As String, sqlCodeFname As String) As String
Dim sqlCodeTxt As String
Dim myFileStream As New System.IO.FileStream(sqlCodeFname, _
FileMode.OpenOrCreate, FileAccess.Read, FileShare.Read)
Dim myReader As New System.IO.StreamReader(myFileStream)
Dim sLine As String
Dim errorMsg As String = ""
Dim myConnection As New SqlConnection(connectionString)
Try
myConnection.Open()
'split sql code into blocks of sql code delimited by GO statements and execute blocks independantly
'because ExecuteNonQuery()... functions don't understand Microsoft's GO command.
Do
sLine = myReader.ReadLine()
If UCase(Trim(sLine)) = "GO" Then
Dim command As New SqlCommand(sqlCodeTxt, myConnection)
Try
command.CommandTimeout = 0
command.ExecuteNonQuery()
Catch ex As Exception
errorMsg = sqlCodeFname & ": " & ex.Message & vbCrLf & "sqlCodeTxt=" & Trim(sqlCodeTxt)
Return errorMsg
End Try
sqlCodeTxt = ""
Else
sqlCodeTxt = sqlCodeTxt & sLine & vbCrLf
End If
Loop Until sLine Is Nothing
Catch ex As Exception
errorMsg = sqlCodeFname & ": " & ex.Message
Finally
myReader.Close()
myFileStream.Close()
myConnection.Close()
End Try
Return errorMsg
End Function