protected override void OnCreate(Bundle savedInstanceState) { base.OnCreate(savedInstanceState); // Create your application here SetContentView(Resource.Layout.EditDatabase); SqlConnection mySqlConnectionClass = new SqlConnection(); // Sql Connection myList = mySqlConnectionClass.ViewAll(); btnEditDbBackToMainMenu = FindViewById <Button>(Resource.Id.btnEditDbBackToMainMenu); // 1.button back to main menu btnEditDbBackToMainMenu.Click += btnEditDbBackToMainMenu_Click; btnDeleteEntry = FindViewById <Button>(Resource.Id.btnDeleteEntry); // 2. Button Delete btnDeleteEntry.Click += btnDeleteEntry_Click; btnDeleteEntry.Enabled = false; spinnerEditDB = FindViewById <Spinner>(Resource.Id.spinnereditDB); Resources.DataAdapterFile dtadptr = new Resources.DataAdapterFile(this, myList); // 3. Spinner dropdown spinnerEditDB.Adapter = dtadptr; spinnerEditDB.ItemSelected += new EventHandler <AdapterView.ItemSelectedEventArgs>(spinnerEditDB_ItemSelected); }
protected override void OnCreate(Bundle savedInstanceState) { base.OnCreate(savedInstanceState); // Create your application here SetContentView(Resource.Layout.AddPlayerProfile); SqlConnection mySqlConnectionClass = new SqlConnection(); myList = mySqlConnectionClass.ViewAll(); SelectPlayerSpinner = FindViewById <Spinner>(Resource.Id.selectPlayerSpinner); //Palyer dropdown DataAdapterFile dtadptr = new Resources.DataAdapterFile(this, myList); SelectPlayerSpinner.Adapter = dtadptr; SelectPlayerSpinner.ItemSelected += new EventHandler <AdapterView.ItemSelectedEventArgs>(SpinnerDropdown_ItemSelected); txtEnterPlayerName = FindViewById <TextView>(Resource.Id.txtEnterName); //Enter Player name textview Button btnAddPlayer = FindViewById <Button>(Resource.Id.btnAddProfile); //button Add Player Profile btnAddPlayer.Click += btnAddPlayer_Click; Button btnGobackToMainMenu = FindViewById <Button>(Resource.Id.btnGobackToMainMenu); Button btnStartGame = FindViewById <Button>(Resource.Id.btnStartGame); //button Start Game btnStartGame.Click += btnStartGame_Click; btnGobackToMainMenu.Click += btnGobackToMainMenu_Click; //button back to Main Menu }
private void btnDeleteEntry_Click(object sender, EventArgs e) { var sqlConn = new SqlConnection(); sqlConn.DeletePlayer(HangmanGameActivity.Id); myList = sqlConn.ViewAll(); var dtadptr = new Resources.DataAdapterFile(this, myList); spinnerEditDB.Adapter = dtadptr; }
private void btnAddPlayer_Click(object sender, EventArgs e) //Button_click Add Player { if (txtEnterPlayerName.Text.Length > 0) // If word length is > 0 do this else display msg { HangmanGameActivity.PlayerName = txtEnterPlayerName.Text.ToString(); HangmanGameActivity.score = 0; // Start score @ 0. var sqlConn = new SqlConnection(); sqlConn.InsertNewPlayer(HangmanGameActivity.PlayerName, HangmanGameActivity.score); // Inserts the Players name and score myList = sqlConn.ViewAll(); // update the list var dtadptr = new Resources.DataAdapterFile(this, myList); //DataAdapterFile.cs SelectPlayerSpinner.Adapter = dtadptr; //displays the updated list on the spinner Toast.MakeText(this, "Add Sucessful!", ToastLength.Short).Show(); } else { Toast.MakeText(this, "Please Enter A Valid Name!", ToastLength.Short).Show(); // Toast(view) ie: displays message } }