How to read output of Sqlcommand in C#

Question

I'm fetching date from the database and following is my command for it:

SqlCommand cmd = new SqlCommand("select dob from sample Where cardnum = '" + TextBox1.Text + "'");

How do i save the output of this command into datetime?

You go and read a tutorial. http://www.codeproject.com/Articles/361579/A-Beginners-Tutorial-for-Understanding-ADO-NET — Karl-Johan Sjögren, Jan 11 '14 at 19:03
SqlDataReader is what you want, probably. But First use a parameterised query. SQL Injection attack and passing dates as strings in out of sql server is simply a really bad idea. — Tony Hopkinson, Jan 11 '14 at 19:05

score 0 · Answer 1 · answered Jan 11 '14 at 19:11

At the simplest:

var when = (DateTime)cmd.ExecuteScalar();

However, in the more general case you woulnd need to know about readers and parameters. Or: use a tool like dapper:

var when = conn.Query<DateTime>(
    "select dob from sample Where cardnum = @num",
    new { num = TextBox1.Text } // parameters, done right
).Single();

But dapper will read entire objects too (mapping properties to columns), not just single values.

How to read output of Sqlcommand in C#

1 Answers1