Last post Apr 06, 2008 10:26 AM by fossil83
Apr 04, 2008 08:11 PM|fossil83|LINK
I'm struggeling here with SQL Server Mobile Edition 3.0, Visual Studio 2005 and C# application im designing on my HP iPAQ hx2790b.
I'm doing a simple select, inner join, and parameter query as a dataset (is this the best way - recommend another way - view maybe?)
I've got two tables; tblLocation, and tblUsers
1, South Africa
userID, Name, Surname, locationID
1, Harry, Potter, 2
2, Hendrik, Potgieter, 1
3, Koos, Pieterse, 3
4, Robert, Mugabe, 2
On the screen, the user should select his location first, and then the database will narrow it down to his name(according to his country where he stays in)
So, you would have a drop down menu, select country, and another drop down menu underneath, should only show users assigned to that locationID.
The problem lies with the parameters and the controls. I know in ASP.NET you can assign a variable/parameter to a control. How do you do it in WM5 SDK?
PS* I'm trying to do all of this the "visual" way, so if anyone could send some screenshots, i would appreciate it.
SQL Server Mobile Edition
SQL Server Compact Edition
Apr 06, 2008 10:26 AM|fossil83|LINK
Never mind, i found some video tutorials on channel9