コード例 #1
0
ファイル: Form1.cs プロジェクト: iamlos/Excel-Manipulator
        private void Search(object sender, EventArgs e)
        {
            SearchInUse searchInUse = new SearchInUse();

            dtCantMatch = new DataTable();
            dtCantMatch.Columns.Add("keys");
            dtCantMatch.Columns.Add("value");
            dtCantMatch.Columns.Add("InUse");

            foreach (DataRow row in dtMine.Rows)
            {
                row["InUse"] = searchInUse.SearchSingleWordInDatas(row["keys"].ToString(),
                                                                   sourceFolder: @"D:\Project\DEV\Mobile\src\AgileBet.Cash.Mobile.Website\");

                string    key       = "'" + row["Keys"] + "'"; //規定要加''
                DataRow[] matchRows = dtTheir.Select("Keys=" + key);
                if (matchRows.Length != 0)
                {
                    row["value"] = matchRows[0]["value"];
                }
                else
                {
                    dtCantMatch.ImportRow(row);
                }
                dataGridView1.DataSource = dtMine;
                dataGridView3.DataSource = dtCantMatch;
            }
        }
コード例 #2
0
ファイル: Form1.cs プロジェクト: iamlos/Excel-Manipulator
        private void Search(object sender, EventArgs e)
        {
            SearchInUse searchInUse = new SearchInUse();
            dtCantMatch = new DataTable();
            dtCantMatch.Columns.Add("keys");
            dtCantMatch.Columns.Add("value");
            dtCantMatch.Columns.Add("InUse");

            foreach (DataRow row in dtMine.Rows)
            {
                row["InUse"] = searchInUse.SearchSingleWordInDatas(row["keys"].ToString(),
                    sourceFolder: @"D:\Project\DEV\Mobile\src\AgileBet.Cash.Mobile.Website\");

                string key = "'" + row["Keys"] + "'"; //規定要加''
                DataRow[] matchRows = dtTheir.Select("Keys=" + key);
                if (matchRows.Length != 0)
                {
                    row["value"] = matchRows[0]["value"];
                }
                else
                {
                    dtCantMatch.ImportRow(row);
                }
                dataGridView1.DataSource = dtMine;
                dataGridView3.DataSource = dtCantMatch;

            }
        }