insert record into mysql table
-
I am a new comer in MySQL area, and I want to build an database application with Visual Studio .net 2003. My questions are: 1. How can I insert records into MySQL table in .net2003? 2. Can MySQL support image data in the record (like JPG/BMP file)? I searched these topics in CP but didn't find answer. Can anybody suggests some articles or sample code about this? Thanks a lot! Kevin
-
I am a new comer in MySQL area, and I want to build an database application with Visual Studio .net 2003. My questions are: 1. How can I insert records into MySQL table in .net2003? 2. Can MySQL support image data in the record (like JPG/BMP file)? I searched these topics in CP but didn't find answer. Can anybody suggests some articles or sample code about this? Thanks a lot! Kevin
The following shows how to do it in Access. This should work the same in MySQL if you just change the OleDb connection string. http://databasefaq.thefreeserver.com/#q13[^] You'll probably need to download the MySQL drivers if you haven't got them. http://www.mysql.com/products/connector/net/[^]