Sharing the goodness…
Beth Massi is a Senior Program Manager on the Visual Studio team at Microsoft and a community champion for .NET developers. Learn more about Beth.
More videos »
Bill Burrows has done it again and created a series of videos to help get you started with LINQ to SQL in Visual Basic! Bill is a great teacher and the style of these videos is off-the-cuff so that you really feel like you are in a classroom learning real technical content and you're not missing anything. It takes a special kind of person to do this kind of video because personality really shines through. Bill's got a great personality and I'm thankful for the time he's spent on these videos for the Visual Basic Community. I hope you get as much out of these lessons as I did!
I'm having trouble with these video. The screens do not render correctly (image is badly skewed). Getting audio ok. I'm using IE 7.0.5730.11 Same problem with the lastest version of Firefox.
I forwarded your comment over to Bill Burrows.
Gary's problem appears to related to his OS (Windoes XP Home). We are working on a fix and I'll post it here when we get it figured out.
Regarding Gery's problem -- we were unable to resolve his issue viewing the videos with Windows XP Home edition. I have made Flash videos for him that work. If you have a similar problem. contact me from the myVBProf.com web site (Contact Us page).
Thanks for the videos. It beats reading books.
I was going about video #9 (Adding Validation) and I noticed that you use datatable events in the partial class.
Since you are using VB.NET it is fine, but I used C#.NET and I did not get the same datatable events you had (columnchanged, newrow) showing on the editor. In fact they are defined in the class but not activated and don't appear in the editor's drop downs.
I guess your focus is in VB but you may be able to answer my quesiton or direct it to someone else who could help.
Have just finished viewing Bill's on-line videos and coding my own test projects based on these videos. Just like to say thanks to Bill, I found them excellent and easy to follow. Bill your students are right when they said to leave in the errors and comments associated with them, it adds abit of humour and real life to it.
Many Thanks and look forward to many more of your learning videos.
Ron - England
Have been using Bill's learning videos on LINQ to SQL, it seems that some of the methods have changed, for example, the ' add ' and 'removeall' to
' InsertOnSubmit ' and DeleteOnSubmit.
I have the following issue with bill's example to delete arecord but now using the DeleteOnSubmit method. The line db.replemishes.DeleteOnSubmit(aitem) errors :Option Strict On disallows implicit conversions from 'System.Linq.IQueryable(Of WindowsApplication1.replemish)' to 'WindowsApplication1.replemish'.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim aitem = From d In db.replemishes _
Where d.partno = "AAAAA" _
How do I resolve this please?
To solve Ron's problem, you need to get a specific object from the enumeration of objects in the query. The example below converts the enumeration into a list of objects and then takes the first (and only in this case) object to be used in the delete method.
Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click
Dim customer = From c In db.Customers _
Where c.CustomerID = "AAAAA" _
' old code - does not work in RTM
Dim custList = customer.ToList
Me.CustomerDataGridView.DataSource = db.Customers