Friday, 27 September 2013

Using column name when using SqlDataReader.IsDBNull

Using column name when using SqlDataReader.IsDBNull

Hello I have got this code which reads data from SQL DB.
I don't know how should I edit it so I can use original column name and
not column index.
string query = "SELECT * FROM zajezd WHERE event='" +
thisrow+ "' AND year='" + klientClass.Year() + "'";
SqlCommand cmd= new SqlCommand(query, spojeni);
spojeni.Open();
SqlDataReader read= cmd.ExecuteReader();
if (read.Read())
{
maskedTextBox2.Text = read.IsDBNull(24) ? string.Empty :
read.GetDateTime(24).ToString("MM/dd/yyyy");
Thanks in advance.

No comments:

Post a Comment