C# Tables.Select() 使用注意事項記錄

C# Tables.Select() 使用注意事項記錄


DataRow[] row = ds.Tables["dtlfa10"].Select("序號 =" + "'" + dr["序號"].ToString() + "'" + "");

   dr["日期"] = row[0][11] .ToString().Trim();

   dr["結束日"] = row[0][12].ToString().Trim();

因為row是 [] , 所以要row[0][11] .ToString().Trim();才抓的到值


        private void checkdouble()
        {
            foreach (DataRow dr in dto.Rows)
            {
                dr["ID"].ToString();
                DataRow[] row = ds.Tables["ordfa10"].Select("ID =" + "'" + dr["ID"].ToString() + "'" + " and 代碼 =" + "'" + dr["代碼"].ToString() + "'" + "");
                if (row.Length > 1)
                {
                    MessageBox.Show("double");
                }
            }
        }