Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>If I understand your question correctly you simply want to get some user input and display it.</p> <p>I suggest you start by defining a class that will represent the data you are inputting, for example:</p> <pre><code>public class Customer { public string ContectName { get; set; } public string BillingAddress1 { get; set; } public string BillingAddress2 { get; set; } public string PhoneNumber { get; set; } public int NumOfAds { get; set; } public double RateOfPlay { get; set; } public int NumOfMonths { get; set; } public double TotalDue { get; set; } } </code></pre> <p>On the page where the user inputs data you then create an instance of this class, either by manually creating an instance and setting its properties when the user submits (similar to what you are doing in your code) or use databinding to your advantage (which is what I prefer).</p> <p>Let's say for example you are inputting data on your MainPage</p> <pre><code>void MainPage_Loaded(object sender, RoutedEventArgs e) { this.DataContext = new Customer(); } </code></pre> <p>Now you can bind the controls. Let's say you're using a grid:</p> <pre><code>&lt;Grid x:Name="LayoutRoot" Background="White"&gt; &lt;Grid&gt; &lt;Grid.ColumnDefinitions&gt; &lt;ColumnDefinition Width="Auto" /&gt; &lt;ColumnDefinition Width="Auto" /&gt; &lt;/Grid.ColumnDefinitions&gt; &lt;Grid.RowDefinitions&gt; &lt;RowDefinition Height="Auto" /&gt; &lt;RowDefinition Height="Auto" /&gt; &lt;RowDefinition Height="Auto" /&gt; &lt;RowDefinition Height="Auto" /&gt; &lt;RowDefinition Height="Auto" /&gt; &lt;RowDefinition Height="Auto" /&gt; &lt;RowDefinition Height="Auto" /&gt; &lt;RowDefinition Height="Auto" /&gt; &lt;/Grid.RowDefinitions&gt; &lt;sdk:Label Content="Billing Address 1:" Grid.Column="0" Grid.Row="0" HorizontalAlignment="Left" Margin="3" VerticalAlignment="Center" /&gt; &lt;TextBox Grid.Column="1" Grid.Row="0" Height="23" HorizontalAlignment="Left" Margin="3" Name="billingAddress1TextBox" Text="{Binding Path=BillingAddress1, Mode=TwoWay, ValidatesOnExceptions=true, NotifyOnValidationError=true}" VerticalAlignment="Center" Width="120" /&gt; &lt;sdk:Label Content="Billing Address 2:" Grid.Column="0" Grid.Row="1" HorizontalAlignment="Left" Margin="3" VerticalAlignment="Center" /&gt; &lt;TextBox Grid.Column="1" Grid.Row="1" Height="23" HorizontalAlignment="Left" Margin="3" Name="billingAddress2TextBox" Text="{Binding Path=BillingAddress2, Mode=TwoWay, ValidatesOnExceptions=true, NotifyOnValidationError=true}" VerticalAlignment="Center" Width="120" /&gt; &lt;sdk:Label Content="Contect Name:" Grid.Column="0" Grid.Row="2" HorizontalAlignment="Left" Margin="3" VerticalAlignment="Center" /&gt; &lt;TextBox Grid.Column="1" Grid.Row="2" Height="23" HorizontalAlignment="Left" Margin="3" Name="contectNameTextBox" Text="{Binding Path=ContectName, Mode=TwoWay, ValidatesOnExceptions=true, NotifyOnValidationError=true}" VerticalAlignment="Center" Width="120" /&gt; &lt;sdk:Label Content="Num Of Ads:" Grid.Column="0" Grid.Row="3" HorizontalAlignment="Left" Margin="3" VerticalAlignment="Center" /&gt; &lt;TextBox Grid.Column="1" Grid.Row="3" Height="23" HorizontalAlignment="Left" Margin="3" Name="numOfAdsTextBox" Text="{Binding Path=NumOfAds, Mode=TwoWay, ValidatesOnExceptions=true, NotifyOnValidationError=true}" VerticalAlignment="Center" Width="120" /&gt; &lt;sdk:Label Content="Num Of Months:" Grid.Column="0" Grid.Row="4" HorizontalAlignment="Left" Margin="3" VerticalAlignment="Center" /&gt; &lt;TextBox Grid.Column="1" Grid.Row="4" Height="23" HorizontalAlignment="Left" Margin="3" Name="numOfMonthsTextBox" Text="{Binding Path=NumOfMonths, Mode=TwoWay, ValidatesOnExceptions=true, NotifyOnValidationError=true}" VerticalAlignment="Center" Width="120" /&gt; &lt;sdk:Label Content="Phone Number:" Grid.Column="0" Grid.Row="5" HorizontalAlignment="Left" Margin="3" VerticalAlignment="Center" /&gt; &lt;TextBox Grid.Column="1" Grid.Row="5" Height="23" HorizontalAlignment="Left" Margin="3" Name="phoneNumberTextBox" Text="{Binding Path=PhoneNumber, Mode=TwoWay, ValidatesOnExceptions=true, NotifyOnValidationError=true}" VerticalAlignment="Center" Width="120" /&gt; &lt;sdk:Label Content="Rate Of Play:" Grid.Column="0" Grid.Row="6" HorizontalAlignment="Left" Margin="3" VerticalAlignment="Center" /&gt; &lt;TextBox Grid.Column="1" Grid.Row="6" Height="23" HorizontalAlignment="Left" Margin="3" Name="rateOfPlayTextBox" Text="{Binding Path=RateOfPlay, Mode=TwoWay, ValidatesOnExceptions=true, NotifyOnValidationError=true}" VerticalAlignment="Center" Width="120" /&gt; &lt;sdk:Label Content="Total Due:" Grid.Column="0" Grid.Row="7" HorizontalAlignment="Left" Margin="3" VerticalAlignment="Center" /&gt; &lt;TextBox Grid.Column="1" Grid.Row="7" Height="23" HorizontalAlignment="Left" Margin="3" Name="totalDueTextBox" Text="{Binding Path=TotalDue, Mode=TwoWay, ValidatesOnExceptions=true, NotifyOnValidationError=true}" VerticalAlignment="Center" Width="120" /&gt; &lt;/Grid&gt; &lt;/Grid&gt; </code></pre> <p>When the user clicks the submit button, you can use something like this:</p> <pre><code>private void Button_Click(object sender, RoutedEventArgs e) { var currentCustomer = this.DataContext as Customer; var previewWindow = new PrintPreviewWindow(currentCustomer); previewWindow.Show(); } </code></pre> <p>For this to work you'll need to have a Silverlight ChildWindow like this:</p> <pre><code>public partial class PrintPreviewWindow : ChildWindow { public PrintPreviewWindow(Customer customer) { InitializeComponent(); this.DataContext = customer; } private void OKButton_Click(object sender, RoutedEventArgs e) { this.DialogResult = true; } private void CancelButton_Click(object sender, RoutedEventArgs e) { this.DialogResult = false; } } </code></pre> <p>So your MainPage creates a new instance of the PrintPreviewChildWindow (could be a page as well if you prefer) and passes along the customer instance. The ChildWindow can then do whatever it wants with it. When the ChildWindow closes, you'll probably want to empty the input page, you can do this by simply setting the data context again:</p> <pre><code>this.DataContext = new Customer(); </code></pre> <p>I'm guessing this is what you are looking for.</p> <p>Try to get into the whole data binding stuff, it will save you lots and lots of lines of code. And let us know if this answers your question or if you have more :-)</p>
    singulars
    1. This table or related slice is empty.
    1. POIs there a Silverlight equivalent to "Application.OpenForms"?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USTimothyP
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POIs there a Silverlight equivalent to "Application.OpenForms"?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYes that is absolutely what I was asking. Let me try this out in my code and I'll let you know if I have any more questions, but this definitely looks to be everything I was needing and more! Thank you so much!
      singulars
      1. PO
      1. USAmbiguousX
    2. COTimothyP, I am having trouble with the printing functionality. I have tried entering the code you provided (with adjustments to fit my variables, etc.) and objects such as "PrintPreviewWindow" are not registering: the compiler is throwing up an error suggesting a missing assembly reference/using directive. I have made sure to add the "System.Windows.Printing;" directive in my Using statements, but still nothing. I have looked on MSDN, as well as various other forums to see if there is something I am missing, but I'm just not seeing it.
      singulars
      1. PO
      1. USAmbiguousX
    3. CO(cont'd) I know I'm a rookie so it very well may be something minor, a "silly beginner's mistake" kind of thing, but I was just wondering if you knew of anything that might be missing? or anything I'm doing wrong? If you need any more code snippets or any more detailed information please let me know. Thank you!
      singulars
      1. PO
      1. USAmbiguousX
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload