回复 5楼mindrayguowei的帖子
我理解需要使用一个中介文件来处理,目前我的进展是:
- private void loadToolStripMenuItem_Click(object sender, EventArgs e)
- {
- using (SqlConnection conn = new SqlConnection(sqlconnstr))
- {
- conn.Open();
- DataTable dt = new DataTable();
- string sql = "select * from test";
- SqlDataAdapter ad = new SqlDataAdapter(sql,conn);
-
- ad.Fill(dt);
- byte[] bts = (byte[])dt.Rows[3]["field2"];
- FileStream fs = new FileStream("test.rtf", FileMode.OpenOrCreate);
- fs.Write(bts, 0, bts.Length);
- //fs.get
- conn.Close();
- this.textControl1.Load(fs, TXTextControl.StreamType.RichTextFormat);
- fs.Close();
- }
- }
- private void saveToolStripMenuItem_Click(object sender, EventArgs e)
- {
- FileStream st = new FileStream("test.rtf", FileMode.Create);
- this.textControl1.Save(st, TXTextControl.StreamType.RichTextFormat);
- byte[] bts = new byte[st.Length];
- st.Read(bts, 0, bts.Length);
- st.Close();
- using (SqlConnection conn = new SqlConnection(sqlconnstr))
- {
- conn.Open();
- SqlCommand cmd = new SqlCommand();
- cmd.Connection = conn;
- cmd.CommandText = "insert into test(field2) values(@bts)";
- SqlParameter par = new SqlParameter("@bts", SqlDbType.Image);
- par.Value = bts;
- cmd.Parameters.Add(par);
- int t = (int)(cmd.ExecuteNonQuery());
- if (t > 0)
- {
- Console.WriteLine("插入成功");
- }
- conn.Close();
- }
- }
复制代码
当前遇到一些困难,加载时候无法识别格式,已经和厂商进行沟通,我们也在加紧调查,有进一步结果第一时间通知您。 |