C# WPF Mysql 组合框复制值
本文关键字:复制 组合 WPF Mysql | 更新日期: 2023-09-27 18:32:24
我有一个有 2 个组合框的表单。第一个组合框(cb_CharacterName)包含字符/用户名,并在表单打开时加载,这工作正常。
当在cb_CharacterName中选择一个名字时,另一个组合框(Talent_Name)会检查(cb_CharacterName)组合框中的名称并加载角色/用户拥有的才能,这也很好。
但是,当在cb_CharacterName中选择了新角色/用户时,Talent_Name组合框不会删除前一个角色的天赋,而只是向列表中添加更多天赋。同时,如果我两次选择相同的字符,我会得到重复。
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Shapes;
using MySql.Data.MySqlClient;
namespace Dark_Heresy
{
/// <summary>
/// Interaction logic for Character.xaml
/// </summary>
public partial class Character : Window
{
public Character()
{
InitializeComponent();
}
private void character_name_loader(object sender, RoutedEventArgs e)
{
string constring = "datasource= localhost; port=3306; username=root; password=MyPass;";
string Query = "SELECT Name_ FROM dark_heresy.character_";
MySqlConnection conDataBase = new MySqlConnection(constring);
MySqlCommand cmdDatabase = new MySqlCommand(Query, conDataBase);
MySqlDataReader myReader;
try
{
conDataBase.Open();
myReader = cmdDatabase.ExecuteReader();
while (myReader.Read())
{
string charactername = myReader.GetString("Name_");
cb_CharacterName.Items.Add(charactername);
}
}
catch (Exception ex)
{
MessageBox.Show("Error: 'r'n" + ex);
}
}
private void cb_CharacterName_DropDownClosed(object sender, EventArgs e)
{
string constring = "datasource = localhost; port = 3306; username = root; password = MyPass;";
string Query = "SELECT * FROM dark_heresy.character_ WHERE Name_='" + cb_CharacterName.Text + "' ;";
MySqlConnection conDataBase = new MySqlConnection(constring);
MySqlCommand cmdDataBase = new MySqlCommand(Query, conDataBase);
MySqlDataReader myReader;
try
{
conDataBase.Open();
myReader = cmdDataBase.ExecuteReader();
while (myReader.Read())
{
string career = myReader.GetString("Class");
string world = myReader.GetString("World_Type");
string strength = myReader.GetInt32("Str").ToString();
string weaponskill = myReader.GetInt32("WS").ToString();
string ballisticskill = myReader.GetInt32("BS").ToString();
string fellowship = myReader.GetInt32("Fel").ToString();
string perception = myReader.GetInt32("Per").ToString();
string intelligence = myReader.GetInt32("Int_").ToString();
string agility = myReader.GetInt32("Agi").ToString();
string willpower = myReader.GetInt32("WP").ToString();
string toughness = myReader.GetInt32("Tough").ToString();
TextCareer.Text = career;
TextWorld.Text = world;
TextStrength.Text = strength;
TextWeaponskill.Text = weaponskill;
TextBallisticskill.Text = ballisticskill;
TextFellowship.Text = fellowship;
TextPerception.Text = perception;
TextIntelligence.Text = intelligence;
TextAgility.Text = agility;
TextWillpower.Text = willpower;
TextToughness.Text = toughness;
}
}
catch (Exception ex)
{
MessageBox.Show("Error: 'r'n" + ex);
}
}
private void cb_Talent_NameDropDownOpen(object sender, EventArgs e)
{
string constring = "datasource= localhost; port=3306; username=root; password=MyPass;";
string Query = "SELECT Talent_Name FROM dark_heresy.learned_talents WHERE Character_Name='" + cb_CharacterName.Text + "' ;";
MySqlConnection conDataBase = new MySqlConnection(constring);
MySqlCommand cmdDatabase = new MySqlCommand(Query, conDataBase);
MySqlDataReader myReader;
try
{
conDataBase.Open();
myReader = cmdDatabase.ExecuteReader();
while (myReader.Read())
{
string talent_name = myReader.GetString("Talent_Name");
Talent_Name.Items.Add(talent_name);
}
}
catch (Exception ex)
{
MessageBox.Show("Error: 'r'n" + ex);
}
}
private void cb_Talent_Name_DropDownClosed(object sender, EventArgs e)
{
string constring = "datasource = localhost; port = 3306; username = root; password = MyPass;";
string Query = "SElECT learned_talents.Talent_Name , talents.Description FROM dark_heresy.learned_talents, dark_heresy.talents WHERE learned_talents.Talent_Name = talents.TalentName AND learned_talents.Character_Name = '" + cb_CharacterName.Text + "';";
MySqlConnection conDataBase = new MySqlConnection(constring);
MySqlCommand cmdDataBase = new MySqlCommand(Query, conDataBase);
MySqlDataReader myReader;
try
{
conDataBase.Open();
myReader = cmdDataBase.ExecuteReader();
while (myReader.Read())
{
string talents_description = myReader.GetString("Description");
Talents_Description.Text = talents_description;
}
}
catch (Exception ex)
{
MessageBox.Show("Error: 'r'n" + ex);
}
}
}
}
每次选择新角色/用户或 samme 以刷新旧信息并添加新信息时,如何使Talent_Name组合框? 我认为这也将消除重复问题。
另外,WPF 是否有 SelectedIndex? 现在我正在使用DropdownClosed,这不是完美的选择,因为当我使用键盘中的箭头时,字符/用户包含的值不会更新。
你想调用 Clear() 方法:
try
{
conDataBase.Open();
myReader = cmdDatabase.ExecuteReader();
// You're missing this line!
Talent_Name.Items.Clear();
while (myReader.Read())
{
string talent_name = myReader.GetString("Talent_Name");
Talent_Name.Items.Add(talent_name);
}
}
catch (Exception ex)
{
MessageBox.Show("Error: 'r'n" + ex);
}
应该有一个 SelectedItem 属性,您也可以使用来获取当前项。