Select date from sql specified format?
- string date = "";
- using (SqlConnection openCon = new SqlConnection(cs))
- {
- SqlDataReader reader;
- SqlCommand cmd = new SqlCommand();
- cmd.CommandText = "select datum from mp_racun_lista where id=" + id_fakture;
- cmd.Connection = openCon10;
- openCon.Open();
- reader = cmd.ExecuteReader();
-
- while (reader.Read())
- {
- date = reader[0].ToString();
- }
- openCon.Close();
- }