Exemplo n.º 1
0
        private DataTable vratiRacuneUOpsegu()
        {
            daRacun.Fill(ds.Racun);
            DateTime datumOd = dtpDatumOd.Value.Date;
            DateTime datumDo = dtpDatumDo.Value.Date;
            var      linq    = from x in ds.Racun
                               where x.datum.Date >= datumOd && x.datum.Date <= datumDo
                               select x;

            try
            {
                return(linq.CopyToDataTable());
            }
            catch (Exception ex)
            {
                return(null);
            }
        }
Exemplo n.º 2
0
        /// <summary>
        /// Cita racun zadat u datom opsegu uz pomoc DataSet i vraca DataTable namanje za rad sa DataGridView
        /// </summary>
        /// <param name="Od"></param>
        /// <param name="Do"></param>
        /// <returns></returns>
        public DataTable CitajRacun(DateTime Od, DateTime Do)
        {
            daRacun.Fill(ds.Racun);
            var linq = from x in ds.Racun
                       where x.datum.Date > Od && x.datum.Date < Do
                       select x;

            try
            {
                return(linq.CopyToDataTable());
            }
            catch (Exception e)
            {
                MessageBox.Show("Nema racuna u tom opsegu");
            }

            return(null);
        }