将二进制文件写入sql数据库

来源:互联网 发布:https是哪个端口 编辑:程序博客网 时间:2024/06/03 18:56

 SqlConnection conn=null;
        public Form1()
        {
            InitializeComponent();
        }

        private void btnsave_Click(object sender, EventArgs e)
        {
                conn = new SqlConnection(connectionutil.getconnetionstr());
                conn.Open();
                SqlDataAdapter da = new SqlDataAdapter("select * from tb_image", conn);
                SqlCommandBuilder mycb = new SqlCommandBuilder(da);
                DataSet ds = new DataSet("MyImage");
                da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
                FileStream fs = new FileStream("D://北京之旅1.jpg", FileMode.OpenOrCreate, FileAccess.Read);
                byte[] MyData = new byte[fs.Length];
                fs.Read(MyData, 0, System.Convert.ToInt32(fs.Length));
                fs.Close();
                da.Fill(ds,"tbMyImage");
                DataRow mydr;
                mydr = ds.Tables["tbMyImage"].NewRow();
                mydr["Description"] = "This is my Beijing's photo";
                mydr["Imagfile"] = MyData;
                ds.Tables["tbMyImage"].Rows.Add(mydr);
                da.Update(ds, "tbMyImage");