private void button4_Click(object sender, EventArgs e) { listView1.Columns.Clear(); listView1.Items.Clear(); listView1.View = View.Details; listView1.FullRowSelect = true; listView1.MultiSelect = true; foreach (string s in qsofields) { if (s.Length > 0) { listView1.Columns.Add(s); } } HRDInterface.callsign = textBox2.Text; HRDInterface.u = textBox3.Text; HRDInterface.p = textBox4.Text; HRDInterface.s = textBox5.Text; System.Collections.ArrayList q = HRDInterface.test(); for (int x = 0; x < q.Count; x++) { try { QSOData d = (QSOData)q[x]; ListViewItem li = new ListViewItem(); li.Text = d.callsign; li.SubItems.Add(d.name); li.SubItems.Add(d.date); li.SubItems.Add(d.date); li.SubItems.Add(d.sent); li.SubItems.Add(d.rcvd); li.SubItems.Add(d.mode); li.SubItems.Add(d.qth); li.SubItems.Add(d.band); li.SubItems.Add(d.freq); li.SubItems.Add(""); //skcc li.SubItems.Add(""); //TXPWR li.SubItems.Add(d.comment); //TXPWR if (d.QSL_SENT.Equals("Y")) { li.BackColor = Color.OrangeRed; } listView1.Items.Add(li); } catch (Exception ex) { System.Console.WriteLine(ex.Message); } } }
public static System.Collections.ArrayList test() { System.Collections.ArrayList qsos = new System.Collections.ArrayList(); try { connstring = connstring.Replace("%U%", u); connstring = connstring.Replace("%P%", p); connstring = connstring.Replace("%S%", s); conn = new MySqlConnection(connstring); //conn.ConnectionTimeout = 360; conn.Open(); string query = sql_getbycall; if (callsign.Trim().Length > 0) { query = query + " where COL_CALL = '" + callsign + "'"; } else { //query = query + " LIMIT 5000"; } MySqlDataAdapter da = new MySqlDataAdapter(query, conn); DataSet ds = new DataSet(); da.Fill(ds, "HRD"); DataTable dt = ds.Tables["HRD"]; foreach (DataRow row in dt.Rows) { QSOData q = new QSOData(); q.callsign = row["COL_CALL"].ToString(); q.freq = row["COL_FREQ"].ToString(); q.mode = row["COL_MODE"].ToString(); q.rcvd = row["COL_RST_RCVD"].ToString(); q.sent = row["COL_RST_SENT"].ToString(); q.comment = row["COL_COMMENT"].ToString(); q.date = row["COL_TIME_ON"].ToString(); q.QSL_SENT = row["COL_QSL_SENT"].ToString(); q.name = row["COL_NAME"].ToString(); q.qth = row["COL_QTH"].ToString(); q.power = row["COL_TX_PWR"].ToString(); q.band = row["COL_BAND"].ToString(); //foreach (DataColumn col in dt.Columns) //{ // Console.Write(row[col] + "\t"); //} qsos.Add(q); //Console.Write("\n"); } } catch (Exception e) { Console.WriteLine("Error: {0}", e.ToString()); } finally { if (conn != null) { conn.Close(); } } return(qsos); }