Originally Posted by jagpreet

this is what i want to do dynamically with the help of parameters.
what i want is that user just enter the filename along with the path in the textbox and then the code automatically put the data of the file into database.


i can also fix the path the path of the file but i want the filename dynamically.

i have written this code.


Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click

Dim conn As New MySqlConnection
Dim myCommand As New MySqlCommand
Dim myAdapter As New MySqlDataAdapter
Dim myData As New DataTable

conn = New MySqlConnection()
conn.ConnectionString = "server=localhost " & ";" _
& "user id= root " & ";" _
& "password= cricket" & ";" _
& "database=systemconfiguration"

Dim filename As String

Dim fs As FileStream = New FileStream(textbox.text, FileMode.Open, FileAccess.Read)
(textbox.text is a textbox through which i want to give the filename or full filepath.)


FileSize = fs.Length
rawData = New Byte(FileSize) {}
fs.Read(rawData, 0, FileSize)
fs.Close()


(i can also get the filepath by this syntex given below

filePath = Me.filename.Text

MsgBox(filePath) )







myCommand.Connection = conn
myCommand.CommandText = "LOAD DATA INFILE '?f' into table configparams columns terminated by ',' enclosed by '""' lines starting by '""'"



myCommand.Parameters.AddWithValue("?f", filename)


conn.Open()
myCommand.ExecuteNonQuery()