01.using (SqlConnection conn = new SqlConnection(strConn))
02. {
03. conn.Open();
04. using (SqlCommand cmd = new SqlCommand("select convert(varchar(10),getdate(),103) as strDate ", conn))
05. {
06. string result =(string)cmd.ExecuteScalar();
07. this.TextBox1.Text = result;
08. }
09. }
