01.
02.
MySqlConnection objConn =
new
MySqlConnection();
03.
string
strConnString =
null
;
04.
string
strSQL =
null
;
05.
06.
strConnString =
"Server=localhost;User Id=root; Password=root; Database=mydatabase; Pooling=false;"
;
07.
08.
strSQL =
"INSERT INTO files (Name,FilesName,FilesType) VALUES (?sName,?sFilesName,?sFilesType)"
;
09.
objConn.ConnectionString = strConnString;
10.
objConn.Open();
11.
12.
MySqlCommand objCmd =
new
MySqlCommand(strSQL, objConn);
13.
objCmd.Parameters.Add(
"?sName"
, MySqlDbType.VarChar).Value =
this
.txtName.Text;
14.
objCmd.Parameters.Add(
"?sFilesName"
, MySqlDbType.Binary).Value = imbByte;
15.
objCmd.Parameters.Add(
"?sFilesType"
, MySqlDbType.VarChar).Value = strMIME;
16.
objCmd.ExecuteNonQuery();
17.
18.
objConn.Close();
19.
objConn =
null
;