Access Database C#

I want to have some tips. I have worked on SQL databases in c# but i am developing a new small level application that only has to store some contact numbers so i planed for access because SQL will be overkill so i have never been to access database. How to Add access database file --> there is no file to add when I add new item to solution Consumption is same with a bit changes as that of SQL? like

"SELECT * FROM USERS WHERE uName=@username"

Answers


Why Don't you try using SQL lite or SQL CE? These use a file-base approach to store your data (ie they put a file in your app_data folder, as I think you want with access).

Some pointers

http://weblogs.asp.net/scottgu/archive/2010/06/30/new-embedded-database-support-with-asp-net.aspx

http://dotnetperls.com/sqlce

http://www.sqlite.org/


While I completely agree with Jaime on SQL Lite and SQL Compact Edition and back him up thoroughly, to answer your question, there will not be an Access Database to be added to the project from Visual Studio. However you can simply create an Access Database from Microsoft Access and manipulate it from C#. If you have previous experience in SQL Server, this would be very easy. Most of the objects and methods that you used from System.Data.SqlClient would be replaced by System.Data.OleDb. And yes you can use SQL syntax to interact with the database. As for the connection string to use, refer to Connection Strings for Access 2007


Need Your Help

Extracting matrix rows with variable step

matlab matrix matrix-indexing

Let's say that i've a 3 columns matrix like this one:

How to get child of child of object in javascript. (If exists)

javascript arrays json

I get some json data, and there I have such a structure:

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.