wpfdatavideos Forum Rss Feed

NEW POST: Wpf

deWouters — Mon, 12 Oct 2009 15:51:52 GMT

Hi,
try this process, it might work:
When you are in the Form1's code behind, Write this:

Dim Win2 As New Window2()
Me.Hide()
Win2.Show()

And that's all!
;o))

NEW POST: Wpf

GopalKrishna — Mon, 28 Sep 2009 13:47:27 GMT

Hello,
i am new to wpf i created a couple of windows, i want to close the one when i open the other vb code doesnt seem to work.
when i say

me.close()
Dim win2 as new window2
win2.show()

when the above is used individually it works but when both are put together there is no error but even the window exits.

NEW POST: Filtering Details View

ikondrasovas — Wed, 09 Sep 2009 12:43:01 GMT

Hello,

After watching the video #5 How Do I: Build a WPF Master-Detail Data Entry Form Using Entity Framework? I'm trying to filter the detail view. Instead of filtering details in the LINQ to Entities expression and firing another DB query, I would like to filter it using the ListCollectionView Filter event or some other approach. However, as you can see in the video, the details view bind to a BindingListCollectionView, witch does not support filtering.

How could I perform a filtering on the details view?

Thanks in Advance,

Igor

NEW POST: Any Questions?

Shiv — Fri, 04 Sep 2009 02:48:11 GMT

BethMassi wrote:
Any questions?

Hi Beth,

I am new to WPF and and have been following your "WPF Forms over data videos" and comfortable with the process of building database apps according to the procedure you have explained. Now I find this new category "WPF Forms with Entity Framework Video Series". Please advise when to use the entity framework and benefits in this method. Thanks.

NEW POST: Any Questions?

BethMassi — Thu, 02 Jul 2009 00:54:20 GMT

Hi StatWC,

It would depend on how you are accessing your database. But ff you are using TableAdapters you just need to create a parameterized query like I explained to MarkvL above.

HTH,
-B

NEW POST: Any Questions?

BethMassi — Thu, 02 Jul 2009 00:48:12 GMT

Hi FrankTL,

I can't really tell what's wrong from that code. Are you able to step into the click handlers for the buttons? When you click Save does HasChanges return True?

-B

NEW POST: Sample database not referenced ?

BethMassi — Thu, 25 Jun 2009 22:00:03 GMT

Hi dibblm,

All the videos are here: http://msdn.microsoft.com/en-us/vbasic/bb466226.aspx

Here's the one where we created the database: http://msdn.microsoft.com/en-us/vbasic/bb643825.aspx

HTH,
-Beth

NEW POST: Sample database not referenced ?

dibblm — Fri, 05 Jun 2009 14:13:54 GMT

found the data in the sample. However I still don't know what video you were refferencing in this video where you stated the datbase was created in the previous video ?

NEW POST: Sample database not referenced ?

dibblm — Fri, 05 Jun 2009 14:11:41 GMT

In the video you mention the database was done in a previous video. However I dont find any mention to either which video was used or a sample for the layout.

Can you reference the video you were reffering to please or include the layout ?

NEW POST: Any Questions?

StatWC — Fri, 08 May 2009 17:05:55 GMT

Beth,

I had a question on a search function myself. I use C#. I want to have a text box that I type in a name or a number such as a license plate number and have it search all the entries in my database when I click the Search button based on the query I created. any help you can provied would be greatly appreciated!

NEW POST: Any Questions?

FrankTL — Fri, 13 Feb 2009 21:31:29 GMT

Beth,

