RE: sql server 2005 express database design

I can try it a little later. Does all of that keep the original word
formatting? I.e. fonts, tables, lists, styles and so on? Or does it strip
all of that away. I would need to keep the presentation of the word file (or
any of the files) in tact. Especially PowerPoint presentations.



-----Original Message-----
From: programmingblind-bounce@xxxxxxxxxxxxx
[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Jamal Mazrui
Sent: Saturday, October 27, 2007 11:07 AM
To: programmingblind@xxxxxxxxxxxxx
Subject: RE: sql server 2005 express database design

If your project is set to reference the Microsoft.VisualBasic.dll assembly,
I think you can use syntax like the following:

string sWordFile = @"C:\temp\MyWordFile.doc"; string sWordBody =
Microsoft.VisualBasic.FileIO.FileSystem.ReadAllText(sWordFile);

Then assign sWordBody to a VarChar database field.

Hope this helps,
Jamal


On Fri, 26
Oct 2007, Andy B wrote:

> Date: Fri, 26 Oct 2007 19:40:01 -0400
> From: Andy B <a_borka@xxxxxxxxxxxxx>
> Reply-To: programmingblind@xxxxxxxxxxxxx
> To: programmingblind@xxxxxxxxxxxxx
> Subject: RE: sql server 2005 express database design
>
> Ok... Sorry. Maybe I should make things a little clearer (oops on my
part).
> I have some good background in MySQL server work with db design and 
> light weight server admin. I haven't had much experience in creating 
> complex databases, but my business project is having me work that one 
> out. I am OK with c# and can usually find out how to do a lot of 
> things. What I need to know is how would you take a word file (.doc) 
> for instance, and use c# to actually insert the file itself (binary 
> data) into the db. From what I can see, it requires converting the 
> image/file into a byte array first and then putting it into the db. My 
> problem is that almost everybody uses asp.net 2.0 to show examples... I
need c# windows forms to do it with... any ideas?
>
>
>
> -----Original Message-----
> From: programmingblind-bounce@xxxxxxxxxxxxx
> [mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Richard 
> Thomas
> Sent: Friday, October 26, 2007 7:18 PM
> To: programmingblind@xxxxxxxxxxxxx
> Subject: Re: sql server 2005 express database design
>
>
> Hi Again:
> You would have to define your DataBase:
> then write a program to populate it with Data:
> Then a program to access the stored Data:
> Actually they would be classes designed around the Tables you build 
> for the database and the Window you want to use to look at the data. 
> What I would do, and have done. I wrote a Logger Class that I could 
> use to print things out easily into a txt file while testing and 
> debugging.
> Then:
> Wrote a program in CSharp to define the DataBase.  It may be better to 
> use a
>
> script for this but it is the way I started because I knew a little 
> programming but no scripting at the time.
> Then I wrote a class that generated some test data for the data base 
> and printed it out using the logger.
> When that looked good I created a Window to display the data. That's 
> the process.  I wrote the first DataBase Definition in CSharp but 
> converted everything to Vb.net and have continued working in it today. 
> As for examples there are plenty of works out there you can find Googling.
> Problem is you will have to know what to look for.  For example, 
> programatically creating a DataBase, Creating a DataBase using 
> Scripts, creating a DataBase using the Sql Server Management Studio
Express etc. .. .
> Read a little and keep asking questions.  You will use t-sql in any 
> case so that is something to get a quick overview of.  Also, Sql 
> Server Express and DataTypes.
> If you are new to DataBases look at Create DataBase and Create Table 
> statements to get an overview of a DataBase's structure.
> Rick Farmington Mich. USA
>
> ----- Original Message -----
> From: "Andy B" <a_borka@xxxxxxxxxxxxx>
> To: <programmingblind@xxxxxxxxxxxxx>
> Sent: Friday, October 26, 2007 1:04 PM
> Subject: RE: sql server 2005 express database design
>
>
> How would you do something like this? Any simple examples that I can 
> play with? I will probably be using c# to be the front end...
>
> -----Original Message-----
> From: programmingblind-bounce@xxxxxxxxxxxxx
> [mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Sina 
> Bahram
> Sent: Friday, October 26, 2007 12:19 PM
> To: programmingblind@xxxxxxxxxxxxx
> Subject: RE: sql server 2005 express database design
>
>
> If you store the files in the database, you actually will get faster 
> performance, all around.
>
> Take care,
> Sina
>
>
> -----Original Message-----
> From: programmingblind-bounce@xxxxxxxxxxxxx
> [mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of 
> james.homme@xxxxxxxxxxxx
> Sent: Friday, October 26, 2007 11:58 AM
> To: programmingblind@xxxxxxxxxxxxx
> Subject: Re: sql server 2005 express database design
>
> Hi andy,
> In my opinion, you should store the files in the file system and the 
> information about the files in the database. Out of curiosity, what 
> are you going to use as the front-end?
>
> Thanks.
>
> Jim
>
> James D Homme, , Usability Engineering, Highmark Inc., 
> james.homme@xxxxxxxxxxxx, 412-544-1810
>
> "It's more important for me to start to do the right thing than it is 
> to wait until I think I can do it just right."
>
>
>
>
>
>              "Andy B"
>              <a_borka@sbcgloba
>              l.net>                                                     To
>              Sent by:                  programmingblind@xxxxxxxxxxxxx
>              programmingblind-                                          cc
>              bounce@freelists.
>              org                                                   Subject
>                                        sql server 2005 express database
>                                        design
>              10/26/2007 11:44
>              AM
>
>
>              Please respond to
>              programmingblind@
>                freelists.org
>
>
>
>
>
>
> I need to write a program that references, categorizes, indexes and 
> allows searches (including full text searches) on data inserted into the
database.
> Different data formats like Word, rtf, txt, html and other sources 
> would have to be put into the database. Is it easier/better to insert 
> the files themselves (i.e. insert the actual word file) or just the 
> text+formatting of the word file? Any ideas how to do this stuff or where
I can find out more?
>
>
>
> __________
> View the list's information and change your settings at 
> http://www.freelists.org/list/programmingblind
>
> __________
> View the list's information and change your settings at 
> http://www.freelists.org/list/programmingblind
>
> __________
> View the list's information and change your settings at 
> http://www.freelists.org/list/programmingblind
>
> __________
> View the list's information and change your settings at 
> http://www.freelists.org/list/programmingblind
>
> __________
> View the list's information and change your settings at 
> http://www.freelists.org/list/programmingblind
>
__________
View the list's information and change your settings at
http://www.freelists.org/list/programmingblind

__________
View the list's information and change your settings at 
http://www.freelists.org/list/programmingblind

Other related posts: