date only to be selected

[ken4ward]

sqlCommand = new SqlCommand("SELECT date FROM Transactions", sqlConnection);
                    sqlDataReader = sqlCommand.ExecuteReader();
                    while (sqlDataReader.Read())
                    {
                        comboBoxResult.Items.Add(sqlDataReader["date"].ToString());
                    }

Please kind coders, this line of code is adding both date and time to the comboBoxResult which i do not want, i only added
date to the database but when retriving it it brings both date and time. I want only the date to be added. Thanks.

[QuinnJohns]

I'd suggest trying something similar to the following:

DateTime dtFromSQL;
sqlCommand = new SqlCommand("SELECT date FROM Transactions", sqlConnection);
                    sqlDataReader = sqlCommand.ExecuteReader();
                    while (sqlDataReader.Read())
                    {
                        dtFromSQL = DateTime.Parse(sqlDataReader["date"].ToString());
                        comboBoxResult.Items.Add(dtFromSQL.ToShortDateString());
                    }

Depending on how you want to display your date, once you have it in the DateTime variable, you can format it however you want, short date being the "mm/dd/yyyy" if using the Engish (US) culture.

If this resolves your question, please mark as resolved and rate up. Thanks!
-Quinn

[DataMiser]

Wouldn't you need to use "SELECT [date] FROM Transactions" since date is a reserved word?