First let me thank you for this fantastic series and all the hard work you've put into it. I've been a COBOL programmer for over a decade, and am now expanding into the OO programming world. I jumpstarted right into the "WPF Data Entry" project, and I've been trying to modify the code to accommodate a local database I created. It's a simple contact database, with ID (primary key/identifier) FirstName, LastName, email, and Phone. While I was able to get the window created and the code converted to the point it builds without error, unfortunately none of the buttons seem to work - that is, none of the data updates as far as I can tell. I can input the data, but nothing gets done with it. Below is my code from Window1.xaml.cs (yes, using C# here as I am more familiar with it than VB), and I was hoping you could see what it is that I am doing wrong, and what is preventing my table from updating. Thanks in advance for your (or anyone else's) help!
***************************
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;

namespace WpfDataEntry
{
/// <summary>
/// Interaction logic for Window1.xaml
/// </summary>
public partial class Window1 : Window
{
public Window1()
{
InitializeComponent();
}

private Contacts3DataSet ContactData = new Contacts3DataSet();
private Contacts3DataSetTableAdapters.ContactsTableTableAdapter taCust = new Contacts3DataSetTableAdapters.ContactsTableTableAdapter();
private Contacts3DataSetTableAdapters.TableAdapterManager taManager = new Contacts3DataSetTableAdapters.TableAdapterManager();
private CollectionView View;

private void Window1_Loaded(object sender, System.Windows.RoutedEventArgs e)
{
this.taCust.Fill(this.ContactData.ContactsTable);
this.taManager.ContactsTableTableAdapter = taCust;
this.DataContext = this.ContactData.ContactsTable;
this.View = (CollectionView) (CollectionViewSource.GetDefaultView(this.ContactData.ContactsTable));
}

private void btnFirst_Click(object sender, System.Windows.RoutedEventArgs e)
{
this.View.MoveCurrentToFirst();
}

private void btnPrevious_Click(object sender, System.Windows.RoutedEventArgs e)
{
if ((this.View.CurrentPosition > 0))
{
this.View.MoveCurrentToPrevious();
}
}

private void btnNext_Click(object sender, System.Windows.RoutedEventArgs e)
{
if ((this.View.CurrentPosition < (this.View.Count - 1)))
{
this.View.MoveCurrentToNext();
}
}

private void btnLast_Click(object sender, System.Windows.RoutedEventArgs e)
{
this.View.MoveCurrentToLast();
}

private void btnDelete_Click(object sender, System.Windows.RoutedEventArgs e)
{
if ((this.View.CurrentPosition > -1))
{
var row = ((System.Data.DataRowView)(this.View.CurrentItem)).Row;
row.Delete();
}
}

private void btnAdd_Click(object sender, System.Windows.RoutedEventArgs e)
{
//var row = this.ContactData.Customer.NewCustomerRow();

var row = this.ContactData.ContactsTable.NewContactsTableRow();
row.LastName = "New";
//this.ContactData.Customer.AddCustomerRow(row);
this.ContactData.ContactsTable.AddContactsTableRow(row);
this.View.MoveCurrentToLast();
}
private void btnRevert_Click(object sender, System.Windows.RoutedEventArgs e)
{
//if (this.CustomerData.HasChanges())
if (this.ContactData.HasChanges())
{
if ((MessageBox.Show("Are you sure you want to lose all your changes?", this.Title, MessageBoxButton.YesNo) == MessageBoxResult.Yes))
{
//this.CustomerData.RejectChanges();
this.ContactData.RejectChanges();
}
}
}
private void btnSave_Click(object sender, System.Windows.RoutedEventArgs e)
{
try
{
// if (this.CustomerData.HasChanges())
if (this.ContactData.HasChanges())
{
//if ((this.taManager.UpdateAll(this.CustomerData) > 0))
if ((this.taManager.UpdateAll(this.ContactData) > 0))
{
MessageBox.Show("Saved.");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}

}
}

NEW POST: Any Questions?

AtifAli — Tue, 21 Oct 2008 11:38:55 GMT

Hey Beth:
I m Atif a newly entered in the .NET world....
I have seen your Videos and it helped me alot for learning this leveraging technology

Thanksss Alot for making such a nice series.
Keeep doing that.....

NEW POST: Any Questions?

BethMassi — Wed, 27 Aug 2008 18:06:31 GMT

Mark,

You need to pass the parameter to the parameterized query ;-). Based on the number of parameters you are using in your SQL Server query, the desigenr creates a method with those number of parameters. You need to pass the values for it to work. Your errors are basic syntax errors that any method would raise if you were calling it incorrectly. Look at the intellisense for your method and it will guide you.

Me.taCust.FillByName(Me.CustomerData.Table1, "***PASS VALUE HERE****")

You should definitely read through the Getting Started and How To sections of the Library.
http://msdn.microsoft.com/en-us/vbasic/ms789093.aspx#Articles

HTH,
-B

NEW POST: Any Questions?

MarkvL — Wed, 27 Aug 2008 14:51:34 GMT

Well i did what you told me to do.
I created (once again) a new Query. Called it "FillByNaam". Yet now i only get funky errors like:
Error 1 Argument not specified for parameter 'naam' of 'Public Overridable Overloads Function FillByNaam(dataTable As DataSet1.Table1DataTable, naam As String) As Integer'. C:\Users\ZeroSlasher\Documents\Visual Studio 2008\Projects\WpfApplication1\WpfApplication1\Window1.xaml.vb 84 22 Ebike

And

Error 2 Value of type 'String' cannot be converted to 'WpfApplication1.DataSet1.Table1DataTable'. C:\Users\ZeroSlasher\Documents\Visual Studio 2008\Projects\WpfApplication1\WpfApplication1\Window1.xaml.vb 84 43 Ebike

Why are Search functions so difficult *pffffffff*

NEW POST: Any Questions?

BethMassi — Tue, 26 Aug 2008 23:39:36 GMT

Hi Mark,

I don't see where you are calling your parameterized query, it looks like you are sill calling Fill without any parameters. i.e. I still see:

Me.taCust.Fill(Me.CustomerData.Table1)
Me.DataContext = Me.CustomerData.Table1

To call the query you set up on the TableAdapter you call it by the name you specified in the query designer and then pass the parameter to it. Something like:

Me.taCust.FillByName(Me.CustomerData.Table1, "Some Name")
Me.DataContext = Me.CustomerData.Table1

HTH,
-Beth

NEW POST: Any Questions?

MarkvL — Tue, 26 Aug 2008 22:59:02 GMT

Hiya, been busy for a long time. Anyway in the meantime i have looked around, see what i've done wrong.
I'm frankly stucked a lot. Also i'm so new to all of this that i can't seem to figure out what it is that i'm doing wrong.
All i get now is Integer errors (mostly) and when i don't have any errors, it just isn't showing any results at all.
I'm not sure what to think more, it's slightly annoying that i can't even find the solution.
So... here is the entire code instead. I might be doing something wrong at the top or i'm just messing things up a lot.
What i have so far, is a Query named Search in Table1, that has the function "WHERE naam = @naam" .. i have to figure out how to add more cause it also has to look for address and zipcode and all.
Hopefully you can help me =)
(My apologies for the huge post)

Class Window1

Private CustomerData As New DataSet1
Private taCust As New DataSet1TableAdapters.Table1TableAdapter
Private taManager As New DataSet1TableAdapters.TableAdapterManager
Private View As CollectionView

Private Sub Window1_Loaded(ByVal sender As Object, ByVal e As System.Windows.RoutedEventArgs) Handles Me.Loaded
Me.taCust.Fill(Me.CustomerData.Table1)

Me.taManager.Table1TableAdapter = taCust

Me.DataContext = Me.CustomerData.Table1

Me.View = CollectionViewSource.GetDefaultView(Me.CustomerData.Table1)

End Sub

Private Sub btnFirst_Click(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles btnFirst.Click
Me.View.MoveCurrentToFirst()
End Sub

Private Sub btnPrevious_Click(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles btnPrevious.Click
If Me.View.CurrentPosition > 0 Then
Me.View.MoveCurrentToPrevious()
End If
End Sub

Private Sub btnNext_Click(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles btnNext.Click
If Me.View.CurrentPosition < Me.View.Count - 1 Then
Me.View.MoveCurrentToNext()
End If
End Sub

Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles btnDelete.Click
If Me.View.CurrentPosition > -1 Then
If MessageBox.Show("Weet je zeker dat je het wilt verwijderen?", Me.Title, MessageBoxButton.YesNo) = MessageBoxResult.Yes Then
Dim row = CType(Me.View.CurrentItem, System.Data.DataRowView).Row
row.Delete()
End If
End If
End Sub

Private Sub btnToevoegen_Click(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles btnToevoegen.Click
Dim row = Me.CustomerData.Table1.NewTable1Row
row.naam = "Verplicht"
Me.CustomerData.Table1.AddTable1Row(row)
Me.View.MoveCurrentToLast()
End Sub

Private Sub btnOpnieuw_Click(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles btnOpnieuw.Click
If Me.CustomerData.HasChanges Then
If MessageBox.Show("Weet je het zeker? Je verliest al je veranderingen?", Me.Title, MessageBoxButton.YesNo) = MessageBoxResult.Yes Then
Me.CustomerData.RejectChanges()
End If
End If
End Sub

Private Sub btnOpslaan_Click(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles btnOpslaan.Click
Try
If Me.CustomerData.HasChanges Then
If Me.taManager.UpdateAll(Me.CustomerData) > 0 Then
MsgBox("Opgeslagen.")
End If
End If
Catch ex As Exception
MsgBox(ex.ToString)
End Try
End Sub

Private Sub btnClose_Click(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles btnClose.Click
Me.Close()
End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles Button1.Click
Me.View.MoveCurrentToLast()
End Sub

Private Sub btnZoeken_Click(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles btnZoeken.Click
Try

If CType(Me.taCust.Search(Me.txtSearch.Text), Integer) > 0 Then
MsgBox("Klant Gevonden!")
Else
MsgBox("Klant niet Gevonden.")
End If

Catch ex As Exception

MsgBox(ex.ToString)

End Try
End Sub
End Class

NEW POST: Any Questions?

BethMassi — Mon, 28 Jul 2008 18:54:38 GMT

Hi Mark,

That sounds like a databinding issue. Make sure the window's DataContext is set to the instance of the dataset that is returned from the search.

HTH,
-B

NEW POST: Any Questions?

MarkvL — Sat, 26 Jul 2008 14:28:15 GMT

Hiya Beth,

That last post helped me out alot!!!
It works like a charm yet there's just one problem i'm stumbling on *sighs deeply once again*
The minute i write a name in the search box and click "Zoeken" (which is Find/Search) I get the msgbox saying "Customer found".
But how do i get it to actually view the results back on the page?
I'm kinda lost on that one and yet again browsed and tried many options. But they don't fill my textboxes with the data i searched for.

Here's a piece of code that i'm using currently:::

Private Sub btnZoeken_Click(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles btnZoeken.Click
Try

If CType(Me.taCust.Search(Me.txtSearch.Text), Integer) > 0 Then
MsgBox("Klant Gevonden!")
Else
MsgBox("Klant niet Gevonden.")
End If

Catch ex As Exception

MsgBox(ex.ToString)

End Try
End Sub

You can see it's familiar to the one in your blog and it perfectly works but it just doesn't show the proper results :)

Mark.

NEW POST: Any Questions?

BethMassi — Fri, 25 Jul 2008 04:02:29 GMT

Hi Mark,

The seach function is just standard TableAdapter stuff. You just need to specify a parameterized query to SQL server and a VB method will be generated on the TableAdapter which you call from your form. If you're having trouble with the SELECT syntax you can check out the SQL Server books online: http://msdn.microsoft.com/en-us/library/ms189826.aspx

For help with the TableAdapters see the library, this should be a good starting point: http://msdn.microsoft.com/en-us/library/ms171905.aspx

I also have an example of a parameterized query on my blog: http://blogs.msdn.com/bethmassi/archive/2007/05/25/creating-a-parameterized-query.aspx

HTH,
-B

NEW POST: Any Questions?

MarkvL — Thu, 24 Jul 2008 15:33:40 GMT

Well i'm pretty much lost on the Search function.
I have created a search button, browsed the net for the past 2 days to find a way to code it or to show it into the program.
But i cannot find the code nor do i understand how to actually write a name, hit the search button and the rest of the information shows up.
I've looked at other codes but they all do not do what i want to have.

:::
If you specify a WHERE clause then it will generate a method that you can call and pass the search parameter to it.
:::

I think i got the WHERE fixed and solved, but how do i create that search parameter?
All i have now is the "btnSearch" *shrugs*

Sorry for bugging you for all of this but i've been going on with this new stuff for 6 weeks and finding the right related stuff is harder than i thought.