|
-
May 13th, 2007, 03:19 AM
#1
Thread Starter
New Member
Date format - Datagrid - SQL
Guys,
I'm newbie on .NET
Does anyone know how to fix my date format on my datagrid ?
My data source at my .MDB is already at the date format that what I need.
Here's the snippet :
<%@ Page Language="VB" MasterPageFile="~/default.master" Title="Data Grid - SQL - MDB" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<table border="0" cellpadding="0" cellspacing="0" style="width: 100%">
<tr >
<td align="center" valign="top">
<table border="0" cellpadding="0" cellspacing="0">
<tr >
<td align="center" valign="top">
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
DataSourceID="AccessDataSource1" PageSize="20" CssClass="tb01">
<FooterStyle CssClass="tb01-ft" />
<PagerStyle CssClass="tb01-ft" ForeColor="White" />
<HeaderStyle CssClass="tb01-hd" Font-Size="Small" ForeColor="White" Wrap="True" />
</asp:GridView>
</td>
<td align="center" valign="bottom">
<asp:Button ID="Button1" runat="server" Text="Close" PostBackUrl="javascript:self.close()" />
</td>
</tr>
</table>
</td>
</tr>
</table>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/general.mdb"
SelectCommand="SELECT TBL_PROJECT.NAMEPROJECT AS Name, TBL_PROJECT.STARTPROJECT AS Start, TBL_PROJECT.ENDPROJECT AS Finish, TBL_PROJECT.JOBNO AS [Job No], TBL_PROJECT.CLIENT AS Client, TBL_PROJECT.BUILDING AS Building, TBL_PROJECT.CODEPROJECT AS Code
FROM TBL_PROJECT;
">
</asp:AccessDataSource>
</asp:Content>
-----
It will return : mm/dd/yyyy hh:mm:ss pm/am.
At my .MDB data, is already dd-mm-yy. (It is easy for MsAccess to do this)
I use me master page, so it may be influenced with that file too ?
Ok folks, that's it. please help me.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|