Browse by Tags

• Access
• DataSet
• DataTable
• LINQ to DataSet
• Microsoft Access
• Multiline
• Multiline TextBox
• My
• visual basic

• Visual Basic 2008 - Create a DataTable From Linq Query Results

  Below is a class that contains a method that can create a DataTable object form Linq Query Results. I find the LINQToDataTable method really handy when I am creating Crystal reports. Crystal Reports love to report on DataTables.... Posted Nov 06 2009, 07:40 AM by Mike McIntyre with Filed under: Linq, DataTable

• Get List of Ports with Visual Basic My and Linq

  There are many ways to combine the Visual Basic My feature with LINQ. Heres an example that gets a list the ports on a computer: Dim portsList As List( Of String ) = ( From p In My .Computer.Ports.SerialPortNames Select p).ToList() Posted Sep 24 2009, 07:26 AM by Mike McIntyre with Filed under: visual basic, Linq, My

• Use Linq To Count Occurrences of a Character in a String

  Here's an example showing how to count the occurrences of a character in a string: Dim searchString As String = "This is the dawning of the age." Dim count As Integer = ( From s In searchString.ToCharArray Where s = "i" Select... Posted Sep 09 2009, 09:48 PM by Mike McIntyre with Filed under: Linq

• LINQ to Micorosoft Access via LINQ to DataSet

  // Fill the Customer table that is part of the AjaxDataSet AjaxDataSetTableAdapters. CustomerTableAdapter customerTableAdapter = new LINQ_To_MSAccess_CS2008.AjaxDataSetTableAdapters. CustomerTableAdapter (); customerTableAdapter.Fill(ajaxDataSet.Customer... Posted Mar 19 2009, 08:09 AM by Mike McIntyre with | with no comments Filed under: Linq, Microsoft Access, Access, DataSet, LINQ to DataSet

• Visual Basic 2005/2008 - Get String Array from Lines in a Multiline TextBox

  A post on vbCity asking how to get the lines in a VB6 multiline TextBox reminded me how much I like using VB.NET. In VB.NET 2005 its this easy: Dim multilineStrings() As String = Me .MyMultilineTextBox.Lines In VB.NET 2008, you can use LINQ too: Posted Feb 20 2009, 07:09 AM by Mike McIntyre with Filed under: Multiline TextBox, Multiline, Linq