Tuesday, January 30, 2018

ListView XAML Control in a Universal Windows Platform project

I have posted a number of articles related to ListBlock, ListView etc that you can use in HTML 5, web applications using Intel's XDK. Intel XDK's development platform for several frameworks were discontinued and Intel's effort is in the realm of Internet of Things devices and related applications.

Microsoft's Universal Windows Framework apps are well supported by Microsoft and you could use it for not only Windows but for other devices as well.

In the Universal Windows Platform (UWP) projects there is an advantage of one code that works on different device families (phone, tablet, desktop etc.). However, the UWP projects depend on using XAML. For example the 'List' related controls in UWP are as shown here:


In this post, I will show you how you may work with this controls for a UWP project.

Getting the ListView Control
Placing ListView on the Design area
Adding Textbox Controls to ListView
Making changes to XAML Code

We start with a Windows Universal blank C# project with the name JLIST as shown.



You will be asked for what target and minimum versions of Windows 10 that you want. The higher the version the more feature support. The Build version 16299 is chosen for both as shown in the next two images.



Clicking OK after the selection brings creates a blank project very the same along the lines in my earlier link.

Now we would like to place controls and therefore we need to choose what controls to use from the following:


When you click on the above, you are taken to this interactive window. You are using the Windows Presentation Foundation controls.

There are quite a large with a few added by default should you choose. However you can filter (List) and get a shorter list that you want to choose. You can choose ListView.

As I previously mentioned the UWP is supported on all devices of Windows Family and therefore uses a common layout scheme which adjusts to the device footprint as shown (for 4 different devices from Phone to Desktop).

Dropping a ListView Control

All that is need is to drag and drop a control from here:

On to the design area here. I am designing for a 6" Phone format. The XAML code shows one line item inside the Grid as shown.

Adding items to the ListView, bunch of TextBoxes. You can just type-in or wait for intellisense to come to you rescue.


The interface is highly interactive, immediately these TextBoxes appear in the design as shown. Note that 'Jasmine' is not showing fully.

Although you could easily check for the device sizes from this interface. Although Visual Studio supports all the device sizes, but still it cannot accommodate 4" IOT as the ListView itself is quite large to get into an IoT as shown here:


In order to accommodate 'Jasmine', I have slightly played with the height (change 100 to 118) of ListView as shown.


TextBoxes also have a property called , IsColorFontEnabled and when choose to set it to TRUE, you can have access to lot more properties related color and other. I just chose to change the color of 'Lily' to blue.


Sure enough, the color changes to blue as shown in the rendered image when deployed to the machine (only relevant part shown).

I the next post, let us see how we may add controls to ListView using code behind.

----------------------------------------------------------------------------------------------------------------------
Intel XDK HTML Projects

Sortable ListBlock Widget using Intel XDK

Develop a Side Menu App using Intel XDK

Part 1:Creating a Intel XDK project using a template; SideMenu project UI, SideMenu on iPhone6 emulator



Part 2: Review of Controls and Layout as well as working with Pages. Pages in a SideMenu

http://hodentekmobile.blogspot.com/2015/12/develop-side-menu-app-using-intel-xdk.html


Part 3: Linking the pages and Navigation

http://hodentekmobile.blogspot.com/2015/12/develop-side-menu-app-using-intel-xdk_19.html


Part 4: Adding the BACK button to return to the previous page.

http://hodentekmobile.blogspot.com/2015/12/develop-side-menu-app-using-intel-xdk_26.html


Part 5: Adding pages and organizing controls  to the project

http://hodentekmobile.blogspot.com/2016/01/develop-side-menu-app-using-intel-xdk.html

Friday, January 26, 2018

Compatibility level of SQL Server

The compatibility level of a SQL Server database matters since the T-SQL code from a higher compatibility level will not work in a database with lower compatibility level.

How to find compatibility level?

Launch SQL Server Management Studio and pick the database for which you want to find the compatibility level.

Right click the database node for the database TestPubs. From the drop-down pick Properties. In the properties page click Options and you will find the compatibitlity level as shown. This is for SQL Server 2012.


SQL Server 2017: The compatibility level for Northwind (SqlServer 2008(100) restored from a backup file from CodePlex site is the following:







Thursday, January 25, 2018

Backup a database using a file using Micrsoft SQL Operations Studio

It is quite easy. In fact you can restore Northwind database from the CodePlex site to SQL Server 2017 Developers edition.

Watch this video on YouTube for a step-by-step procedure:

Read this post of how you may do this using SQL Server Management Studio:


If you are interested in installing SQL Server 2017 Developer Edition on Windows 10 Pro.
Read this post:

Restore a database using Windows PowerShell:

Saturday, January 20, 2018

Problem with Windows 10 Pro Insider Preview

At present I have this version:
Build 17025.rs_prerelease.171020-1626

All of a sudden you see a number of bad behaviors only for two of which I have the screen shots.

Suddenly File Manager misbehaves, I cannot see the bread crumb in the file manager.


WindowsProblem1

Right click does not have a context sensitive menu anymore but a vertical rectangle of narrow width.




WindowsProblem2

UPDATE  2/28/2018   

Build 17074.rs_prerelease-flt.180116-1539

This is another type of error:

I want to read the document, the pane is locked. I cannot expand it.


Update 3/3/2018

A web page title is left hanging on the desktop that does not go away.


 

Friday, January 19, 2018

Install January Public Preview (ver 0.25.4) of Microsoft SQL Operations Studio

Screen shots taken while installing the January Public Preview (ver 0.25.4) of Microsoft SQL Operations Studio (MSFT SQLOPS) are included in this post. The details of this version are as shown:


SQLOPS_JANPreview.png

MSFT SQLOPS will be installed on a Windows 10 Professional on a Dell Laptop.


SQLOPS_JanPublicPreview9_Win.png

We will use the installer route to install. You start installing by double clicking the installer file you downloaded.


SQLOPS_JanPublicPreview2


SQLOPS_JanPublicPreview3

Accept license terms and click Next.


SQLOPS_JanPublicPreview4


SQLOPS_JanPublicPreview5


SQLOPS_JanPublicPreview6


SQLOPS_JanPublicPreview7

SQLOPS_JanPublicPreview8

It is installed and it is launched as shown




DMCA.com Protection Status