winfrom存储图片

ab281021997 2010-12-29 08:19:56

用C#编写winform 存储图片到sql数据库上的代码是怎么样的怎么在查询的时候给显示在pictruebox上啊
请各位大哥帮忙解决下啊

...全文

238 14 打赏收藏转发到动态举报

写回复

用AI写文章

14 条回复

切换为时间正序

请发表友善的回复…

发表回复

ab281021997 2010-12-29

打赏
举报

各位高手帮忙解决下啊

ab281021997 2010-12-29

打赏
举报

[Quote=引用 12 楼 piaopiao_lucky 的回复:]
wuyq11 的方法很好，强烈推荐。
[/Quote]
FileStream mystream=new FileStream("D:\\A.jpg",FileMode.Open,FileAccess.Read);
能否解释下那个路径是什么意思

偶像-阿里巴巴-马云 2010-12-29

打赏
举报

wuyq11 的方法很好，强烈推荐。

ab281021997 2010-12-29

打赏
举报

用这个以后怎么显示出来

iwanghs 2010-12-29

打赏
举报



private void btnUpload_Click(object sender, EventArgs e)

        {

            openPic.Title = "Choose Picture";

            openPic.Filter = "JPEG(*.jpg)|*.jpg|PNG(*.png)|*.png";



            if (openPic.ShowDialog() == DialogResult.OK)

            {

                if (File.Exists(openPic.FileName))

                {

                    if (openPic.OpenFile().Length > 1024 * 1024 * 2)

                    {

                        MessageBox.Show("图片不得超过2M");           

                        return;

                    }

                    string image = openPic.FileName;

                    string picpath = openPic.FileName;

                    Guid guid = Guid.NewGuid();

                    this.txtPhoto.Text = openPic.FileName;

                    if (!Directory.Exists(Application.StartupPath + "\\image"))

                    {

                        Directory.CreateDirectory(Application.StartupPath + "\\image");

                    }

                    this.txtPhoto.Tag = Application.StartupPath + "\\image\\" + guid.ToString() + ".jpg";

                    File.Copy(openPic.FileName, Application.StartupPath + "\\image\\" + guid.ToString() + ".jpg");

                    picPhoto.Image = Image.FromFile(Application.StartupPath + "\\image\\" + guid.ToString() + ".jpg");

                    picPhoto.ImageLocation = Application.StartupPath + "\\image\\" + guid.ToString() + ".jpg";

                }

                else

                {

                    MessageBox.Show("图片不能为空");

                    return;

                }

            }

        }

ab281021997 2010-12-29

打赏
举报

[Quote=引用 8 楼 wuyq11 的回复:]
Stream ms;
byte[] picbyte;
OpenFileDialog ofdSelectPic = new OpenFileDialog();
if (ofdSelectPic.ShowDialog() == DialogResult.OK)
{
if ((ms = ofdSelectPic.OpenFile()) != null)
{
pi……
[/Quote]
FileStream mystream=new FileStream("D:\\A.jpg",FileMode.Open,FileAccess.Read);
这里面的路径是什么用的啊请教

wuyq11 2010-12-29

打赏
举报

Stream ms;
byte[] picbyte;
OpenFileDialog ofdSelectPic = new OpenFileDialog();
if (ofdSelectPic.ShowDialog() == DialogResult.OK)
{
if ((ms = ofdSelectPic.OpenFile()) != null)
{
picbyte = new byte[ms.Length];
ms.Position = 0;
ms.Read(picbyte, 0, Convert.ToInt32(ms.Length));

SqlConnection conn = new SqlConnection();
conn.ConnectionString = "";

sql = "Insert into Person(Photo) values(@Image)";
SqlCommand cmd = new SqlCommand(sql, conn);

cmd.Parameters.Add("@Image", SqlDbType.VarBinary);
cmd.Parameters["@Image"].Value = picbyte;

conn.Open();
cmd.ExecuteNonQuery();
conn.Close();

ms.Close();
}
}

SqlConnection conn=new SqlConnection();
conn.ConnectionString="";
string strSql="";
SqlCommand cmd=new SqlCommand(strSql,conn);
conn.Open();
SqlDataReader reader=cmd.ExecuteReader();
reader.Read();
MemoryStream ms=new MemoryStream((byte[])reader["Photo"]);
Image image=Image.FromStream(ms,true);
reader.Close();
conn.Close();
picturebox1.Image=image;

FileStream mystream=new FileStream("D:\\A.jpg",FileMode.Open,FileAccess.Read);
long len=mystream.Length;
mycmd.Parameters.Add("@image",SqlDbType.Image,(int)len,"picture");
mycmd.Parameters["@image"].Direction=System.Data.ParameterDirection.Input;
byte []box=new byte[len];
mystream.Read(box,0,(int)len);
mycmd.Parameters["@image"].Value=box;

ab281021997 2010-12-29