Something Besides Sql Server

I understand how nice Sql server express is, but I need to find a different way of storing data. I am trying to create a program that I can distribute without forcing the user to install a bunch of stuff (except the framework, of course).
I also understand that I could use xml, but I would need to learn a new way to program (I already know how to program against an SQL database).
Does anyone have any suggestions on what kind of database I could use, and any links on how to program against it

Answer this question

Something Besides Sql Server

Rupesh

Here is a small example to connect to an access database.

using System;
using System.Data;
using System.Data.OleDb;

public DataSet SelectFromDataBase()
{
OleDbConnection Conn = new OleDbConnection();
OleDbCommand Command = new OleDbCommand();
OleDbDataAdapter Adapter = new OleDbDataAdapter();
DataSet ds = new DataSet();
Conn.ConnectionString = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\\access.mdb");
Adapter.SelectCommand = new OleDbCommand ("SELECT * FROM Orders", Conn);
ds.DataSetName = "Orders";
Adapter.Fill (ds, 0, 3, "Orders");

foreach (DataColumn dc in ds.Tables[0].Columns)
{
   Console.Write("{0,-15}", dc.ColumnName);
}
Console.Write("\n");
for (int i=0; i<ds.Tables[0].Columns.Count; i++)
{
   Str = dr//emoticons/emotion-55.gif" alt="Idea" />.ToString();
   Str = Str.Trim();
   Console.Write("{0,-15}" , Str);
}
Console.Write("\n");
return ds; // to the caller.. if any..
}

moomooman123

Hi Frank,

We would like to get in touch with you. Could you please give us your email address

Thank you,
Bhanu.
vc++new_user
http://msdn.microsoft.com/library/default.asp url=/library/en-us/vbcon/html/vbtskCreatingConnectionToAccessDatabase.asp
krw
Have you everr tried Serializing your objects.
Usefull if not to much data and without the overhead of a database.
Scott P.
Access is probably what you need here. Just ship an MDB with your app.
Tim Murphy
John Hoge
That is what I was thinking about, but I can't figure out how to program against it. I know how to do the SQL, but how do I do the codebehind to connect to the database
Any help
Something Besides Sql Server

Answer this question