批量从数据库导出图片

最新推荐文章于 2020-12-09 10:10:31 发布

whxxxp

最新推荐文章于 2020-12-09 10:10:31 发布

阅读量1k

点赞数

分类专栏： c# 文章标签：数据库 string image byte

本文链接：https://blog.csdn.net/whxxxp/article/details/7974254

版权

c# 专栏收录该内容

0 篇文章 0 订阅

订阅专栏

    [WebMethod]
    public int downloadimg(string sort,int sort_id)
    {

        string constr = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
        SqlConnection con = new SqlConnection(constr);
        string imagename = "";
        try
        {
            con.Open();
            SqlCommand com = new SqlCommand("select id,img from photo where "

                + "sort_id=" + sort_id.ToString(), con);
            SqlDataReader dr = com.ExecuteReader(CommandBehavior.CloseConnection);
            int k = 0;
            while (dr.Read())
            {
                String id = dr["id"].ToString().Trim();
                MemoryStream ms = new MemoryStream((Byte[])dr["img"]);
                Bitmap image = new Bitmap(ms);
                string filepath = Server.MapPath("upload/");
                DirectoryInfo dir = new DirectoryInfo(filepath);
                FileInfo[] filecount = dir.GetFiles();
                imagename = filepath + "k"+k.ToString();
                image.Save(imagename);
                k++;
            }
            dr.Close();
            return k;
        }
        catch
        {
            return -1;
        }
        finally
        {
            con.Close();
        }
    
    }