62,046
社区成员
发帖
与我相关
我的任务
分享往数据库中插入图片的代码
我的SQL sever 数据库中的 list 表中有三个字段,分别是 '123' '234' '456' 我想往 '456' 字段中插入一个图片.运行下面的代码,每次按下 button 按钮后, 打开 list 表,就只看见 '123' '456' 字段中插入了 1a 1b 而'456'字段中没有看到插入了图片啊.请问程序哪里错了?
System.Data.SqlClient.SqlConnection connect =new System.Data.SqlClient.SqlConnection();
string con = System.Configuration.ConfigurationSettings.AppSettings.Get(0);
private void Button1_Click(object sender, System.EventArgs e)
{
System.Data.SqlClient.SqlCommand command=new System.Data.SqlClient.SqlCommand("insert into list values ('1a','1b',@i)",connect);
this.connect.ConnectionString=this.con;
this.connect.Open();
byte[] aaa=new Byte[60000];
FileStream fs=new FileStream(@"E:\hhr.jpg",FileMode.Open ,FileAccess.Read );
fs.Read(aaa,0,60000);
command.Parameters.Add("@i",SqlDbType.Image,(int)fs.Length);
command.Parameters["@i"].Value=aaa;
command.ExecuteNonQuery();
this.connect.Close();
}
System.Data.SqlClient.SqlConnection connect =new System.Data.SqlClient.SqlConnection();
string con = System.Configuration.ConfigurationSettings.AppSettings.Get(0);
private void Button1_Click(object sender, System.EventArgs e)
{
System.Data.SqlClient.SqlCommand command=new System.Data.SqlClient.SqlCommand("insert into list values ('1a','1b',@i)",connect);
this.connect.ConnectionString=this.con;
this.connect.Open();
byte[] aaa=new Byte[60000];
FileStream fs=new FileStream(@"E:\hhr.jpg",FileMode.Open ,FileAccess.Read );
fs.Read(aaa,0,60000);
command.Parameters.Add("@i",SqlDbType.Image,(int)fs.Length);
command.Parameters["@i"].Value=aaa;
command.ExecuteNonQuery();
this.connect.Close();
}
...全文
请发表友善的回复…
发表回复
