插入图片文件到MySql和MSSql数据库
<div id="cnblogs_post_body">使用C#将指定文件夹以及子文件夹中的图片文件插入到MSSql数据库:<div class="cnblogs_code">using System.Data.SqlClient;using System;using System.IO;public class Photo{ public static void Main(string[]args) { byte[]byts=null; FileStream fs=null; string []files=Directory.GetFiles("./images","*.*",SearchOption.AllDirectories); string connstr="data source=localhost;initial catalog=test;user id=sa;password=sa1234;"; SqlConnection connection=new SqlConnection(connstr); connection.Open(); foreach(string file in files) { string ext=Path.GetExtension(file); string name=Path.GetFileNameWithoutExtension(file); fs=new FileStream(file,FileMode.Open); int size=(int)fs.Length; byts=new byte; fs.Read(byts,0,size); SqlCommand command=connection.CreateCommand(); command.CommandText="select count(*) from photo where name='"+name+"'"; if(Convert.ToInt32(command.ExecuteScalar())==0) { command.CommandText="insert into Photo(photo,name,size,extension) values(@photo,@name,@size,@extension)"; command.Parameters.Add(new SqlParameter("photo",byts)); command.Parameters.Add(new SqlParameter("name",name)); command.Parameters.Add(new SqlParameter("size",size)); command.Parameters.Add(new SqlParameter("extension",ext)); int effect=command.ExecuteNonQuery(); if(effect>0) { Console.WriteLine(file+"插入成功!"); } else { Console.WriteLine(file+"插入失败!"); } } } connection.Close(); fs.Close(); }}
页:
[1]