sql 2008 DATE type showes me DATE & TIME in visual studio

See more:

C#

ASP.NET

SQL-Server

, +

I'm using SQLserver 2008 and my fields have DATE type but in visual studio in my program when I read may data it shows me DATE & TIME what should I do? I try to cast my fields in SELECT query of my program but it qives me some error,how can I solve this problem?

this is my behind code:

<pre>  protected void Page_Load(object sender, EventArgs e)
    {
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = new SqlConnection(Class1.CnnStr);
            SqlDataReader reader;
    
    
            cmd.CommandText = "select ContractStartDate,MandateValidDate from table where BrokerName=@BrokerName";
            cmd.Connection.Open();
            cmd.Parameters.AddWithValue("@BrokerName", BrokerName_txt.Text);
            reader = cmd.ExecuteReader();
    
            if (reader.Read())
            {
               
               
                ContractStartDate_txt.Text = reader["ContractStartDate"].ToString();
                MandateValidDate_txt.Text = reader["MandateValidDate"].ToString();
                reader.Close();
            }
            cmd.Connection.Close();
    
        }

and because I want to save data after read them it gives me error:

Conversion failed when converting date and/or time from character string.