à propos du champs date

Question

salut tt le monde ,mon problème dans ce code si dessous est le comportement de l'affichage de date
je veux l'afficher comme suis : 2009/mars/11

avec mars= ????
de droit à gauche sachant que le mois est ecrit de droit à gauche

bon le code existant me donne 2009/11/????

try
            {

                connexion.Open();
                SqlCommand command = new SqlCommand("SELECT * FROM bureau", connexion);
                SqlDataReader reader1 = command.ExecuteReader();
                reader1.Read();
                string carac="" + reader1.GetDateTime(6);
                string var = carac.Substring(3, 2);

                switch (var)
                {
                    case "01":
                        var = "?????";
                        break;
                    case "02":
                        var = "?????";
                        break;
                    case "03":
                        var = "????";
                        break;
                    case "04":
                        var = "?????";
                        break;
                    case "05":
                        var = "???";
                        break;

                    case "06":
                        var = "????";
                        break;
                    case "07":
                        var = "??????";
                        break;
                    case "08":
                        var = "???";
                        break;
                    case "09":
                        var = "??????";
                        break;
                    case "10":
                        var = "??????";
                        break;
                    case "11":
                        var = "??????";
                        break;
                    case "12":
                        var = "??????";
                        break;
                }

                textBox7.Text = carac.Substring(6,4)+"/"+carac.Substring(0,2)+"/"+var;
                textBox1.Text = reader1.GetString(0).Trim();
                textBox2.Text = reader1.GetString(1).Trim();
                textBox3.Text = reader1.GetString(2).Trim();
                
                textBox4.Text = ""+reader1.GetInt32(3);
                textBox5.Text = ""+reader1.GetInt32(4);
                textBox6.Text = reader1.GetString(5);
                
                reader1.Close();
}

WishhhMaster · Answer

Salut,
Essaie à la place
string date = reader1.GetDateTime(6).ToString("yyyy/MM/dd");

à propos du champs date

1 réponse

Votre réponse

Discussions similaires