[2005] Database question

[Kimmy4]

Hey guys,

I have added a database to my project which i have called StudentDatabase.

So i now have StudentDatabase.mdf and StudentDatabaseDataSet.xsd in my Solution Explorer, but as i have never used databases this way before I dont know where to go from here to create sql commands to create tables and then insert, update, select and delete from. So i was wondering whether anybody would be able to write me a bit of code to help me get on my way, or post a link to a website where i could find out how to use my database.

Thanks in advance for any help

[Pasvorto]

First, I would do a search on thsi forum. I am sure there are plenty of examples. Second, I would look at some of the signatures of the responders. Many of those have links to coding examples.

[onlyGirl]

There's many a couple of ways to do it but here's one:

Dim cmdSelect as New OleDbCommand
Dim daSelect as New OleDbDataAdapter
Dim dsSelect as New Dataset

cmdSelect = "YOUR SQL STATEMENT"
daInset.SelectCommand = cmdSelect
cmdSelect.Connection = "YOUR CONNECTION HERE"
daSelect.Fill (YOUR DATASET)

[onlyGirl]

http://www.firstsql.com/tutor.htm

[Kimmy4]

Hey, thanx for the replies. I have one more question though...what do i put for my connection string, because surely if i've added to database to my project, isn't it already connected??? Or am i just talkin complete rubbish (which would be the shock of the century! :-P lol)

Thanks again.

[jmcilhinney]

When you added the database to your project the system created a typed DataSet for you. The XSD file is the XML schema description of that DataSet. Along with the DataSet it also created TableAdapters. All the connection and SQL information is encapsulated within them. As you add tables and columns to your database you should regenerate your DataSet using the Configure button in the Data Sources window. That will re-run the wizard allow you to change the schema of your DataSet to match the database.

Once that's done you simply create an instance of your DataSet and the appropriate TableAdapter, then call the Fill method of the TableAdapter to populate the corresponding DataTable in the DataSet.

You can create the objects by dragging them from the Toolbox window onto your form or else you can create them in code, just like any other objects. You can also create them and corresponding bound controls by dragging tables and columns from the Data Sources window onto your form.

I suggest that you start reading here.