充分利用LINQ的潜力 [英] Using LINQ to its fullest potential

问题描述

您好， 

我的帖子错了，所以我道歉。

I was in the wrong thread, so I do apologize.

这里我有以下代码下面的代码段。

Here I have the following code snippet below.

Public Class Form1
    Private Sub ListOfNamesBindingNavigatorSaveItem_Click(sender As Object, e As EventArgs) Handles ListOfNamesBindingNavigatorSaveItem.Click
        Me.Validate()
        Me.ListOfNamesBindingSource.EndEdit()
        Me.TableAdapterManager.UpdateAll(Me.NamesDBBackupOneDataSet)

    End Sub

    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        'TODO: This line of code loads data into the 'NamesDBBackupOneDataSet.ListOfNames' table. You can move, or remove it, as needed.
        Me.ListOfNamesTableAdapter.Fill(Me.NamesDBBackupOneDataSet.ListOfNames)

    End Sub

    Private Sub btnAddresses_Click(sender As Object, e As EventArgs) Handles btnAddresses.Click
        Form2.Show()

    End Sub
End Class


Imports System.Linq

Public Class Form2
    Private Sub TblAddressesBindingNavigatorSaveItem_Click(sender As Object, e As EventArgs) Handles TblAddressesBindingNavigatorSaveItem.Click
        Me.Validate()
        Me.TblAddressesBindingSource.EndEdit()
        Me.TableAdapterManager.UpdateAll(Me.NamesDBBackupOneDataSet)

    End Sub

    Private Sub Form2_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        'TODO: This line of code loads data into the 'NamesDBBackupOneDataSet.tblAddresses' table. You can move, or remove it, as needed.
        Me.TblAddressesTableAdapter.Fill(Me.NamesDBBackupOneDataSet.tblAddresses)

    End Sub

    Private Sub FillByToolStripButton_Click(sender As Object, e As EventArgs) Handles FillByToolStripButton.Click

        Dim FilteredByNameID = From tblAddresses In Me.NamesDBBackupOneDataSet.tblAddresses
                               Where tblAddresses.NameID = 1
                               Select tblAddresses.AddressID, tblAddresses.Address, tblAddresses.NameID

        Me.TblAddressesBindingSource.DataSource = FilteredByNameID    'This parameter is not implemented, and it will cause errors at runtime 


    End Sub
End Class

欢迎任何知道如何修复此代码段的用户将其复制并粘贴到他们的节点。

Any user who knows how to fix this code snippet is welcome to copy and paste this to their nodes.

问候，

JohnDBCTX

JohnDBCTX

jp

推荐答案

嗨JohnDBCTX，

Hi JohnDBCTX,

请合作nvert  FilteredByNameID to List并分配给  TblAddressesBindingSource.DataSource

Please convert FilteredByNameID to List and assign to TblAddressesBindingSource.DataSource

Public Class Form2
    Private Sub TblAddressesBindingNavigatorSaveItem_Click(sender As Object, e As EventArgs) Handles TblAddressesBindingNavigatorSaveItem.Click
        Me.Validate()
        Me.TblAddressesBindingSource.EndEdit()
        Me.TableAdapterManager.UpdateAll(Me.NamesDBBackupOneDataSet)

    End Sub

    Private Sub Form2_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        'TODO: This line of code loads data into the 'NamesDBBackupOneDataSet.tblAddresses' table. You can move, or remove it, as needed.
        Me.TblAddressesTableAdapter.Fill(Me.NamesDBBackupOneDataSet.tblAddresses)

    End Sub

    Private Sub FillByToolStripButton_Click(sender As Object, e As EventArgs) Handles FillByToolStripButton.Click

        Dim FilteredByNameID = From tblAddresses In Me.NamesDBBackupOneDataSet.tblAddresses
                               Where tblAddresses.NameID = 1
                               Select tblAddresses.AddressID, tblAddresses.Address, tblAddresses.NameID

        Me.TblAddressesBindingSource.DataSource = FilteredByNameID.ToList()    'This parameter is not implemented, and it will cause errors at runtime 


    End Sub
End Class

祝你好运，

张龙

这篇关于充分利用LINQ的潜力的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！