private void btn_pick_to_table_Click(object sender, EventArgs e) { TreeTableAndList result = new TreeTableAndList(); if (cb_local.Checked) { result = AutoPickHelper.get_tree_table_from_local(this.txt_local.Text); } else { result = AutoPickHelper.get_tree_table_from_url(this.txt_url.Text); } this.dgv_tree.DataSource = result.table; StringBuilder sb = new StringBuilder(); for (int i = 0; i < result.list.Count; i++) { sb.Append(i.ToString() + "[" + ((ArrayList)result.list[i]).Count + "]: "); foreach (int item in (ArrayList)result.list[i]) { sb.Append(item.ToString() + " "); } sb.Append(Environment.NewLine); } this.txt_result.Text = sb.ToString(); DataTable dt_filter = new DataTable(); for (int i = 0; i < 500; i++) { dt_filter.Columns.Add("C" + i.ToString()); } StringBuilder filter_sb = new StringBuilder(); DataTable dt_table = result.table; for (int i = 0; i < dt_table.Rows.Count; i++) { for (int j = 0; j < dt_table.Columns.Count; j++) { string value = dt_table.Rows[i][j].ToString(); if (value.Length > 4 && value.Substring(0, 4) == "$$$$") { if (!value.Contains("<!--") && !value.Contains("{") && !value.Contains("|")) { DataRow row_new = dt_filter.NewRow(); row_new[j] = dt_table.Rows[i][j].ToString().Replace("$$$$", ""); filter_sb.Append(dt_table.Rows[i][j].ToString().Replace("$$$$", "") + Environment.NewLine); dt_filter.Rows.Add(row_new); } } } } this.dgv_filter.DataSource = dt_filter; this.txt_filter.Text = filter_sb.ToString(); }
private void btn_pick_Click(object sender, EventArgs e) { if (cb_local.Checked) { this.txt_result.Text = AutoPickHelper.select_data_from_local(this.txt_local.Text); } else { this.txt_result.Text = AutoPickHelper.select_data_from_url(this.txt_url.Text); } }
private void btn_pick_to_tree_Click(object sender, EventArgs e) { this.tree_result.Nodes.Clear(); if (cb_local.Checked) { AutoPickHelper.show_tree_from_local(this.txt_local.Text, ref this.tree_result); } else { AutoPickHelper.show_tree_from_url(this.txt_url.Text, ref this.tree_result); } this.tree_result.ExpandAll(); }