c# database setup

Question

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

Then check the server explorer, more info in my answer below. — Avada Kedavra
– Avada Kedavra, Commented Jun 23, 2011 at 12:59
Updated my answer with another tool called SQL Server Management Studio, it may as well be worth checking out. — Avada Kedavra
– Avada Kedavra, Commented Jun 27, 2011 at 11:42

Avada Kedavra · Accepted Answer · 2011-06-27 11:42:03Z

1

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.

edited Jun 27, 2011 at 11:42

answered Jun 23, 2011 at 12:56

Avada Kedavra

8,6995 gold badges35 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

bobthemac Over a year ago

i have go that setup now but i am now not sure how to put data from an input on the program into a field

ADIMO · Accepted Answer · 2011-06-23 12:57:16Z

0

You can find basic information about database access on msdn.

answered Jun 23, 2011 at 12:57

ADIMO

1,11712 silver badges24 bronze badges

Collectives™ on Stack Overflow

c# database setup

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related