UWP编程基础

static void Main(string[] args)
{
    Thread thread = new Thread(cal);
    thread.Start();
}
 
public static void cal()
{
    Console.Write("123");
    Console.ReadLine();
}

Task.Run(() => _Login(username, password));

private async void onLoginClick(object sender, RoutedEventArgs e)
{
    //获取用户名和密码,以便异步调用
    string username = text1.Text;
    string password = text2.Password;
    //按钮不可用
    SetAvailable(false);
    //异步执行检查代码,防止UI线程卡死
    await Task.Run(() => _Login(username, password));
    //按钮可用
    SetAvailable(true);
}

CoreApplication.MainView.CoreWindow.Dispatcher.RunAsync(Priority, () => { action(); })

public async static void Invoke(Action action, CoreDispatcherPriority Priority = CoreDispatcherPriority.Normal)
        {
            await CoreApplication.MainView.CoreWindow.Dispatcher.RunAsync(Priority, () => { action(); });
        }

Invoke(() =>
{
    MessageDialog dialog = new MessageDialog("内容")
        {
            Title = "标题"
        };
        dialog.Commands.Add(new UICommand("好的"));
        dialog.DefaultCommandIndex = 0;
        dialog.CancelCommandIndex = 1;
    dialog.ShowAsync();
});

public static void JumpTo(Type page)
{
    Frame root = Window.Current.Content as Frame;
    Windows.UI.Core.SystemNavigationManager.GetForCurrentView().BackRequested += OnBackClick;
    SystemNavigationManager.GetForCurrentView().AppViewBackButtonVisibility = root.CanGoBack ? AppViewBackButtonVisibility.Visible : Windows.UI.Core.AppViewBackButtonVisibility.Collapsed;
    root.Navigated += OnNavigated;
    root.Navigate(page);
}
private static void OnBackClick(object sender, BackRequestedEventArgs e)
{
    Frame rootFrame = Window.Current.Content as Frame;
    if (rootFrame == null)
        return;
    if (rootFrame.CanGoBack && e.Handled == false)
    {
        e.Handled = true;
        rootFrame.GoBack();
    }
}

JumpTo(typeof(MyPage));

private static Color color = new Color() 
{ 
    A = 255, 
    R = 0, 
    G = 255, 
    B = 0 
};

public static SolidColorBrush brush = new SolidColorBrush(color);

text1.Foreground = brush;

LinearGradientBrush brush = new LinearGradientBrush();
GradientStop gradientStop1 = new GradientStop();
GradientStop gradientStop2 = new GradientStop();

gradientStop1.Color = new Windows.UI.Color() { A = 255, R = 255, G = 0, B = 0 };
gradientStop1.Offset = 0;
gradientStop2.Color = new Windows.UI.Color() { A = 255, R = 0, G = 0, B = 255 };
gradientStop2.Offset = 1;
brush.GradientStops.Add(gradientStop1);
brush.GradientStops.Add(gradientStop2);
brush.StartPoint = new Point(0, 0);
brush.EndPoint = new Point(1, 0);
grid.Background = brush;

private const string DATABASE_SERVER = "localhost";
private const string DATABASE_NAME = "dearxuan";
private const string DATABASE_USER = "root";
private const string DATABASE_PASSWORD = "root";
private const string DATABASE_PORT = "3306";
private const string SQL_CONNECTION_STR = 
    "server=" + DATABASE_SERVER + 
    ";user=" + DATABASE_USER + 
    ";database=" + DATABASE_NAME + 
    ";port=" + DATABASE_PORT + 
    ";password=" + DATABASE_PASSWORD + 
    ";SslMode=None";

private static MySqlConnection connection;
private static MySqlCommand command;
private static MySqlDataReader reader;

//建立连接
connection = new MySqlConnection(SQL_CONNECTION_STR);
connection.Open();
 
//执行语句
command = new MySqlCommand(“SELECT * FROM dearxuan”, connection);
 
//获取结果集
reader = command.ExecuteReader();
while (reader.read())
{
    //读取第一项和第二项
    string username = reader[0].ToString();
    string password = reader[1].ToString();
}

string sql = "SELECT * FROM dearxuan WHERE username=@username AND password=@password"
command = new MySqlCommand(sql, connection);
command.Parameters.AddWithValue("username", username);
command.Parameters.AddWithValue("password", password);
reader = command.ExecuteReader();