RichTextBox与二进制Word

    '将RichTextBox的内容直接写入数据库:
    Private Sub button1_Click(ByVal sender As Object, ByVal e As EventArgs)
        Dim mstream As System.IO.MemoryStream = New System.IO.MemoryStream()
        Me.richTextBox1.SaveFile(mstream, RichTextBoxStreamType.RichText)
        '将流转换成数组
        Dim bWrite() As Byte = mstream.ToArray()
        '将数组写入数据库
        Dim pram() As System.Data.SqlClient.SqlParameter = {sqlHelper.MakeInParam("@XX", System.Data.SqlDbType.Image)}


        pram(0).Value = bWrite
        sqlHelper.RunSql("insert into XXX (XX) values (@XX)", pram)
    End Sub


    '将数据库中的RTF读出并填充到RichTextBox
    Private Sub button2_Click(ByVal sender As Object, ByVal e As EventArgs)
        '从数据库中读出数据
        Dim dt As DataTable = sqlHelper.GetDataTable("select XX from XXX where .....")
        Dim bWrite() As Byte = CType(dt.Rows(0)(0), Byte())
        '将数组转换成stream
        Dim mstream As System.IO.MemoryStream = New System.IO.MemoryStream(bWrite, False)
        '将stream填充到RichTextBox
        Me.richTextBox1.LoadFile(mstream, RichTextBoxStreamType.RichText)
    End Sub

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值