To retrieve data as DD/MM/YYYY format from sql server Database

String b = string.Format("{0:dd/MM/yyyy}", DateTime.Parse(dr["Period_To"].ToString()));

lbl_Periodto.Text = b;