Sense VS Sensibility

2010年3月29日星期一

20100327 GARMIN 北宜之旅

中途休息站，坪林陳德利茶莊，我與 Partner

北宜公路最高點

鳥瞰蘭陽平原

礁溪火車站月台

兩鐵專車

2010年3月25日星期四

MusicCopy

中文版

April 6, 2010 MusicCopy 0.6.1 Released Download

This is bug-fix release.
Fixed:

Prefix error
Parse mp3 tag information error

April 2, 2010 MusicCopy 0.6 Released Download

New function:

About

Move & Sort

Display

"MusicCopy" is a small software to copy music files(MP3, WMA) from computer to the USB device.

OS: Windows XP Above (Tested on WinXP, Vista 32 bit, Win7 64 bit)
Library: .Net Framework 3.5 SP1 (Download) Note! Install this before excute.
Program: Download from here. Extract and double-click MusicCopy.exe

Tool Bar

Copy

Target Folder

Option

Start and Stop

Device List

This window will display all removable devices in this computer. You could see the basic information of the device, including the drive label, size, available size and the file system. Select the target device which to be copied.

About

Introduce the purpose of this software.

Header Information

Song List

Command Bar

Status

2010年3月22日星期一

汐止 ←→ 冷水坑 (小 3P)

去程：汐止國泰醫院→汐萬路→五指山涼亭→風櫃嘴→楓林橋→至善路→至善路71巷→平菁街→菁山路→菁山路101巷→冷水坑遊客服務站

回程：冷水坑遊客服務站→菁山路101巷→菁山路→平菁街→至善路71巷→至善路→楓林橋→風櫃嘴→五指山涼亭→汐萬路→汐止國泰醫院

總里程：78.41KM
總騎乘時間：5:48:39

行程圖片

2009年12月17日星期四

LINQ and Deploying SQL Server CE 3.5

I have to use INNO Setup to deploy my WPF desktop application with LINQ and SSCE.

On my development desktop, everything is fine. But when I installed the package on another VMs(Win7 and WinXP), it crashed. Then I checked the exception and figured out the reason is connecting DB error. I compared the environment between my development desktop and the VMs. The suspect is Microsoft SQL Server Compact 3.5 SP1 English. It means that I need the runtime of SSCE.

I have 2 choices to solve this problem. One is to install SSCERuntime-ENU-x86.msi during the installation, and the other is to put necessary drivers with AP.

Install SSCE runtime during setup


    [Files]
    Source: SSCERuntime-ENU-x86.msi; DestDir: {tmp}; Flags: deleteafterinstall


    RegKeyExists(HKLM, 'Software\Microsoft\Microsoft SQL Server Compact Edition\v3.5');


    ExtractTemporaryFile('SSCERuntime-ENU-x86.msi');
    Exec('msiexec',ExpandConstant('/i "{tmp}\SSCERuntime-ENU-x86.msi" /qb'),'', SW_SHOW, ewWaitUntilTerminated, ResultCode);

Prepare the necessary SSCE drivers

LINQ and Deploying SQL Server CE 3.5


<configuration>
    <system.data>
        <DbProviderFactories>
            <remove invariant="System.Data.SqlServerCe.3.5" />
            <add name="Microsoft SQL Server Compact Data Provider"
                    invariant="System.Data.SqlServerCe.3.5"
                    description=".NET Framework Data Provider for Microsoft SQL Server Compact"
                    type="System.Data.SqlServerCe.SqlCeProviderFactory,
                            System.Data.SqlServerCe,
                            Version=3.5.1.0,
                            Culture=neutral,
                            PublicKeyToken=89845dcd8080cc91"/>
        </DbProviderFactories>
    </system.data>
</configuration>

2009年12月3日星期四

Windows Major, Minor Version

2009年11月30日星期一

Exercises : C++ How to Program, Fifth Edition

Developement Environment: Dev-C++ 4.9.9.2

3.11

GradeBook.h


#include 
using std::string;

class GradeBook
{
    public:
        GradeBook(string, string);
        void setCourseName(string);
        string getCourseName();
        void setCourseInstructorName(string);
        string getCourseInstructorName();
        void displayMessage();
        
