From: johansson.andersson@telia.com   
      
   Solved I used this   
   DataFormatString="{0:yyyy-MM-dd}"   
      
   //Tony   
   "Tony Johansson"  skrev i meddelandet   
   news:lg1l34$knv$1@dont-email.me...   
   > In this method GetBokningar I fetch all rows and return a DataSet but I   
   > hope I can remove the time part in some way.   
   > Now I get for example format 2013-03-12 00:00:00 for columns   
   > BokningFromDate and BokningToDate because these are DateTime column in the   
   > database.   
   > I could use  a DataReader and convert to string but I hope I can fix it   
   > within sql in some way.   
   >   
   > public DataSet GetBokningar()   
   >  {   
   >   Command.Parameters.Clear();   
   >   Connection.Open();   
   >   
   >   Command.CommandText = "SELECT BokningFromDate, BokningToDate, Name,   
   > Address, Phone, ProductID, EnhetsPris " +   
   >          "FROM Bokningar " +   
   >          "INNER JOIN Customers " +   
   >          "ON Bokningar.CustomerID = Customers.CustomerID " +   
   >          "INNER JOIN BokningDetails " +   
   >          "ON Bokningar.BokningarID = BokningDetails.BokningarID " +   
   >          "ORDER BY Name asc";   
   >   
   >   dataAdapter = new SqlDataAdapter(Command);   
   >   DataSet ds = new DataSet();   
   >   dataAdapter.Fill(ds, "Products");   
   >   return ds;   
   >  }   
   >   
   > //Tony   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)