c# database setup

I am trying 开发者_高级运维to get some data stored in a database that i can query at a later date to display a record. I can make the database in visual studio 2010 no problems with all the fields i need. I just can seem to get the program to access it and add any data. I also have searched for help on the internet but they all seem to not work for me they say that the cannot find the database. I currently have no code to show because i am not sure what i should be doing. Any good websites to view could be helpful i cant find any good ones.

thanks in advance

There is a database tool called Server Explorer that is shipped with visual studio 2010.

To access it navigate to View->Server Explorer (or Ctrl+W,L). Then right-click on Data Connections and select Add Connection or Create new SQL Databasedepending on your needs. Once you have a connection setup you can edit tables, insert data etc from the server explorer. If you for example have a local SQL Server running its just to select your own computer as server name (should appear in the drop down list), use windows authentication as login method and choose a name for your new db.

Side note: the server explorer works for other databases as well but may require that you install additional connectors etc.

Another good tool to manage your SQL databases is the SQL Server Management Studio. It needs to be installed separately, a guide to do so is available here: Installing SQL Server Management Studio Express 2008. In my opinion this interface gives you better control of your databases, tables, stored procedures etc.

You can find basic information about database access on msdn.