Dienstag, 16. April 2013

Visual Basic 2012 WPF Datenbank programmieren von Selzer-McKenzie SelMcKenzie


Visual Basic 2012 WPF Datenbank programmieren von Selzer-McKenzie SelMcKenzie


 
 


Heute zeige ich Ihnen, wie Sie eine komplette Datenbank mit allen Futures programmieren können mit Visual Basic WPF. Natürlich geht das auch mit früheren Versionen.

Aus einem Kalender werden die Daten direkt in die Datenbank eingetragen usw.

Diese Application kann in jedes Softwareprogramm eingebaut und auch noch visuell verändert werden.

Den Source Code habe ich abgefilmt und Sie können ihn durch Anhalten des Videos abschreiben oder

Den kompletten Source-Code finden Sie im Forum unter


 

Und hier der Source Code:

 


    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

    Title="Daten-Anbindung von Selzer-McKenzie SelMcKenzie" Height="431" Width="632"

    mc:Ignorable="d" xmlns:d="http://schemas.microsoft.com/expression/blend/2008"

        xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"

    xmlns:my="clr-namespace:WpfApplication1">

   

       

                              d:DesignSource="{d:DesignInstance

            my:Orders, CreateList=True}" />

       

                              Source="{Binding Path=Order_Details,

            Source={StaticResource OrdersViewSource}}" />

   

   

       

                  Height="203" HorizontalAlignment="Left" ItemsSource="{Binding}"

                  Margin="14,5,0,0" Name="OrdersDataGrid"

                  RowDetailsVisibilityMode="VisibleWhenSelected"

                  VerticalAlignment="Top" Width="584">

            

               

                                    Binding="{Binding Path=OrderID}"

                                    Header="Order ID" Width="SizeToHeader" />

               

                                    Binding="{Binding Path=CustomerID}"

                                    Header="Customer ID" Width="SizeToHeader" />

               

                                    Binding="{Binding Path=EmployeeID}"

                                    Header="Employee ID" Width="SizeToHeader" />

               

                                        Header="Order Date" Width="SizeToHeader">

                   

                       

                                                            Mode=TwoWay, ValidatesOnExceptions=true,

                                NotifyOnValidationError=true}" />

                       

                   

                

               

                                        Header="Required Date" Width="SizeToHeader">

                   

                        

                                                            Mode=TwoWay, ValidatesOnExceptions=true,

                                NotifyOnValidationError=true}" />

                        

                   

               

               

                                        Header="Shipped Date" Width="SizeToHeader">

                   

                       

                                                            Mode=TwoWay, ValidatesOnExceptions=true,

                                NotifyOnValidationError=true}" />

                       

                   

               

               

                                    Binding="{Binding Path=ShipVia}"

                                    Header="Ship Via" Width="SizeToHeader" />

               

                                    Binding="{Binding Path=Freight}"

                                    Header="Freight" Width="SizeToHeader" />

               

                                    Binding="{Binding Path=ShipName}"

                                    Header="Ship Name" Width="SizeToHeader" />

               

                                    Binding="{Binding Path=ShipAddress}"

                                    Header="Ship Address" Width="SizeToHeader" />

               

                                    Binding="{Binding Path=ShipCity}"

                                    Header="Ship City" Width="SizeToHeader" />

               

                                    Binding="{Binding Path=ShipRegion}"

                                    Header="Ship Region" Width="SizeToHeader" />

                

                                    Binding="{Binding Path=ShipPostalCode}"

                                    Header="Ship Postal Code" Width="SizeToHeader" />

               

                                    Binding="{Binding Path=ShipCountry}"

                                    Header="Ship Country" Width="SizeToHeader" />

           

       

       

                  Height="156" HorizontalAlignment="Left"

                  ItemsSource="{Binding Source={StaticResource

                            OrdersOrder_DetailsViewSource}}"

                  Margin="14,224,0,0" Name="Order_DetailsDataGrid"

                  RowDetailsVisibilityMode="VisibleWhenSelected"

                  VerticalAlignment="Top" Width="584">

           

               

                                    Binding="{Binding Path=OrderID}"

                                    Header="Order ID" Width="SizeToHeader" />

               

                                    Binding="{Binding Path=ProductID}"

                                    Header="Product ID" Width="SizeToHeader" />

               

                                    Binding="{Binding Path=UnitPrice}"

                                    Header="Unit Price" Width="SizeToHeader" />

               

                                    Binding="{Binding Path=Quantity}"

                                    Header="Quantity" Width="SizeToHeader" />

               

                                    Binding="{Binding Path=Discount}"

                                    Header="Discount" Width="SizeToHeader" />

            

       

   

Keine Kommentare:

Kommentar veröffentlichen

Hinweis: Nur ein Mitglied dieses Blogs kann Kommentare posten.