Something Besides Sql Server

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?

timlshu at 2007-9-8 >

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

GlennWilson at 2007-9-8 >

Hi Frank,

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

Thank you,
Bhanu.

BhanuPrakashNunna-MSFT at 2007-9-8 >