当前位置:编程学习 > C#/ASP.NET >>

C# 实现文本文件存入数据库并取出

byte[]text= File.ReadAllBytes(this.openFileDialog1.FileName);
           SqlConnection con = new SqlConnection("data source=.;initial catalog=demo;user id=sa;pwd=");
           SqlCommand comm = new SqlCommand("Insert Into c (s) Values (@Image)", con);
           comm.Parameters.Add(new SqlParameter("@Image", text));
           con.Open();
           comm.ExecuteNonQuery();
           con.Close();
           string sql = "select s from c";
           comm = new SqlCommand(sql, con);
           con.Open();
           byte[] s = (byte[])comm.ExecuteScalar();
           this.textBox1.Text = System.Text.Encoding.Default.GetString(s, 0, s.Length);

    
补充:软件开发 , C# ,
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,