在vb.net下,如何将rtf文件保存到access数据库的OLE字段中?
诸位大侠,在vb.net下,如何将rtf文件保存到access数据库的OLE字段中? --------------------编程问答-------------------- '构建数据库连接,SQL语句,创建参数Dim strCnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\xxx.mdb"
Dim myConnection As New System.Data.OleDb.OleDbConnection(strCnString)
Dim strSql As String = "INSERT INTO TableName(FileName,FileByte)" & _
"VALUES (@FileName,@FileByte)"
Dim command As New System.Data.OleDb.OleDbCommand(strSql, File.ReadAllBytes("c:\xxx.rtf"))
command.Parameters.AddWithValue("@FileName", "文件名")
command.Parameters.AddWithValue("@FileByte", fileType) '打开连接,执行查询
myConnection.Open()
command.ExecuteNonQuery()
myConnection.Close()
补充:.NET技术 , VB.NET