Member Avatar for Mitja Bonca

I get into DataSet CostumerNames and Hours (type DateTime) of their registrations.
I would like to sort customers my time of registration (time of a day).

I show both in listView.
This is my code:

string DanesRezervacije = "SELECT Stranka.ImePriimek, Naročilo.RegisterTime FROM Stranka, Naročilo " +
                                    " WHERE Stranka.IDStranke = Naročilo.IDStrankeFK AND Naročilo.DatumRezervacije = @danes";
            // THIS IS NOT WORKING:  " + "ORDER BY Naročilo.DatumRezervacije ASC";
            da = new SqlDataAdapter(DanesRezervacije, povezava);
            da.SelectCommand.Parameters.Add("@danes", SqlDbType.DateTime).Value = DateTime.Today.Date;
            DataSet ds = new DataSet();
            da.Fill(ds, "DanašnjeRezervacije");
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                ListViewItem lvi = new ListViewItem(dr["ImePriimek"].ToString());
                lvi.SubItems.Add(Convert.ToDateTime(dr["RegisterTime"]).ToShortTimeString());
                listViewLista.Items.Add(lvi);
            }

                }
Edited by Mitja Bonca because: n/a
  • 1 Contributor
  • 1 Reply
  • 117 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Mitja Bonca
Member Avatar for Mitja Bonca

Works:)

string DanesRezervacije = "SELECT Stranka.ImePriimek, Naročilo.ČasRezervacije FROM Stranka, Naročilo " +
                                      " WHERE Stranka.IDStranke = Naročilo.IDStrankeFK AND Naročilo.DatumRezervacije = @danes " +
                                      "ORDER BY Naročilo.ČasRezervacije ASC";
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.