[RESOLVED] External File for ConnectionCommand

[Radjesh Klauke]

Ola,

Does anyone has some experience with calling a strings which includes the "Dim blabla As New MySQLCommand(SELECT *... etc." I'm not talking about the connectionstring itself, but the "SELECT" part. Really would like to know how to read it from an external file. I don't care what kind of file. (.text / .xml / ...)

"Dim blabla As New MySqlCommand(commandstring_from_the_file, mysqlConn)

Much appreciated

[MaximilianMayrhofer]

Dim blabla As New MySqlCommand(IO.File.ReadAllText("Filepath"), mysqlConn)

[Radjesh Klauke]

Hehehe... Thanks. +rep

I forgot to mention that I need to have more commands stored within the file.