Делаю так я
Спустя 16 секунд добавил
using(myStream
)
{
string filename = dlg.
FileName;
FileNameTextBox.
Text = filename;
Byte[] imageBytes =
new byte[myStream.
Length];
myStream.
Read(imageBytes,
0, imageBytes.
Length);
//using bd
OdbcConnection connection =
new OdbcConnection
("DRIVER={MySQL ODBC 5.1 Driver};" +
"SERVER=localhost;"+
"DATABASE=sss;" +
"UID=sss;" +
"PASSWORD=199011;" +
"OPTION=3");
connection.
Open();
OdbcCommand cmd =
new OdbcCommand
("insert into user (pass) VALUES ('"+ myStream +
"');");
cmd.
Connection = connection;
cmd.
ExecuteNonQuery();
cmd.
CommandText =
"SELECT avatar FROM user ORDER BY id DESC LIMIT 1;";
cmd.
Connection = connection;
OdbcDataReader dr = cmd.
ExecuteReader();
dr.
Read();
blob =
new Byte[(dr.
GetBytes(0,
0,
null,
0,
int.
MaxValue))];
dr.
GetBytes(0,
0, blob,
0, blob.
Length);
dr.
Close();
connection.
Close();
fs =
new FileStream
( @"z:\\MyTest.txt", FileMode.
Create, FileAccess.
Write);
fs.
Write(blob,
0, blob.
Length);
fs.
Close();
}
Спустя 1 минуту 40 секунд добавил
не работает код. Как записать изображение в базу а затем прочитать его?