RE: sql server 2005 express database design
- From: "Andy B" <a_borka@xxxxxxxxxxxxx>
- To: <programmingblind@xxxxxxxxxxxxx>
- Date: Sat, 27 Oct 2007 19:26:22 -0400
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
> //www.freelists.org/list/programmingblind
>
> __________
> View the list's information and change your settings at
> //www.freelists.org/list/programmingblind
>
> __________
> View the list's information and change your settings at
> //www.freelists.org/list/programmingblind
>
> __________
> View the list's information and change your settings at
> //www.freelists.org/list/programmingblind
>
> __________
> View the list's information and change your settings at
> //www.freelists.org/list/programmingblind
>
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
Other related posts:
