VB.NET 2013: Databases - Retrieving related data and deleting (Part 3/5)

This is a set of video which cover working with database in VB.NET, how to retrieve, delete and manipulate a database via SQL all from VB.NET.

This video covers:
* Creating the project for the first time
* Retrieving related records
* Inserting some related records
* Deleting records

The next video covers how to edit data and sort by fields.

[HarveyA]

Brilliant tutorials. Thanks. I'm not a programmer but have dabbled with Excel VBA in the past and am about to embark on an ambitious project for a friend.

[petercook]

Great Video tutorials. I just have one problem. in the display of the data I am getting a coma between each field. I am using VS 2013 community edition. Just wondering if it is a setting in the database link that is adding a coma to each field.

[arafathossen]

+Nicholas Dingle When i made the database file i named the column as 'Assessments' instead of 'Assessment Name'. But I changed the column name in database file to match with your code and also changed the vb.net code accordingly. But program crashed showing syntax error. Then I changed the vb.net code and used 'Assessments' instead of 'Assessment Name' without changing the database column name back to 'Assessments' and it worked!!!

I just want to know if it is a problem or how can I change column name effectively. Please help me.

[janosszentes]

Hi!
An unhandled exception of type occurred in System.Data.dll

[harry]

Hello Sir, I am using this code to search data ( Dim q As String = " Select * from Rice where ID= " & Form1.ComboBox1.Text) this is giving me an error message (Syntax error (missing operator) in quarry expression 'ID=') Kindly help me out.

[roncasona]

Exception:Thrown: "Syntax error in string in query expression 'Marks.'Assesment Name`, Marks.MarkFROM students INNER JOIN Marks ON students.ID = Marks.Student_ID WHERE students.ID = 1'."
A was thrown: "Syntax error in string in query expression 'Marks.'Assesment Name`, Marks.MarkFROM students INNER JOIN Marks ON students.ID = Marks.Student_ID WHERE students.ID = 1'."
Time: 7/13/2015 11:25:39 PM
Thread:<No Name>[1436]

[sunniaccount]

Good video to learn from, I have an error when I try to enter date of birth e.g 24/11/1988 to the menu of add students,

[Snggle]

Additional information: Syntax error in JOIN operation.

  Dim q As String = "SELECT Students.FirstName, Students.LastName, Marks.`Assessment Name`, Marks.Mark " &
                "FROM Students INNER JOIN Marks ON Student.ID = Marks.Student_ID WHERE Students.ID = " & id

I already made sure that there is a relationship and the terminology of the variables are correct

[hasankhatib]

actually I think if we made our own database it will be easier ^_^