    private:
        string courseName;
        string courseInstructorName;        
};

GradeBook.cpp


#include 
using std::cout;
using std::endl;

#include "GradeBook.h"

GradeBook::GradeBook(string name, string insName)
{
    setCourseName(name);
    setCourseInstructorName(insName);
}

void GradeBook::setCourseName(string name)
{
    courseName = name;    
}

string GradeBook::getCourseName()
{
    return courseName;
}

void GradeBook::setCourseInstructorName(string insName)
{
    courseInstructorName = insName;    
}

string GradeBook::getCourseInstructorName()
{
    return courseInstructorName;
}

void GradeBook::displayMessage()
{
    cout << "Welcome to the grade book for\n" << getCourseName() << "!" << 
            "\nThis course is presented by:" << getCourseInstructorName() 
            << endl;
}

main.cpp


#include 
using std::cout;
using std::endl;

#include "GradeBook.h"

int main(int argc, char *argv[])
{
    GradeBook gradeBook1("CS101 Instroduction to C++ Programming", "John");    
    
    gradeBook1.displayMessage();
    
    system("PAUSE");
    return EXIT_SUCCESS;
}

Output

here

3.12

Account.h


#include 
using std::string;

class Account
{
    public:
        Account(int);
        void credit(int);    
        void debit(int);
        int getBalance();
        
    private:
        int balance;        
};

Account.cpp


#include 
using std::cout;
using std::endl;

#include "Account.h"

Account::Account(int initAmount)
{
    if(initAmount < 0)
    {
        balance = 0;
        cout << "ERROR!!! The initial balance was invalid.\n";                
    }
    else
        balance = initAmount;
    
}

void Account::credit(int amount)
{
    balance += amount;
}

void Account::debit(int amount)
{
    if(amount > balance)
    {
        cout << "ERROR!!! Debit amount exceeded account balance.\n";
        return;
    }
    balance -= amount;
}

int Account::getBalance()
{
    return balance;
}

main.cpp


#include 
using std::cout;
using std::endl;

#include "Account.h"

int main(int argc, char *argv[])
{
    Account acct1(-10);
    cout << "Acct 1, Balance => $" << acct1.getBalance() << "\n"; 
    acct1.credit(100);
    cout << "Acct 1, Balance => $" << acct1.getBalance() << "\n"; 
    
    
    Account acct2(1000);    
    cout << "Acct 2, Balance => $" << acct2.getBalance() << "\n";
    acct2.debit(2000);
    cout << "Acct 2, Balance => $" << acct2.getBalance() << "\n";
        
    system("PAUSE");
    return EXIT_SUCCESS;
}

Output

here

2009年11月27日星期五

WPF DataGrid

1. Create a WPF Application through Visual Studio 2008 SP1 and Dot Net Framework 3.5 SP1.

In Windows1.xaml


< Window x:Class="WpfDataGrid.Window1"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:dg="http://schemas.microsoft.com/wpf/2008/toolkit"
        Title="Window1" Height="300" Width="600">
    
        
            
                
                    < dg:DataGridTextColumn Header="First Name" Binding="{Binding Path=FirstName}"/>
                    < dg:DataGridTextColumn Header="Last Name" Binding="{Binding Path=LastName}"/>
                    < dg:DataGridTextColumn Header="Address" Binding="{Binding Path=Address}"/>
                    < dg:DataGridCheckBoxColumn Header="New?" Binding="{Binding Path=IsNew}"/>
                    < dg:DataGridCheckBoxColumn Header="Subscribed?" Binding="{Binding Path=IsSubscribed}"/>

In Windows1.xaml.cs
First, define a class to generate data to display.


public class Customer
{
    public String FirstName { get; set; }
    public String LastName { get; set; }
    public String Address { get; set; }
    public Boolean IsNew { get; set; }

    // A null value for IsSubscribed can indicate
    // "no preference" or "no response".
    public Boolean? IsSubscribed { get; set; }

    public Customer(String firstName, String lastName,
        String address, Boolean isNew, Boolean? isSubscribed)
    {
        this.FirstName = firstName;
        this.LastName = lastName;
        this.Address = address;
        this.IsNew = isNew;
        this.IsSubscribed = isSubscribed;
    }

