很简单:
给你个例子:<ASP:DATAGRID id="Output" runat="server" HorizontalAlign="Center" AutoGenerateColumns="false" BackColor="#CFE1FF" ForeColor="Black" CellPadding="4" CellSpacing="1" PagerStyle-HorizontalAlign="Right" PagerStyle-Mode="NumericPages" PageSize="10" AllowPaging="True" Width="100%">
<SelectedItemStyle BackColor="#8DB3EE"></SelectedItemStyle>
<ItemStyle HorizontalAlign="Center" BackColor="#CFE1FF"></ItemStyle>
<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" BackColor="#8DB3EE"></HeaderStyle>
<FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" BackColor="#8DB3EE"></FooterStyle>
<Columns>
<asp:BoundColumn DataField="ExportDate" DataFormatString="{0:yyyy-MM-dd}" HeaderText="出库日期"></asp:BoundColumn>
<asp:BoundColumn DataField="LocationID" HeaderText="库位编号"></asp:BoundColumn>
<asp:BoundColumn DataField="EquipID" HeaderText="电脑编号"></asp:BoundColumn>
<asp:BoundColumn DataField="ExportCount" HeaderText="出库数量"></asp:BoundColumn>
<asp:BoundColumn DataField="ExportBillID" HeaderText="出库单编号"></asp:BoundColumn>
</Columns>
</ASP:DATAGRID>
给你个例子:<ASP:DATAGRID id="Output" runat="server" HorizontalAlign="Center" AutoGenerateColumns="false" BackColor="#CFE1FF" ForeColor="Black" CellPadding="4" CellSpacing="1" PagerStyle-HorizontalAlign="Right" PagerStyle-Mode="NumericPages" PageSize="10" AllowPaging="True" Width="100%">
<SelectedItemStyle BackColor="#8DB3EE"></SelectedItemStyle>
<ItemStyle HorizontalAlign="Center" BackColor="#CFE1FF"></ItemStyle>
<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" BackColor="#8DB3EE"></HeaderStyle>
<FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" BackColor="#8DB3EE"></FooterStyle>
<Columns>
<asp:BoundColumn DataField="ExportDate" DataFormatString="{0:yyyy-MM-dd}" HeaderText="出库日期"></asp:BoundColumn>
<asp:BoundColumn DataField="LocationID" HeaderText="库位编号"></asp:BoundColumn>
<asp:BoundColumn DataField="EquipID" HeaderText="电脑编号"></asp:BoundColumn>
<asp:BoundColumn DataField="ExportCount" HeaderText="出库数量"></asp:BoundColumn>
<asp:BoundColumn DataField="ExportBillID" HeaderText="出库单编号"></asp:BoundColumn>
</Columns>
</ASP:DATAGRID>
1,SELECT语句这样写,不要用*或全部,将顺序现在就定好,SELECT ID,Name,Age.....FROM TABLE WHERE .....
2,SELECT语句用别名,改变系统使用字段名作为列标题名。SELECT ID AS 编号,Name AS 姓名,Age AS 年龄,.....FROM TABLE WHERE .....
在table style点添加,这样就会添加一个dataGridTableStyle1 然后在MappingName里面选定你的表, 然后点上面的gridColumnStyles 。之后一个一个添加 MappingName里面选择你要用的字段,headtext里面写这个字段的中文名字,字段排列的顺序就是你添加的顺序。
另外
sdfdslfdjslfsd