How to convert data in command object to DateTime?

Question

DateTime DT1;

SqlCommand cmd = new SqlCommand("Select DateReceivedProviderInvoice from ProviderInvoices");

now how to assing the result of the query to DateTime variable DT1?!!!!

Selman Genç · Accepted Answer · 2014-07-17 09:48:55Z

2

You can use SqlCommand.ExecuteScalar Method if you want to get a single value from a column.

SqlCommand.ExecuteScalar: 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.

DT1 = Convert.ToDateTime(cmd.ExecuteScalar());

answered Jul 17, 2014 at 9:48

Selman Genç

102k15 gold badges126 silver badges193 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to convert data in command object to DateTime?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related