private void BtnClickQue(object sender, RoutedEventArgs e) { data.Clear(); data.Add(colHead); string sqlStr = "call showSAcc;"; MySqlCommand cmd = new MySqlCommand(sqlStr, con); MySqlDataReader reader = null; try { reader = cmd.ExecuteReader(); SAccListItem item = new SAccListItem(); while (reader.Read()) { item.SAccNum = reader.GetString(0); item.BName = reader.GetString(1); item.CID = reader.GetString(2); item.LVDate = reader.GetDateTime(3).ToLongDateString(); item.balance = reader.GetString(4); item.applyDate = reader.GetDateTime(5).ToLongDateString(); item.interest = reader.GetString(6); item.currency = reader.GetString(7); data.Add(new SAccListItem(item)); } TxtAlert.Text = "Query success!"; } catch (MySqlException ex) { TxtAlert.Text = "Fail to execute sql command!\nError message: "; TxtAlert.Text += ex.Message; } finally { reader.Close(); } }
public void Init(SAccListItem item) { this.SAccNum = item.SAccNum; this.BName = item.BName; this.CID = item.CID; this.LVDate = item.LVDate; this.balance = item.balance; this.applyDate = item.applyDate; this.interest = item.interest; this.currency = item.currency; }
public SAccListItem(SAccListItem item) { Init(item); }