using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("select convert(varchar(10),getdate(),103) as strDate ", conn))
{
string result =(string)cmd.ExecuteScalar();
this.TextBox1.Text = result;
}
}