public void SelectClicked(object sender, EventArgs e) { //Userテーブルの行データを取得 var query = UserModel008.selectUser(); var layout = new StackLayout { HorizontalOptions = LayoutOptions.Center, Margin = new Thickness { Top = 100 } }; foreach (var user in query) { //UserテーブルのId列とName列をLabelに書き出す layout.Children.Add(new Label { Text = user.Id.ToString() }); layout.Children.Add(new Label { Text = user.Name }); } Content = layout; }
private Entry InsertEntry; //テキストボックスの値を保持する public MainPage() { InitializeComponent(); var layout = new StackLayout { HorizontalOptions = LayoutOptions.Center, Margin = new Thickness { Top = 100 } }; //-----------------------------インサートするテキストボックス------------------- InsertEntry = new Entry { WidthRequest = 60 }; layout.Children.Add(InsertEntry); //-------------------------------インサートボタン------------------------------- var Insert = new Button { WidthRequest = 60, Text = "INSERT", TextColor = Color.Blue, }; layout.Children.Add(Insert); Insert.Clicked += InsertClicked; //--------------------------------デリートボタン------------------------------ var Delete = new Button { WidthRequest = 60, Text = "DELETE", TextColor = Color.Blue, }; layout.Children.Add(Delete); Delete.Clicked += DeleteClicked; //--------------------------------セレクトボタン------------------------------ var Select = new Button { WidthRequest = 60, Text = "SELECT", TextColor = Color.Blue, }; layout.Children.Add(Select); Select.Clicked += SelectClicked; //-----------------------------selectした結果がnullじゃなかったら(=表の中身が入っていたらselectメソッドを実行)---------------------- if (UserModel008.selectUser() != null) { var query = UserModel008.selectUser(); foreach (var user in query) { //Userテーブルの名前列をLabelに書き出す layout.Children.Add(new Label { Text = user.Id.ToString() }); layout.Children.Add(new Label { Text = user.Name }); } } Content = layout; }
/************************************インサートボタンが押されたら(長い)*****************************************/ public void InsertClicked(object sender, EventArgs e) { //Userテーブルに適当なデータを追加する UserModel008.insertUser(1, InsertEntry.Text); var layout = new StackLayout { HorizontalOptions = LayoutOptions.Center, Margin = new Thickness { Top = 100 } }; //ボタン再配置(見かけ上消えないようにする) //-----------------------------インサートするテキストボックス------------------- InsertEntry = new Entry { WidthRequest = 60 }; layout.Children.Add(InsertEntry); //-------------------------------インサートボタン------------------------------- var Insert = new Button { WidthRequest = 60, Text = "INSERT", TextColor = Color.Blue, }; layout.Children.Add(Insert); Insert.Clicked += InsertClicked; //--------------------------------デリートボタン------------------------------- var Delete = new Button { WidthRequest = 60, Text = "DELETE", TextColor = Color.Blue, }; layout.Children.Add(Delete); Delete.Clicked += DeleteClicked; //--------------------------------セレクトボタン------------------------------ var Select = new Button { WidthRequest = 60, Text = "SELECT", TextColor = Color.Blue, }; layout.Children.Add(Select); Select.Clicked += SelectClicked; /************セレクトかける*********************/ var query = UserModel008.selectUser(); foreach (var user in query) { //Userテーブルの名前列をLabelに書き出す layout.Children.Add(new Label { Text = user.Id.ToString() }); layout.Children.Add(new Label { Text = user.Name }); } Content = layout; }