Need some help - Storing Image and text data in access DB
-
My Project has a requirement of storing Image and Text data in Access Database. I am using Vb.net for coding. According to me, This requirement can be fullfilled using binary files. But i am not able to figure out how to do it. The requiremnt is to accept data in RichTextBox(Text and Images) and convert it to binary file and store it to DB(Access). and Vice Versa. Can any body help me regarding this... Any links berifing the matter or any article Plz i need help...
Jats
-
My Project has a requirement of storing Image and Text data in Access Database. I am using Vb.net for coding. According to me, This requirement can be fullfilled using binary files. But i am not able to figure out how to do it. The requiremnt is to accept data in RichTextBox(Text and Images) and convert it to binary file and store it to DB(Access). and Vice Versa. Can any body help me regarding this... Any links berifing the matter or any article Plz i need help...
Jats
hey, I am C# developper, but i think my code might be useful since we are both using .NET framework. do the following. Check if file exist first by using the File class.if exists then do this byte[] Imagespace = File.ReadAllBytes(strPath); strpath is the full path of the photo. you can then send to stored procedure or do whatever you want once you have the photo in Imagespace variable. I wish my code would be useful.
I've been programming since year 1999, graduated from Univeristy Paris 2 France, fluent in C,C++,VC++,Web programming (XML,HTML,php etc..),.NET frameworks,C# and ASP.NET,SQL server, Mastering VC++ .NET and SQL server,data structure and database design
-
hey, I am C# developper, but i think my code might be useful since we are both using .NET framework. do the following. Check if file exist first by using the File class.if exists then do this byte[] Imagespace = File.ReadAllBytes(strPath); strpath is the full path of the photo. you can then send to stored procedure or do whatever you want once you have the photo in Imagespace variable. I wish my code would be useful.
I've been programming since year 1999, graduated from Univeristy Paris 2 France, fluent in C,C++,VC++,Web programming (XML,HTML,php etc..),.NET frameworks,C# and ASP.NET,SQL server, Mastering VC++ .NET and SQL server,data structure and database design
Thanks rabih_kai for sharing this information.
-
hey, I am C# developper, but i think my code might be useful since we are both using .NET framework. do the following. Check if file exist first by using the File class.if exists then do this byte[] Imagespace = File.ReadAllBytes(strPath); strpath is the full path of the photo. you can then send to stored procedure or do whatever you want once you have the photo in Imagespace variable. I wish my code would be useful.
I've been programming since year 1999, graduated from Univeristy Paris 2 France, fluent in C,C++,VC++,Web programming (XML,HTML,php etc..),.NET frameworks,C# and ASP.NET,SQL server, Mastering VC++ .NET and SQL server,data structure and database design
Hi thankx for the help rabih. Any how i have fullfilled the reqirement in a different and simple way. As the data is inserted in RichTextBox i accessed the data in RTF format from RTBox and stored in database. And while retrieving i can assign the data to RTBox.Rtf. It will convert the Text and Images and will display them. Simple isnt it...
Jats