I am currently doing a project where i am using C# and databases. I am using visual C# 2008 and i am having issues accessing the tables that i made.
So what i have done is that i have a couple of tables, one with students in it, another with classes in it. I am making a third table that links the two through an ID. So what i need to be able to do in my program is to be able to select a row from a DataGridView (what you get when you pull the table onto a form by default) and then i need to be able to add a value from that row to another database.
So i am currently able to get the value that i need from the selected row. My main problem is once i have the data that i need to put into the table, i don't know how to do it.
I keep seeing code where people have SqlConnection types yet i cant find that in my program. I don't know if this is because i am using visual C# so therefore something is loaded differently, but i would like to know how i would go about adding a row to a table in a database in C#.. or how i would find the data necessary to connect to the database with visual C#.
One last thing, i wouldn't mind more on the whole C# and databases, so i was wondering if anyone knew of any good tutorials, it would be great if they used visual C# rather than just typing. I can do both, its just when trying to develop quickly being able to use a form builder is great :)