SqlCommand read one value
c#, sql, sql-server, sqlcommand
Solution
Use SqlCommand.ExecuteScalar method - Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.
Problem
I have a problem with the value returned from `SqlCommand`, I have this code: ``` string sqlSelect = "Select TOP 1 Quotation.SentToSupp as SentToSupp FROM Quotation JOIN Notifications ON Quotation.QuotationId = QuotationID "; SqlCommand Comm = new SqlCommand(sqlSelect, this.Connection); ``` `sqlSelect` query selects the first `DateTime` value. When I call to `SqlCommand` I want to get this value (just one value). I add the query and my connection fine. But I don't know how to get my `DateTime` value... Must to use something like `ExecuteReader`? Thank you in advance!!