473,406 Members | 2,549 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

C# Local Database?

Hi,

Are there any examples of building a simple local database with
C# Express 2005?

TIA

Nov 17 '05 #1
5 11371
What kind of local database are you talking about? You can use a local
install of SQL Express (which shouldn't be too much of a big deal), or use
Access (if it truly is local, and multiple users wont be using it at the
same time).

Can you give a little more information about what you are trying to do?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Paul M." <Paul M.@discussions.microsoft.com> wrote in message
news:DF**********************************@microsof t.com...
Hi,

Are there any examples of building a simple local database with
C# Express 2005?

TIA

Nov 17 '05 #2
I have an installation of sql express along with C# express and this is what
I would like to use. First off, just a flat file database is what I would
like to do and I will be the only user of the db.

"Nicholas Paldino [.NET/C# MVP]" wrote:
What kind of local database are you talking about? You can use a local
install of SQL Express (which shouldn't be too much of a big deal), or use
Access (if it truly is local, and multiple users wont be using it at the
same time).

Can you give a little more information about what you are trying to do?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Paul M." <Paul M.@discussions.microsoft.com> wrote in message
news:DF**********************************@microsof t.com...
Hi,

Are there any examples of building a simple local database with
C# Express 2005?

TIA


Nov 17 '05 #3
Paul,

If you are going to use flat files, then you don't have a need for SQL
Server express. If you want to use a flat file, then you should use the
text file provider for OLE DB (through the System.Data.OleDb namespace).
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Paul M." <Pa***@discussions.microsoft.com> wrote in message
news:7C**********************************@microsof t.com...
I have an installation of sql express along with C# express and this is
what
I would like to use. First off, just a flat file database is what I would
like to do and I will be the only user of the db.

"Nicholas Paldino [.NET/C# MVP]" wrote:
What kind of local database are you talking about? You can use a
local
install of SQL Express (which shouldn't be too much of a big deal), or
use
Access (if it truly is local, and multiple users wont be using it at the
same time).

Can you give a little more information about what you are trying to
do?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Paul M." <Paul M.@discussions.microsoft.com> wrote in message
news:DF**********************************@microsof t.com...
> Hi,
>
> Are there any examples of building a simple local database with
> C# Express 2005?
>
> TIA
>


Nov 17 '05 #4
Thanks for your quick reply. So, I am assuming that if I wanted to store blob
objects I would need to use sql server?

"Nicholas Paldino [.NET/C# MVP]" wrote:
Paul,

If you are going to use flat files, then you don't have a need for SQL
Server express. If you want to use a flat file, then you should use the
text file provider for OLE DB (through the System.Data.OleDb namespace).
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Paul M." <Pa***@discussions.microsoft.com> wrote in message
news:7C**********************************@microsof t.com...
I have an installation of sql express along with C# express and this is
what
I would like to use. First off, just a flat file database is what I would
like to do and I will be the only user of the db.

"Nicholas Paldino [.NET/C# MVP]" wrote:
What kind of local database are you talking about? You can use a
local
install of SQL Express (which shouldn't be too much of a big deal), or
use
Access (if it truly is local, and multiple users wont be using it at the
same time).

Can you give a little more information about what you are trying to
do?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Paul M." <Paul M.@discussions.microsoft.com> wrote in message
news:DF**********************************@microsof t.com...
> Hi,
>
> Are there any examples of building a simple local database with
> C# Express 2005?
>
> TIA
>


Nov 17 '05 #5
Paul,

You could always convert the bytes into a string using Base 64 encoding,
but that might make for some VERY big fields. Also, you can use blobs in
Access, but that wouldn't be a flat file anymore.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Paul M." <Pa***@discussions.microsoft.com> wrote in message
news:5A**********************************@microsof t.com...
Thanks for your quick reply. So, I am assuming that if I wanted to store
blob
objects I would need to use sql server?

"Nicholas Paldino [.NET/C# MVP]" wrote:
Paul,

If you are going to use flat files, then you don't have a need for
SQL
Server express. If you want to use a flat file, then you should use the
text file provider for OLE DB (through the System.Data.OleDb namespace).
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Paul M." <Pa***@discussions.microsoft.com> wrote in message
news:7C**********************************@microsof t.com...
>I have an installation of sql express along with C# express and this is
>what
> I would like to use. First off, just a flat file database is what I
> would
> like to do and I will be the only user of the db.
>
> "Nicholas Paldino [.NET/C# MVP]" wrote:
>
>> What kind of local database are you talking about? You can use a
>> local
>> install of SQL Express (which shouldn't be too much of a big deal), or
>> use
>> Access (if it truly is local, and multiple users wont be using it at
>> the
>> same time).
>>
>> Can you give a little more information about what you are trying
>> to
>> do?
>>
>>
>> --
>> - Nicholas Paldino [.NET/C# MVP]
>> - mv*@spam.guard.caspershouse.com
>>
>> "Paul M." <Paul M.@discussions.microsoft.com> wrote in message
>> news:DF**********************************@microsof t.com...
>> > Hi,
>> >
>> > Are there any examples of building a simple local database with
>> > C# Express 2005?
>> >
>> > TIA
>> >
>>
>>
>>


Nov 17 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Jack Crawford | last post by:
I am wondering if their is a strategy or tool for syncing a local database with a web-based database? Specifically I have an application where orders are entered via a web form and the data...
4
by: John Morgan | last post by:
I have Enterprise Manager on my local machine. For the last twelve months it has been connecting without problem to my online SQL Server database provided by my ISP. Three weeks ago the ISP...
0
by: for_your_spam_only | last post by:
Hi everybody, please take a look at the "screenshot" (DB2 CLI), Server is V7, FP12 running on WinNT, LDAP service is on AIX, IBM Directory Server 4.1 D:\>db2level DB21085I Instance "DB2"...
4
by: Nathaniel Sherman | last post by:
Alright, folks, here's the deal... I'm working on migrating a classic ASP website to an ASP.NET codebase. At the heart of the site is a MySQL database. To make sure an "in-process" program...
3
by: RLN | last post by:
(New to SQL Server Installs) I installed SQL Server 2005 Developer Edition on a WinXP-SP2 workstation and can see some enterprise databases on the network just fine. My problem is I cannot...
10
by: Jim Devenish | last post by:
I have a split front end/back end system. However I create a number of local tables to carry out certain operations. There is a tendency for the front end to bloat so I have set 'compact on...
0
by: D0c | last post by:
Hey, I would like to syncronize my local database with my website database. Scenarios are 1. New rows / row updates in the local database to be updated on the website database (local -net) 2....
8
by: mouac01 | last post by:
I'm not sure if this is possible. I would like to have a PHP app on the Internet connect and write to a local database (Intranet). For example, users would go to a web site...
4
by: Neil | last post by:
I work on a local copy of a database (Access 2000 MDB with ODBC linked tables to a SQL 7 database). The SQL Server db I'm working with is on my C drive (MSDE). Occasionally I'll connect to a VPN to...
1
by: ll | last post by:
Hi, I have copied a MS SQL database to my local machine and am testing it with ASP pages, locally, on IIS. I have a db connect page that keeps the current connections for the live database. My...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.