Data Presentation Controlshttp://forums.asp.net/24.aspxASP.NET data-bound controls such as the DataGrid, DataList, GridView, FormView, DetailsView, and Repeater Controls. <a href="http://aspadvice.com/SignUp/list.aspx?l=23&c=17" target="_blank">Email List</a>enCommunityServer 2007 SP1 (Build: 20510.895)Re: Gridviewhttp://forums.asp.net/thread/2150502.aspxSun, 03 Feb 2008 17:11:04 GMT4c671506-2930-414c-a40b-8bf57ded5924:2150502johandanielsson0http://forums.asp.net/thread/2150502.aspxhttp://forums.asp.net/commentrss.aspx?SectionID=24&PostID=2150502<p>It worked without problem. Thanks</p>Re: Gridviewhttp://forums.asp.net/thread/2150461.aspxSun, 03 Feb 2008 16:12:11 GMT4c671506-2930-414c-a40b-8bf57ded5924:2150461XGmarX0http://forums.asp.net/thread/2150461.aspxhttp://forums.asp.net/commentrss.aspx?SectionID=24&PostID=2150461<p>&nbsp;</p> <p>Hello,&nbsp;&nbsp;<br />You can use one of&nbsp;these ... &nbsp;</p> <p><strong><u>in your statement write the date like the following:</u></strong></p> <p>select to_char(HIRE_DATE, &#39;dy/mon/rrrr&#39;)<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;from employees<br /></p> <p><strong><u>or just like mbanavige said: </u></strong></p> <div style="FONT-SIZE:10pt;BACKGROUND:white;COLOR:black;FONT-FAMILY:Courier New;"> <p style="MARGIN:0px;"><span style="COLOR:blue;">&lt;</span><span style="COLOR:#a31515;">asp</span><span style="COLOR:blue;">:</span><span style="COLOR:#a31515;">GridView</span> <span style="COLOR:red;">ID</span><span style="COLOR:blue;">=&quot;GridView1&quot;</span> <span style="COLOR:red;">runat</span><span style="COLOR:blue;">=&quot;server&quot;&gt;</span></p> <p style="MARGIN:0px;">&nbsp;&nbsp;&nbsp; <span style="COLOR:blue;">&lt;</span><span style="COLOR:#a31515;">Columns</span><span style="COLOR:blue;">&gt;</span></p> <p style="MARGIN:0px;">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; <span style="COLOR:blue;">&lt;</span><span style="COLOR:#a31515;">asp</span><span style="COLOR:blue;">:</span><span style="COLOR:#a31515;">BoundField</span> <span style="COLOR:red;">DataField</span><span style="COLOR:blue;">=&quot;yourDateField&quot;</span> <span style="COLOR:red;">DataFormatString</span><span style="COLOR:blue;">=&quot;{0:d}&quot;</span> <span style="COLOR:red;">HtmlEncode</span><span style="COLOR:blue;">=&quot;False&quot;</span> <span style="COLOR:blue;">/&gt;</span></p> <p style="MARGIN:0px;">&nbsp;&nbsp;&nbsp; <span style="COLOR:blue;">&lt;/</span><span style="COLOR:#a31515;">Columns</span><span style="COLOR:blue;">&gt;</span></p> <p style="MARGIN:0px;"><span style="COLOR:blue;">&lt;/</span><span style="COLOR:#a31515;">asp</span><span style="COLOR:blue;">:</span><span style="COLOR:#a31515;">GridView</span><span style="COLOR:blue;">&gt;</span></p> <p style="MARGIN:0px;"><span style="COLOR:blue;"></span>&nbsp;</p> <p style="MARGIN:0px;"><span style="COLOR:blue;"></span>&nbsp;</p> <p style="MARGIN:0px;"><span style="COLOR:blue;"><font color="#000000">Please, let me know if that helped ... </font></span></p></div>Re: Gridviewhttp://forums.asp.net/thread/2150451.aspxSun, 03 Feb 2008 15:58:32 GMT4c671506-2930-414c-a40b-8bf57ded5924:2150451mbanavige0http://forums.asp.net/thread/2150451.aspxhttp://forums.asp.net/commentrss.aspx?SectionID=24&PostID=2150451<p>like this:</p> <div style="FONT-SIZE:10pt;BACKGROUND:white;COLOR:black;FONT-FAMILY:Courier New;"> <p style="MARGIN:0px;"><span style="COLOR:blue;">&lt;</span><span style="COLOR:#a31515;">asp</span><span style="COLOR:blue;">:</span><span style="COLOR:#a31515;">GridView</span> <span style="COLOR:red;">ID</span><span style="COLOR:blue;">=&quot;GridView1&quot;</span> <span style="COLOR:red;">runat</span><span style="COLOR:blue;">=&quot;server&quot;&gt;</span></p> <p style="MARGIN:0px;">&nbsp;&nbsp;&nbsp; <span style="COLOR:blue;">&lt;</span><span style="COLOR:#a31515;">Columns</span><span style="COLOR:blue;">&gt;</span></p> <p style="MARGIN:0px;">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; <span style="COLOR:blue;">&lt;</span><span style="COLOR:#a31515;">asp</span><span style="COLOR:blue;">:</span><span style="COLOR:#a31515;">BoundField</span> <span style="COLOR:red;">DataField</span><span style="COLOR:blue;">=&quot;yourDateField&quot;</span> <span style="COLOR:red;">DataFormatString</span><span style="COLOR:blue;">=&quot;{0:d}&quot;</span> <span style="COLOR:red;">HtmlEncode</span><span style="COLOR:blue;">=&quot;False&quot;</span> <span style="COLOR:blue;">/&gt;</span></p> <p style="MARGIN:0px;">&nbsp;&nbsp;&nbsp; <span style="COLOR:blue;">&lt;/</span><span style="COLOR:#a31515;">Columns</span><span style="COLOR:blue;">&gt;</span></p> <p style="MARGIN:0px;"><span style="COLOR:blue;">&lt;/</span><span style="COLOR:#a31515;">asp</span><span style="COLOR:blue;">:</span><span style="COLOR:#a31515;">GridView</span><span style="COLOR:blue;">&gt;</span></p></div>Gridviewhttp://forums.asp.net/thread/2150444.aspxSun, 03 Feb 2008 15:47:49 GMT4c671506-2930-414c-a40b-8bf57ded5924:2150444johandanielsson0http://forums.asp.net/thread/2150444.aspxhttp://forums.asp.net/commentrss.aspx?SectionID=24&PostID=2150444<p>How to make a datetime coloum in a gridview only show the date not the time? The database is made in access.</p>