WinFrom 上传图片的控件叫什么名字? 忘了 WinFrom 上传图片的控件叫什么名字? 忘记了. 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 不好意思,这个是做网站时用的,不是winform 转载(泳桦的博客)winfrom的上传图片现在只需要button,textbox,pictureBox1。代码:按扭事件 private void button1_Click(object sender, EventArgs e) { OpenFileDialog dag = new OpenFileDialog(); if (dag.ShowDialog() == DialogResult.OK) { fname = dag.FileName; textBox1.Text = fname; WritImage(fname); ReadImage(); } }//WritImage类//向数据库写图片 private void WritImage(string fname) { System.Data.SqlClient.SqlConnection conn1 = new SqlConnection("server=.;database=QYgusnli;user );//首先删除 System.Data.SqlClient.SqlCommand cmd1 = new SqlCommand("delete from imgtable where userpecode = @usercode", conn1); System.Data.SqlClient.SqlParameter userde = new SqlParameter("@usercode", Ren_flex.Rows[0][1]); cmd1.Parameters.Add(userde); conn1.Open(); try { cmd1.ExecuteNonQuery(); } catch (System.Exception ex) { MessageBox.Show(ex.ToString()); } //添加图片(存储过程) System.Data.SqlClient.SqlConnection conn = new SqlConnection("server=.;database=QYgusnli;user ); System.Data.SqlClient.SqlCommand cmd = new SqlCommand("insert imgtable(userpecode,companycode,imageName,Image) values(@userpercode,@companycode,@name,@data)", conn); System.Data.SqlClient.SqlParameter pm = new SqlParameter("@name", System.Data.SqlDbType.VarChar, 200); pm.Value = fname; System.Data.SqlClient.SqlParameter pm1 = new SqlParameter("@data", System.Data.SqlDbType.Image); System.Data.SqlClient.SqlParameter usercode = new SqlParameter("@userpercode", Ren_flex.Rows[0][1]); System.Data.SqlClient.SqlParameter companycode = new SqlParameter("@companycode", comcode); //上传图片的路径 System.IO.FileStream fs = new System.IO.FileStream(fname, System.IO.FileMode.Open); int len = (int)fs.Length; System.Byte[] fileData = new byte[len]; fs.Read(fileData, 0, len); fs.Close(); pm1.Value = fileData; cmd.Parameters.Add(pm); cmd.Parameters.Add(pm1); cmd.Parameters.Add(usercode); cmd.Parameters.Add(companycode); conn.Open(); try { cmd.ExecuteNonQuery(); MessageBox.Show("Save Picture to database succeed"); } catch (System.Exception ex) { MessageBox.Show(ex.ToString()); } } //ReadImage//从数据库中读出图片 private void ReadImage() { System.Data.SqlClient.SqlConnection conn = new SqlConnection("server=。;database=QYgusnli;user ); System.Data.SqlClient.SqlCommand cmd = new SqlCommand("select * from imgtable where userpecode=@usercode and companycode=@com", conn); SqlParameter userID = new SqlParameter("@usercode", personCode); SqlParameter company = new SqlParameter("@com", comcode); cmd.Parameters.Add(userID); cmd.Parameters.Add(company); conn.Open(); System.Data.SqlClient.SqlDataReader dr; try { dr = cmd.ExecuteReader(); while (dr.Read()) { System.Data.SqlTypes.SqlBinary sb = dr.GetSqlBinary(4); System.IO.MemoryStream stm = new System.IO.MemoryStream(sb.Value); System.Drawing.Bitmap bmp = new Bitmap(Bitmap.FromStream(stm)); this.pictureBox1.Image = bmp; } dr.Close(); } catch(Exception ex) { MessageBox.Show(ex.ToString()); } finally { conn.Close(); } } winform上传图片还可以用FTP的方式先设置FTP站点,然后上传图片,当然4楼的是直接把图片以2进制流的方式存入数据库的 制作了一个WPF,processbar显示今天剩余的时间,希望各方面指导 控件值更新问题 求帮忙修改正则(去掉下划线) 关于BLL,DAL,实体类,多表查询,事物的相关疑惑 存储过程中数据按时间排序 在线等 WinForm传值题,急急急!!! 使用c#数据绑定oracle为何找不到system表空间的表 散分拉!ghj1976老兄你快来up一下啊! 下面的情况,应如何调试(高分求助)? 需要装什么才能得到.NET/C#的编程环境? app_code文件夹内的程序集不能添加引用吗? 怎么样使Label控件中的文字显示不同的颜色??
现在只需要button,textbox,pictureBox1。代码:按扭事件 private void button1_Click(object sender, EventArgs e)
{
OpenFileDialog dag = new OpenFileDialog();
if (dag.ShowDialog() == DialogResult.OK)
{
fname = dag.FileName;
textBox1.Text = fname;
WritImage(fname);
ReadImage(); }
}//WritImage类//向数据库写图片 private void WritImage(string fname)
{ System.Data.SqlClient.SqlConnection conn1 = new SqlConnection("server=.;database=QYgusnli;user );//首先删除
System.Data.SqlClient.SqlCommand cmd1 = new SqlCommand("delete from imgtable where userpecode = @usercode", conn1);
System.Data.SqlClient.SqlParameter userde = new SqlParameter("@usercode", Ren_flex.Rows[0][1]);
cmd1.Parameters.Add(userde);
conn1.Open();
try
{
cmd1.ExecuteNonQuery();
}
catch (System.Exception ex)
{
MessageBox.Show(ex.ToString());
} //添加图片(存储过程) System.Data.SqlClient.SqlConnection conn = new SqlConnection("server=.;database=QYgusnli;user );
System.Data.SqlClient.SqlCommand cmd = new SqlCommand("insert imgtable(userpecode,companycode,imageName,Image) values(@userpercode,@companycode,@name,@data)", conn);
System.Data.SqlClient.SqlParameter pm = new SqlParameter("@name", System.Data.SqlDbType.VarChar, 200);
pm.Value = fname;
System.Data.SqlClient.SqlParameter pm1 = new SqlParameter("@data", System.Data.SqlDbType.Image);
System.Data.SqlClient.SqlParameter usercode = new SqlParameter("@userpercode", Ren_flex.Rows[0][1]);
System.Data.SqlClient.SqlParameter companycode = new SqlParameter("@companycode", comcode); //上传图片的路径
System.IO.FileStream fs = new System.IO.FileStream(fname, System.IO.FileMode.Open);
int len = (int)fs.Length;
System.Byte[] fileData = new byte[len];
fs.Read(fileData, 0, len);
fs.Close();
pm1.Value = fileData;
cmd.Parameters.Add(pm);
cmd.Parameters.Add(pm1);
cmd.Parameters.Add(usercode);
cmd.Parameters.Add(companycode);
conn.Open();
try
{
cmd.ExecuteNonQuery();
MessageBox.Show("Save Picture to database succeed");
}
catch (System.Exception ex)
{
MessageBox.Show(ex.ToString());
}
} //ReadImage//从数据库中读出图片
private void ReadImage()
{
System.Data.SqlClient.SqlConnection conn = new SqlConnection("server=。;database=QYgusnli;user );
System.Data.SqlClient.SqlCommand cmd = new SqlCommand("select * from imgtable where userpecode=@usercode and companycode=@com", conn);
SqlParameter userID = new SqlParameter("@usercode", personCode);
SqlParameter company = new SqlParameter("@com", comcode);
cmd.Parameters.Add(userID);
cmd.Parameters.Add(company);
conn.Open();
System.Data.SqlClient.SqlDataReader dr;
try
{
dr = cmd.ExecuteReader();
while (dr.Read())
{
System.Data.SqlTypes.SqlBinary sb = dr.GetSqlBinary(4);
System.IO.MemoryStream stm = new System.IO.MemoryStream(sb.Value);
System.Drawing.Bitmap bmp = new Bitmap(Bitmap.FromStream(stm));
this.pictureBox1.Image = bmp;
}
dr.Close();
}
catch(Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
conn.Close();
} }
当然4楼的是直接把图片以2进制流的方式存入数据库的