RE: sql server 2005 express database design

  • From: "Andy B" <a_borka@xxxxxxxxxxxxx>
  • To: <programmingblind@xxxxxxxxxxxxx>
  • Date: Sun, 28 Oct 2007 08:18:40 -0400

Hi...

I found lots of articles on that sort of stuff too. The problem I have is
that most people want to use asp and a web server to do this type of stuff
and I don't... I need an example of this in a c# forms program... 

-----Original Message-----
From: programmingblind-bounce@xxxxxxxxxxxxx
[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Richard Thomas
Sent: Sunday, October 28, 2007 5:20 AM
To: programmingblind@xxxxxxxxxxxxx
Subject: Re: sql server 2005 express database design

Hi Andy:
Googling I found allot of articles on the subject of storing Ms Word
Documents on Sql Server DataBases but my Address Bar is messed up so I can't
copy and paste the links easily.
Anyway, they all talk about storing the documents as Blob or Binary fields,
most Blobs.  So scheck out if Blobs are still used or whatever is currently
used in your version of the DataBase to store Image files and you should be
good to go.
There were articles on Storing and Restoring those files, mostely bits and
pieces in Forum threads but I'm guessing you could find a complete article
Googling if you get lucky.
Anyway, Hope this helps.
Rick Farmington Mich. USA
----- Original Message -----
From: "Andy B" <a_borka@xxxxxxxxxxxxx>
To: <programmingblind@xxxxxxxxxxxxx>
Sent: Saturday, October 27, 2007 6:26 PM
Subject: 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
>> //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
> 

__________
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: