这个是现在的效果
代码是这样的: <div>
<asp:GridView ID="GridView1" runat="server" AllowPaging="true" PageSize="5" AllowSorting="true" Width="160px"
BorderColor="Blue" BorderWidth="1" AutoGenerateColumns="true" HorizontalAlign="Justify"
AlternatingRowStyle-BackColor="BlanchedAlmond" OnPageIndexChanging="GridView1_PageIndexChanging">
<PagerSettings NextPageText="后一页" PreviousPageText="前一页" />
<PagerStyle HorizontalAlign="Right" />
</asp:GridView>
</div>
<div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:laborageConnectionString %>"
SelectCommand="SELECT EMPCODE as 员工编号,ATTEVENT as 事件,ATTDATE as 时间 FROM [ATTENDENCE]"></asp:SqlDataSource>
</div>明明有规定它的宽度啊……而且数据库里那个时间存的是DATE类型,为什么会多显示了时间呢?事件那一列为什么会占了两行?要怎么做才能正常点?
http://wenwen.soso.com/z/q241541711.htm
谢谢各位了
Width="160px"
改为: <asp:GridView ID="GridView1" runat="server" AllowPaging="true" PageSize="5" AllowSorting="true" Width="160px"
BorderColor="Blue" BorderWidth="1" AutoGenerateColumns="false" HorizontalAlign="Justify"
AlternatingRowStyle-BackColor="BlanchedAlmond" OnPageIndexChanging="GridView1_PageIndexChanging">
<Columns>
<asp:BoundField DataField="员工编号" HeaderText="员工编号" />
<asp:BoundField DataField="事件" HeaderText="事件" />
<asp:BoundField DataField="时间" HeaderText="时间" DataFormatString="{0:yyyy-MM-dd}"/>
</Columns>
<PagerSettings NextPageText="后一页" PreviousPageText="前一页" />
<PagerStyle HorizontalAlign="Right" />
</asp:GridView>
SELECT EMPCODE as 员工编号,ATTEVENT as 事件,ATTDATE as 时间 FROM [ATTENDENCE]
=========
SELECT EMPCODE as 员工编号,ATTEVENT as 事件,CONVERT(varchar(100), ATTDATE, 23)as 时间 FROM [ATTENDENCE]
http://51xingfu.blog.51cto.com/219185/58722
指的是GridView表格的宽度,行的宽度属性是 RowStyle-Width="160px"
BorderColor="Blue" BorderWidth="1" AutoGenerateColumns="true" HorizontalAlign="Justify"
AlternatingRowStyle-BackColor="BlanchedAlmond" OnPageIndexChanging="GridView1_PageIndexChanging">
<PagerSettings NextPageText="后一页" PreviousPageText="前一页" />
<PagerStyle HorizontalAlign="Right" />
<Columns>
//设置列
</Columns>
</asp:GridView>
使用模板列<%# DateTime.Parse(Eval("")).ToString("yyy-MM-dd")%>