473,804 Members | 2,173 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

C# Local Database?

Hi,

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

TIA

Nov 17 '05 #1
5 11388
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.co m

"Paul M." <Paul M.@discussions. microsoft.com> wrote in message
news:DF******** *************** ***********@mic rosoft.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.co m

"Paul M." <Paul M.@discussions. microsoft.com> wrote in message
news:DF******** *************** ***********@mic rosoft.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.Ole Db namespace).
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Paul M." <Pa***@discussi ons.microsoft.c om> wrote in message
news:7C******** *************** ***********@mic rosoft.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.co m

"Paul M." <Paul M.@discussions. microsoft.com> wrote in message
news:DF******** *************** ***********@mic rosoft.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.Ole Db namespace).
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Paul M." <Pa***@discussi ons.microsoft.c om> wrote in message
news:7C******** *************** ***********@mic rosoft.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.co m

"Paul M." <Paul M.@discussions. microsoft.com> wrote in message
news:DF******** *************** ***********@mic rosoft.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.co m

"Paul M." <Pa***@discussi ons.microsoft.c om> wrote in message
news:5A******** *************** ***********@mic rosoft.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.Ole Db namespace).
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Paul M." <Pa***@discussi ons.microsoft.c om> wrote in message
news:7C******** *************** ***********@mic rosoft.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.co m
>>
>> "Paul M." <Paul M.@discussions. microsoft.com> wrote in message
>> news:DF******** *************** ***********@mic rosoft.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
3173
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 emailed to my client who processes the orders. I extract the order information and update a local "order tracking" database. There are several order processing steps. I want to update a web database to reflect the status of the order as it flows...
4
5496
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 applied some sort of extra security arrangements to their SQL Server to allow access only through port 1433. they have told me to configure an alias using Network Client and to register this alias in the usual way using my Enterprise Manager. My...
0
1497
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" uses "32" bits and DB2 code release "SQL08021" with level identifier "03020106". Informational tokens are "DB2 v8.1.8.762", "s041221", "WR21348", and FixPak "8".
4
4154
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 doesn't screw up the live site, I run a local IIS webserver on my XP Pro (AMD XP 2500+, 512MB DDR RAM) machine, which resides behind an XP ICS gateway on my LAN. I also have a MySQL server set up locally for development purposes.
3
5452
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 register a local database on the local drive for testing/education purposes. (I accepted all of the defaults on the install and thought all was well.)
10
7710
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 close' I think that I have read in some threads (althoug I cannot find them now) that others place such tables in a local, linked database. I could do this but I am interested to know what would be the advantages. And disadvantages, if any. Any...
0
2925
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. Updates on the website database to be updated on the local database (net -local) * Updates for both databases are possibly on different fields
8
3850
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 http://www.internet.com to run the app. The app requires an internet connection and is outside of the user's network. The app would have the option to either store data locally or on the Internet. I would like to give users the option to store data locally because...
4
2318
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 do something on a remote computer, using PC Anywhere to perform the task. Doesn't involve my front or back end at all, except that the computer I'm VPNing to has a SQL database running. OK, so I'm using my db; I connect to the VPN, and do my...
1
2428
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 question is, as the local db is named 'local,' is there another name I need to give it and thus call from the connection page? Also, when copying a db, are the permissions (username and pass) copied over with it? Thanks,
0
9711
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10595
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10343
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10335
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10088
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7633
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6862
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5668
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
3001
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.