Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
T

Tom Rahav

@Tom Rahav
About
Posts
4
Topics
3
Shares
0
Groups
0
Followers
0
Following
0

Posts

Recent Best Controversial

  • Problem to synchronise two DataContext bound ComboBoxes
    T Tom Rahav

    Fantastic! Thanks!!

    WPF csharp database wpf linq help

  • Problem to synchronise two DataContext bound ComboBoxes
    T Tom Rahav

    Hi, I’m trying to do something quite simple, I believe, but am very new to WPF and can’t figure it out. I want to display bank account details of a specific employee (which I select separately), and I want to let the user change those details if needed. My problem concerns specifically the following 3 tables: Banks: - BankID (PK) - CountryID - BankName - ... Countries: - CountryID (PK) - CountryName - ... BankAccounts: - BankAccountID (PK) - BankID - ... On my application’s MainWindow I have 2 ComboBoxes. I want to load the first one (cmbBankCountry) with a list of all the countries from ‘Countries’ table, and then automatically select the country which corresponds to the employee’s bank account. Similarly, I want the second ComboBox (cmbBanks) to be loaded with the names of all the banks that are associated with the selected country, and here too, select automatically the bank associated with that employee’s bank account. Of course, if the user changes the selection of the country for that bank account, the second ComboBox should be reloaded and display only the banks associated with the newly selected country. All the data comes from an SQL database via Linq-To-SQL classes (dbml), which I generated to represent the database tables. I.e. I have a Bank class, a Country class, a BankAccount class, etc. defined in a DataContext that I declared as a Private Shared variable of Application. I also created a ReadOnly property called DBMain to access it. So far I tried to tackle this task as follows: To load the first Combobox with all the countries I placed the following code in the MainWindow_Loaded event:

    Dim lstCountries As List(Of Country) = Application.DBMain.GetCountries()
    cmbBankCountry.ItemsSource = lstCountries
    cmbBankCountry.DisplayMemberPath = "CountryName"
    cmbBankCountry.SelectedValuePath = "CountryID"

    The GetCountries function looks like this:

    Public Function GetCountries() As List(Of Country)

            Dim lstCountry As List(Of Country) = (From c In Application.DBMain.Countries
                                                                      Select c
                                                                    ).ToList
            Return lstCountry
    

    End Function

    To load the second Combobox with the corresponding banks, I created an event that is triggered when the first Combobox’s selection (country) is changed:

    Private Sub DisplayBanksForCountry()

        Dim lstBanks As
    
    WPF csharp database wpf linq help

  • Toolbar alignment
    T Tom Rahav

    Hello, I would like to know wether there is a way to align a toolbar control to the right side of a VB .NET form, istead of to the left side as default. Thanks, Tom Rahav.

    Visual Basic csharp

  • Need some help...
    T Tom Rahav

    Dear All! I would like to ask for some help with a project I have in VB .NET I want to load a picture (BMP or JPG), then to select an area on this picture (by using a kind of selection tool or click on 4 corners) and then to get the size of the selected area. Any help of how to to it, will make me glad! Thanks in advanced!!! Tom Rahav.

    Visual Basic csharp help tutorial
  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups