C#

<Grid>
       <DataGrid ItemsSource="{Binding}"  AutoGenerateColumns="True" HorizontalAlignment="Stretch" Margin="0,0,2,2" Name="dataGrid1" VerticalAlignment="Stretch"  />
   </Grid>

  public Page2()
        {
            InitializeComponent();
            FillTable();
        }

        public class Lagerteile
        {
            public int ID { get; set; }
            public DateTime Liefertermin { get; set; }
            public string WANr { get; set; }
            public string Name { get; set; }
            public int Stk { get; set; }
            public string Kunde { get; set; }
            public string Pos { get; set; }
        }


        public void FillTable() {
 
            string cs = "Driver={PostgreSQL Unicode};" +
                        "Server=localhost;" +
                        "Database=***;" +
                        "Uid=***;" +
                        "Pwd=***;";
           
            
            string query = "SELECT *FROM xxxx";

            OdbcConnection cn = null;
            try
            {

                cn = new OdbcConnection(cs);
                DataContext context = new DataContext(cn);
                this.dataGrid1.DataContext = new ObservableCollection<Lagerteile>(
                context.ExecuteQuery<Lagerteile>(query));
            }
            catch (Exception ex)
            {
                System.Windows.Forms.MessageBox.Show(ex.Message);
            }

            if (cn.State == ConnectionState.Open)
            {
                cn.Close();
                cn.Dispose();

            }
}