将图像加载到数据库中

问题描述：

帅哥

我是c#的初学者，所以我想详细解释一下如何在数据库中加载图像.

Hi dudes

I am a beginner of c#.So i want a full explain and coding of how to load a image in database.

答

有人问过这样的问题在此网站上访问过很多次，请参见此处 [ ^ ].

希望您不是 google [

Such question have been ask''e so many times on this website, see here[^].

I hope you''re not beginner to google[^], try there first and then post your questions if you get stuck''d somewhere. This is not at all appropriate. Give a try at least.

放置一个文件上传控件，两个文本框txtImagid，txtImageName，上传按钮

StoreImages是具有imageid int，imagename vachar(20)，myimage image
的表
将以下代码写在上传按钮中，点击

put a file upload control,Two textboxes txtImagid,txtImageName ,Upload button

StoreImages is table with imageid int,imagename vachar(20), myimage image

Write the below code in upload button click

protected void UploadImage_Click(object sender, EventArgs e)
   {
       int retValue = 0;

       byte[] buffer=new byte[(int)fileUpload1.FileContent.Length];

       fileUpload1.FileContent.Read(buffer, 0, buffer.Length);

       string SqlCmd = "insert into StoreImages(imageid,ImageName,MyImage) values(@id,@Name,@MyImage)";

       using (SqlConnection con = new SqlConnection(ConnString))
       {
           using (SqlCommand cmd = new SqlCommand(SqlCmd, con))
           {
               SqlParameter[] prm = new SqlParameter[3];
               prm[0] = new SqlParameter("@id", SqlDbType.Int);
               prm[0].Value = txtImgId.Text.Trim();
               prm[1] = new SqlParameter("@Name", SqlDbType.VarChar,20);
               prm[1].Value = fileUpload1.FileName;
               prm[2] = new SqlParameter("@MyImage", SqlDbType.VarBinary);
               prm[2].Value = buffer;
               cmd.Parameters.AddRange(prm);
               con.Open();
               try
               {
                   retValue = cmd.ExecuteNonQuery();
                   if (retValue != 0)
                   {
                       Response.Write("Successfully uploaded");
                   }
                   else
                   {
                       Response.Write("Not uploaded");
                   }
                   con.Close();
               }
               catch (Exception ee)
               {
                   Response.Write(ee.Message + "");
               }
           }
       }
   }

检查以下一项:- http://revenmerchantservices.com/page/asp-net-image-upload.aspx [

[ ^ ]

[ ^ ]

Check this one :- http://revenmerchantservices.com/page/asp-net-image-upload.aspx[^]

[^]

[^]

将图像加载到数据库中

相关推荐