Click here to Skip to main content
16,007,504 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Unable to Upgrade Vb6 to Vb.net Pin
Dave Kreskowiak13-Jan-09 10:19
mveDave Kreskowiak13-Jan-09 10:19 
AnswerRe: Unable to Upgrade Vb6 to Vb.net Pin
Dave Kreskowiak13-Jan-09 8:42
mveDave Kreskowiak13-Jan-09 8:42 
GeneralRe: Unable to Upgrade Vb6 to Vb.net Pin
sarfarazaliqureshi13-Jan-09 9:04
sarfarazaliqureshi13-Jan-09 9:04 
GeneralRe: Unable to Upgrade Vb6 to Vb.net Pin
Henry Minute13-Jan-09 9:08
Henry Minute13-Jan-09 9:08 
GeneralRe: Unable to Upgrade Vb6 to Vb.net Pin
sarfarazaliqureshi13-Jan-09 9:11
sarfarazaliqureshi13-Jan-09 9:11 
GeneralRe: Unable to Upgrade Vb6 to Vb.net Pin
Henry Minute13-Jan-09 9:25
Henry Minute13-Jan-09 9:25 
GeneralRe: Unable to Upgrade Vb6 to Vb.net Pin
sarfarazaliqureshi13-Jan-09 9:32
sarfarazaliqureshi13-Jan-09 9:32 
QuestionSQL Query Syntax Issue Pin
tcd6713-Jan-09 5:59
tcd6713-Jan-09 5:59 
I’m new to VB and WPF and struggling with a SQL query that contains a JOIN. This almost works by there is something not right with the JOIN or SELECT statements. If someone can point me to a resource that contains the proper syntax for statements like the one below, I would be very appreciative. Oh...and I'm using VS2008.
Class Window1 

    Private db As New cmaDataContext
    Private UserView As BindingListCollectionView


    Private Sub Window1_Loaded(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles MyBase.Loaded

        Dim CMAusers = From a In db.tsmContacts _
                       Join b In db.tsdContactDetails On _
                       a.intSystemUserID Equals b.intSystemUserID _
                       Where a.bitDeleted = "0" _
                       Select a.vchFirstName, a.vchLastName, a.vchMiddle, b.vchEmail

        Me.DataContext = CMAusers
        Me.UserView = CType(CollectionViewSource.GetDefaultView(Me.DataContext),  _
                            BindingListCollectionView)

    End Sub

Thanks,
Todd

modified on Tuesday, January 13, 2009 12:15 PM

AnswerRe: SQL Query Syntax Issue Pin
Wendelius13-Jan-09 6:28
mentorWendelius13-Jan-09 6:28 
GeneralRe: SQL Query Syntax Issue Pin
tcd6713-Jan-09 6:46
tcd6713-Jan-09 6:46 
GeneralRe: SQL Query Syntax Issue Pin
Wendelius13-Jan-09 7:24
mentorWendelius13-Jan-09 7:24 
Questionwindows service structure/custom actions Pin
captainmogo13-Jan-09 4:42
captainmogo13-Jan-09 4:42 
AnswerRe: windows service structure/custom actions Pin
Wendelius13-Jan-09 6:40
mentorWendelius13-Jan-09 6:40 
GeneralRe: windows service structure/custom actions Pin
captainmogo13-Jan-09 8:12
captainmogo13-Jan-09 8:12 
GeneralRe: windows service structure/custom actions Pin
Wendelius13-Jan-09 8:57
mentorWendelius13-Jan-09 8:57 
QuestionVBA - Changing a name of a Worksheet Pin
Dalek Dave13-Jan-09 4:16
professionalDalek Dave13-Jan-09 4:16 
AnswerRe: VBA - Changing a name of a Worksheet Pin
Dalek Dave13-Jan-09 4:20
professionalDalek Dave13-Jan-09 4:20 
QuestionMaximise already created process Pin
hrishiS12-Jan-09 23:56
hrishiS12-Jan-09 23:56 
AnswerRe: Maximise already created process Pin
EliottA13-Jan-09 2:48
EliottA13-Jan-09 2:48 
AnswerRe: Maximise already created process Pin
Henry Minute13-Jan-09 6:13
Henry Minute13-Jan-09 6:13 
AnswerRe: Maximise already created process Pin
Dave Kreskowiak13-Jan-09 8:24
mveDave Kreskowiak13-Jan-09 8:24 
GeneralRe: Maximise already created process Pin
hrishiS14-Jan-09 17:23
hrishiS14-Jan-09 17:23 
GeneralRe: Maximise already created process Pin
hrishiS3-Feb-09 23:45
hrishiS3-Feb-09 23:45 
GeneralRe: Maximise already created process Pin
Dave Kreskowiak4-Feb-09 2:21
mveDave Kreskowiak4-Feb-09 2:21 
QuestionBack up ms access database using vb.net2005 Pin
hrishiS12-Jan-09 23:36
hrishiS12-Jan-09 23:36 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.