SqlCommand read one value
Solution 1
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.
Solution 2
ExecuteReader
works but more objects and more code are required - (An SqlDataReader
, call to Read and Extract value). Instead you could simply use the ExecuteScalar
method of the SqlCommand
object (It returns just the first column of the first row of the resultset)
string sqlSelect = "Select TOP 1 Quotation.SentToSupp as SentToSupp FROM ....";
SqlCommand Comm = new SqlCommand(sqlSelect, this.Connection);
object result = Comm.ExecuteScalar();
if(result != null)
DateTime dtResult = Convert.ToDateTime(result);
Just pay attention to the fact that ExecuteScalar
could return a null
value if, for some reason, there is no record in the result returned
userS
Updated on June 22, 2022Comments
-
userS almost 2 years
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 firstDateTime
value. When I call toSqlCommand
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 likeExecuteReader
?Thank you in advance!!
-
Alex K. about 11 yearsTake a look @
ExecuteScalar
; msdn.microsoft.com/en-us/library/…
-