Hi,
With the codes below, I'd like to populate another drop-down button, say on the top right by executing
"SELECT DISTINCT \"Delivery Month\" FROM Futures WHERE Name=Selected Market name from the center dropdown ORDER BY \"Delivery Month\"". I appreciate if you could please help me with a code snippet achieving this.
Country.cs:
namespace SyncfusionWpfDropdownTest
{
public class Country
{
public string? Name { get; set; }
}
}
Market.cs:
namespace SyncfusionWpfDropdownTest
{
public class Market
{
public string? Name { get; set; }
}
}
ViewModel.cs:
using System.Collections.ObjectModel;
using Npgsql;
namespace SyncfusionWpfDropdownTest
{
public class ViewModel
{
public ObservableCollection<Country> Countries { get; set; }
public ObservableCollection<Market> Markets { get; set; }
public ViewModel()
{
Countries = new ObservableCollection<Country>();
Markets = new ObservableCollection<Market>();
LoadData();
}
private void LoadData()
{
NpgsqlConnection conn = new NpgsqlConnection("Host=192.168.1.2; Port=5432; Database=tradingapp; Username=vorlket; Password=Vcsokr.");
conn.Open();
string query = "SELECT DISTINCT Country FROM EconomicCalendar ORDER BY Country";
NpgsqlCommand cmd = new NpgsqlCommand(query, conn);
NpgsqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Countries.Add(new Country
{
Name = reader.GetString(0)
});
}
NpgsqlConnection conn1 = new NpgsqlConnection("Host=192.168.1.2; Port=5432; Database=tradingapp; Username=vorlket; Password=Vcsokr.");
conn1.Open();
string query1 = "SELECT DISTINCT Name FROM Futures ORDER BY Name";
NpgsqlCommand cmd1 = new NpgsqlCommand(query1, conn1);
NpgsqlDataReader reader1 = cmd1.ExecuteReader();
while (reader1.Read())
{
Markets.Add(new Market
{
Name = reader1.GetString(0)
});
}
}
}
}
MainWindow.xaml:
<Window x:Class="SyncfusionWpfDropdownTest.MainWindow"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:local="clr-namespace:SyncfusionWpfDropdownTest" xmlns:syncfusion="http://schemas.syncfusion.com/wpf"
mc:Ignorable="d"
Title="MainWindow" Height="450" Width="800">
<Window.DataContext>
<local:ViewModel/>
</Window.DataContext>
<Grid>
<StackPanel HorizontalAlignment="Left" VerticalAlignment="Top">
<syncfusion:DropDownButtonAdv IconHeight="1" IconWidth="1" SizeMode="Normal" x:Name="CountryButton" Label="Country">
<syncfusion:DropDownMenuGroup ScrollBarVisibility="Visible" ItemsSource="{Binding Countries}">
<syncfusion:DropDownMenuGroup.ItemTemplate>
<DataTemplate>
<syncfusion:DropDownMenuItem Header="{Binding Name}" HorizontalAlignment="Left">
</syncfusion:DropDownMenuItem>
</DataTemplate>
</syncfusion:DropDownMenuGroup.ItemTemplate>
</syncfusion:DropDownMenuGroup>
</syncfusion:DropDownButtonAdv>
</StackPanel>
<StackPanel HorizontalAlignment="Center" VerticalAlignment="Top">
<syncfusion:DropDownButtonAdv IconHeight="1" IconWidth="1" SizeMode="Normal" x:Name="MarketButton" Label="Market">
<syncfusion:DropDownMenuGroup ScrollBarVisibility="Visible" ItemsSource="{Binding Markets}">
<syncfusion:DropDownMenuGroup.ItemTemplate>
<DataTemplate>
<syncfusion:DropDownMenuItem Header="{Binding Name}" HorizontalAlignment="Left">
</syncfusion:DropDownMenuItem>
</DataTemplate>
</syncfusion:DropDownMenuGroup.ItemTemplate>
</syncfusion:DropDownMenuGroup>
</syncfusion:DropDownButtonAdv>
</StackPanel>
</Grid>
</Window>
MainWindow.xaml.cs:
using System.Windows;
namespace SyncfusionWpfDropdownTest
{
/// <summary>
/// Interaction logic for MainWindow.xaml
/// </summary>
public partial class MainWindow : Window
{
public MainWindow()
{
InitializeComponent();
}
}
}
