CastException while reading data

[srihariacha]

using (SqlConnection con = new SqlConnection())
            {
                con.ConnectionString = "Data Source=.\\SQLEXPRESS;Initial Catalog=AdventureWorks;Integrated Security=True";

                using (SqlCommand cmd = con.CreateCommand())
                {
                    cmd.CommandType = CommandType.Text;
                    cmd.CommandText = "select FirstName,LastName,ModifiedDate from Person.Contact order by Title;select * from HumanResources.Employee";
                    con.Open();

                    using (SqlDataReader reader = cmd.ExecuteReader())
                    {
                        while (reader.Read())
                        {
//Error triggered here
                            Console.WriteLine("  {0} {1} - {2,18:D}", reader["FirstName"], reader[1], reader.GetDateTime(0));
                        }
                        Console.WriteLine(Environment.NewLine);
                        reader.NextResult();
                        Console.WriteLine("Employee Table Metadata");
                        for (int field = 0; field < reader.FieldCount; field++)
                        {
                            Console.WriteLine("Column Name : {0} Type : {1}", reader.GetName(field), reader.GetDataTypeName(field));
                        }
                    }
                }

and the error is:
InvalidCastException was unhandled
Specified cast is not valid

also I tried

Console.WriteLine("  {0} {1} - {2,18:D}", (string)reader["FirstName"].ToString(), (string)reader[1].ToString(), reader.GetDateTime(0));

it still showing me same error

Help me!

[dglienna]

The problem is this statement:

reader.GetDateTime(0)

try:

reader(0)

[srihariacha]

no the error is:

reader.GetDateTime(2)

However thanks a lot for help!

[cjard]

if youre on .net 2 you can make your life a lot easier by reading teh DW2 link in my signature