I wrote the code for storing the files in the MySql database. Can any one tell me how can I retrieve them back? Here is my code:

 Dim MyConString As String = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE= student; UID=root; PASSWORD=123456;"
        Dim MyConnection As New System.Data.Odbc.OdbcConnection(MyConString)
        MyConnection.Open()
        Dim adap As New System.Data.Odbc.OdbcDataAdapter
        Dim insertstr As String = " insert into detail values ('" + Nametxt.Text + "'," + Phonetxt.Text + ",'" + Emaitxt.Text + "'," + "')"
        Dim comm As New System.Data.Odbc.OdbcCommand(insertstr, MyConnection)
        comm.ExecuteNonQuery()
        Label3.Text = " Record stored sucessfully"

Many Thanks,

Ramesh 

Hi, hope this will help.. I'll just use your current terms used in this thread.

1    Dim objReader As MySqlDataReader
2    Dim comm As MySqlCommand
3    
4    comm = new MySqlCommand("SELECT * FROM detail", MyConnection)
5    objReader = comm.ExecuteReader()
6    
7    Do while objReader.Read
8      Response.write(objReader("field_name_here"))
9    Loop
10   
11   myconnection.close()
12   myconnection.dispose()
13   objreader.close
14   
15   

happy coding!

Cheers,

CLIPER