    public static ObservableCollection GetSampleCustomerList()
    {
        return new ObservableCollection (new Customer[4] {
            new Customer("A.", "Zero",
                "12 North Third Street, Apartment 45",
                false, true),
            new Customer("B.", "One",
                "34 West Fifth Street, Apartment 67",
                false, false),
            new Customer("C.", "Two",
                "56 East Seventh Street, Apartment 89",
                true, null),
            new Customer("D.", "Three",
                "78 South Ninth Street, Apartment 10",
                true, true)
        });
    }
}

By this way, we could see the simple WPF DataGrid.

Run this program, one problem occured. If you would like to change the status of the checkbox, you have to click twice. First click will focus on the row, and second click will change the state of the checkbox.
The solution is to use DataGridTemplateColumn to replace the DataGridCheckBoxColumn.

At this moment, everything seems to be ok. But in practice, if we could not make sure how many columns we have, what should we do?
So we need to create DataGrid programmatically.

In Windows1.xaml, we don't need the defination of the columns, just leave the declaration of < dg:DataGrid/>.


< Window x:Class="WpfDataGrid.Window1"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:dg="http://schemas.microsoft.com/wpf/2008/toolkit"
        Title="Window1" Height="300" Width="600">
    
        
            < dg:DataGrid AutoGenerateColumns="False" Margin="22,24,20,26" Name="dataGrid"/>

In Windows.xaml.cs, I wrote a method InitDataGrid and put it after InitializeComponent().


private void InitDataGrid()
{
    dataGrid.ItemsSource = Customer.GetSampleCustomerList();

    dataGrid.Columns.Clear();

    dataGrid.Columns.Add(GetTextColumn("First Name", "FirstName"));
    dataGrid.Columns.Add(GetTextColumn("Last Name", "LastName"));
    dataGrid.Columns.Add(GetTextColumn("Address", "Address"));
    dataGrid.Columns.Add(GetCheckBoxColumn("New?", "IsNew"));
    dataGrid.Columns.Add(GetCheckBoxColumn("Subscribed?", "IsSubscribed"));
}


private DataGridTextColumn GetTextColumn(string _header, string _binding)
{
    DataGridTextColumn col = new DataGridTextColumn();
    col.Header = _header;
    if (_binding != null && _binding != "")
        col.Binding = GetBinding(_binding, BindingMode.OneWay);
    return col;
}


private DataGridTemplateColumn GetCheckBoxColumn(string _header, string _binding)
{
    DataGridTemplateColumn col = new DataGridTemplateColumn();
    col.Header = _header;

    Dictionary values = new Dictionary();
    //values.Add(CheckBox.StyleProperty, FindResource("DataGridCheckBoxStyle"));

    Dictionary bindings = new Dictionary();
    bindings.Add(CheckBox.IsCheckedProperty, GetBinding(_binding, BindingMode.TwoWay));

    col.CellTemplate = GetDataTemplate(typeof(CheckBox), values, bindings);
    return col;
}


private DataTemplate GetDataTemplate(Type _t, Dictionary _values,
        Dictionary _bindings)
{
    DataTemplate dt = new DataTemplate();
    FrameworkElementFactory factory = new FrameworkElementFactory(_t);
    dt.VisualTree = factory;
    //SetValue
    foreach (KeyValuePair kvp in _values)
    {
        factory.SetValue(kvp.Key, kvp.Value);
    }
    //SetBinding
    foreach (KeyValuePair kvp in _bindings)
    {
        factory.SetBinding(kvp.Key, kvp.Value);
    }
    return dt;
}


private Binding GetBinding(string _path, BindingMode _mode)
{
    Binding binding = new Binding();
    binding.Path = new PropertyPath(_path);
    binding.Mode = _mode;
    return binding;
}

You could download the solution from here.
If you use Firefox, you may see strange syntax. If so, try to use IE or just download the source code.

訂閱：文章 (Atom)

2010年3月29日 星期一

2010年3月25日 星期四

2010年3月22日 星期一

2009年12月17日 星期四

2009年12月3日 星期四

2009年11月30日 星期一

2009年11月27日 星期五