openFileDialog1.ShowDialog();
int i = openFileDialog1.FileName.LastIndexOf("\\");
string filename = openFileDialog1.FileName.Remove(0, i + 1);
FileStream fs=File.OpenRead(openFileDialog1.FileName);
byte[] content=new byte[fs.Length];
fs.Read(content,0,content.Length);
fs.Close();
OleDbConnection oleConn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "\\data.mdb");
oleConn.Open();
string sql="insert into [image](image_name,photo) values(@name,@photo)";
OleDbCommand oleCmd=new OleDbCommand(sql,oleConn);
oleCmd.Parameters.Add("@name",OleDbType.Char).Value=filename;
oleCmd.Parameters.Add("@photo", OleDbType.Binary).Value = content;
OleDbDataAdapter oleDa=new OleDbDataAdapter();
oleDa.InsertCommand=oleCmd;
try
{
if (oleDa.InsertCommand.ExecuteNonQuery() == 1)
{
MessageBox.Show("图像已经成功保存到数据库中!");
}
else
{
MessageBox.Show("图像保存失败!");
}
}
catch (Exception ee)
{
String s = ee.Message;
MessageBox.Show(s);
}
oleConn.Close();
int i = openFileDialog1.FileName.LastIndexOf("\\");
string filename = openFileDialog1.FileName.Remove(0, i + 1);
FileStream fs=File.OpenRead(openFileDialog1.FileName);
byte[] content=new byte[fs.Length];
fs.Read(content,0,content.Length);
fs.Close();
OleDbConnection oleConn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "\\data.mdb");
oleConn.Open();
string sql="insert into [image](image_name,photo) values(@name,@photo)";
OleDbCommand oleCmd=new OleDbCommand(sql,oleConn);
oleCmd.Parameters.Add("@name",OleDbType.Char).Value=filename;
oleCmd.Parameters.Add("@photo", OleDbType.Binary).Value = content;
OleDbDataAdapter oleDa=new OleDbDataAdapter();
oleDa.InsertCommand=oleCmd;
try
{
if (oleDa.InsertCommand.ExecuteNonQuery() == 1)
{
MessageBox.Show("图像已经成功保存到数据库中!");
}
else
{
MessageBox.Show("图像保存失败!");
}
}
catch (Exception ee)
{
String s = ee.Message;
MessageBox.Show(s);
}
oleConn.Close();
int i = openFileDialog1.FileName.LastIndexOf("\\");
string filename = openFileDialog1.FileName.Remove(0, i + 1);
FileStream fs=File.OpenRead(openFileDialog1.FileName);
byte[] content=new byte[fs.Length];
fs.Read(content,0,content.Length);
fs.Close();
OleDbConnection oleConn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "\\data.mdb");
oleConn.Open();
string sql="insert into [image](image_name,photo) values(@name,@photo)";
OleDbCommand oleCmd=new OleDbCommand(sql,oleConn);
oleCmd.Parameters.Add("@name",OleDbType.Char).Value=filename;
oleCmd.Parameters.Add("@photo", OleDbType.Binary).Value = content;
try
{
if (oleCmd.ExecuteNonQuery() == 1) {
MessageBox.Show("图像已经成功保存到数据库中!");
} else {
MessageBox.Show("图像保存失败!");
}
} catch (Exception ee) {
String s = ee.Message;
MessageBox.Show(s);
}
oleConn.Close(); -----------------------------------------------------------
爱找房(http://www.izfang.com)
我的个人网站,个人免费的房屋租赁网站,大家要多多捧场哦。
-----------------------------------------------------------
爱找房(http://www.izfang.com)
我的个人网站,个人免费的房屋租赁网站,大家要多多捧场哦。