Tutorial 12 - Visual Studio 2008, Linq to SQL, C#, and WPF

[eskashoo]

Thanks for the videos. I'm trying to do exactly what you are doing , so far so good. until when I try to add the ViewStudents sub-menu on 3:40. I'm not sure what I'm missing , but it does not load any ViewStudents when I try to type it in. so it underlines a red line as error.

do I have to define the ViewStudents anywhere in the program. I did not see you doing this .

Thanks again.

[xvleura]

he name 'con' does not exist in the current context

helpppppppppp

[90MrRager]

@xvleura

before it was

SchoolDataDataContext data = new SchoolDataDataContext();

but he had changed it to:

SchoolDataDataContext con = new SchoolDataDataContext();

that' s where the con comes afterwards

[yasaucsc]

Thanks Man It works

[AndreiDB1]

I have a problem on 1:29.

The problem is 'con.' underline, so I can't compile the project. Could you please tell me how fixed it?

[Rightwingful]

Great videos

Thanks

[JoeG2324]

k, im lost, i give up. cant follow this with the video missing

[hirushan]

@JoeG2324 Rename student project as School and the Namespace using refactor

then add those lines shows in this video 0:43

[santos122122]

Just write the code from the Window_Loaded method shown on 0:36 in the same method in your project in ViewStudents.xaml.cs.

The first line conects to the DB.

The second line retrives the students from the DB and puts them in a list called "students".

The third line assigns the students list as a source for the grid in the View Students window.

I hope this helps :)

[JoeG2324]

dude, you are missing a video

[ee01239]

your missing one what happened??? do an 11,5 :)

it had to be the linq part the main theme that i dont know :(

[HoltBuzzing]

dba, I believe that I got it working, however, I have a question. In my version of the Students table I have a FavoriteClassID field. This field points to the Classes table and using the ID I can JOIN to this table and figure out what the student's favorite class is. In my DataGrid, how do I do a JOIN so it would show 'SQL Programming' in the Grid instead of 8 (the ID for 'SQL Programming')?

[HoltBuzzing]

dba, it seems like the last tutorial was 11, but in the video you say this is tutorial13.  Where is 12 go?

[GeorgeRowlandHill]

Seems to be something missing between end of Tutorial 12 and start of this tutorial?