Best Stand Alone Database For Laptop in VB.Net?

newsaboutgod

I need a stand alone database for a VB.Net application on a laptop.

It will have about 15,000 records in it.

Frst off, if there any way to load XML in to a dataset and then run
SQL against it? Maybe that would meet my need.

If not, what is the best or quickest stand alone database for vb.net
and a laptop?

Feb 8 '08 #1

Subscribe Reply

4842

=?Utf-8?B?S2VycnkgTW9vcm1hbg==?=

newsaboutgod,

You can't execute sql commands against a datatable/dataset (although there
are some third-party tools promising that capability).

You can however do selection and filtering on the data in a
datatable/dataset, which might meet your needs.

There are a number of databases available that might meet your needs. For
example, Microsoft's new SQL Server Compact Edition (I think that is their
current name for the product), Firebird, etc.

Of course, a laptop could also run SQL Server Express or Access. Or one of
the open source databases, like MySQL or PostGreSQL.

Kerry Moorman
"ne**********@g mail.com" wrote:

I need a stand alone database for a VB.Net application on a laptop.

It will have about 15,000 records in it.

Frst off, if there any way to load XML in to a dataset and then run
SQL against it? Maybe that would meet my need.

If not, what is the best or quickest stand alone database for vb.net
and a laptop?

Feb 8 '08 #2

Mark Dykun

OK, so SQL CE3.5 is a Standalone in process database. Is there a reason you
could not use it. You can execute SQL, create tables, and use the upcomming
sync framework with it. At 15,000 records do you not want some form of
indexing to ensure the best performance. I think the database Dlls are only
around 2mb total distributable.

Mark
<ne**********@g mail.comwrote in message
news:72******** *************** ***********@d70 g2000hsb.google groups.com...

>I need a stand alone database for a VB.Net application on a laptop.

It will have about 15,000 records in it.

Frst off, if there any way to load XML in to a dataset and then run
SQL against it? Maybe that would meet my need.

If not, what is the best or quickest stand alone database for vb.net
and a laptop?

Feb 8 '08 #3

Spam Catcher

ne**********@gm ail.com wrote in news:72d446dc-07cd-4131-88ad-74000510c370
@d70g2000hsb.go oglegroups.com:

I need a stand alone database for a VB.Net application on a laptop.

It will have about 15,000 records in it.

You can use Vista DB, SQL Server CE, or even Embedded Firebird.

SQL Server CE is probably the best choice since it's free and has VS.NET
2005/2008 integration.

--
sp**********@ro gers.com (Do not e-mail)

Feb 8 '08 #4

Similar topics

5657

Stand alone PHP

by: Tom Jones | last post by:

I want to use PHP as a stand alone scripting language. By that I mean without a web server present and without any HTML in the code. I have done this in a few tests on a Win 2000 platform and, with just PHP.exe and a DLL and the ADOdb stuff in a lone directory, I have successfully run some scripts to talk to a database. All fine and good. But the real goal is to make this into a tiny runtime environment that I can deliver to any...

PHP

2916

Stand alone PHP parser

by: none | last post by:

Howdy all, I'm wondering if someone could give some direction on a problem I have or share their experiences. I'm wanting to create a little PHP application that will run on a local machine and use ODBC to connect to a Access database on that machine. A series of forms will interact with the database but if I understand correctly, I need some way to parse the PHP code. Is there a stand alone parser that could be used in place of a...

PHP

1600

converting database from stand-alone to networked?

by: RC | last post by:

I am starting a project to track inventory for a medium size business. The business would like to start off running the Access database on a single laptop and move the laptop from one area of the warehouse to another area of the warehouse as the database is needed. They want to start this way to get the inventory tracking system in use as quickly as possible. After the inventory tracking system gets refined and updated so the process is...

Microsoft Access / VBA

2191

Advice please on best method

by: Allan Cammish | last post by:

I am looking for advice on the best method of producing a piece of software written in Visual Basic or Visual Basic.NET that will control another standard windows program such as ‘Notepad' using ole automation. The system will be produced as a stand-alone EXE which will run on a single PC once the installation has been completed, but I also want to be able to easily convert the system to run from a web-site with the minimum of re-work.

Visual Basic .NET

4721

pg_dump in stand alone backend

by: Ulrich Wisser | last post by:

Hi, I would like to stop the postmaster every night and run vacuum pg_dump reindex in the stand alone backend.

PostgreSQL Database

1395

Can I use SQLExpress database in App_Data in SQL2005 stand-alone box?

by: GS | last post by:

Hello, I use SQL express database on my workstation under App_data directory for development. I also want to use it in staging enviroment where SQL 2005 full blown version is installed. Can I just copy database and use the same connection string to connect to it? Greg

ASP.NET

2322

Computer locks up when running valid stand alone Tkinter file.

by: jim-on-linux | last post by:

py help, The file below will run as a stand alone file. It works fine as it is. But, when I call it from another module it locks my computer, The off switch is the only salvation. This module when run as a stand alone, it will

Python

1482

stand alone desktop application with database integrated? xml?

by: confused1234 | last post by:

hi i want to make a stand alone exe that has database functionality. I have thought about using an xml file as the database, but is their a way that i can bundle the xml file into the exe somehow???? or does the xml file have to be seperate? if so how can i stop people editing it? Thanks for your help

.NET Framework

1878

Stand alone access app instead of multiple db at diffrent locations.

by: jinalpatel | last post by:

We have access database which is stand alone application. It is sitted at 21 different locations including one main office. Every month the transactions are copied in to disk and sent to the main office.(sounds so outdated but it is like that!!). Then we run that cd to copy those transactions to the main office database. Each location has not more than two users who are usng this database. Question: is there any way we can built the access...

Microsoft Access / VBA

8466

What is ONU?

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...

General

8896

Problem With Comparison Operator <=> in G++

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...

C / C++

7410

AI Job Threat for Devs

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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

5683

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

4208

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4387

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2798

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2035

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1790

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General