前台:只需要在工具箱中拖拽一个GirdView到.aspx中,你可以更具自己的喜好设置样式。
示例:<asp:GridView ID="GridView" runat="server" CellPadding="4" GridLines="Horizontal" Height="23px" Width="100%" ForeColor="Black" BackColor="White"
BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" AllowPaging="True" PageSize="4" PagerSettings-Mode="Numeric" OnPageIndexChanging="GridView1_PageIndexChanging">
<PagerTemplate >
<asp:Button ID="Button2" runat="server" CommandArgument="prev" CommandName="page" Text="上一页" />
<asp:Button ID="Button3" runat="server" CommandArgument="next" CommandName="page" Text="下一页"/>
<%-- <asp:Button ID="BtnLast" runat="server" Text="上一页" />--%>
</PagerTemplate>
<RowStyle HorizontalAlign="Center" />
<FooterStyle BackColor="#CCCC99" ForeColor="Black" />
<HeaderStyle BackColor="#3a9cff" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="White" ForeColor="Black" HorizontalAlign="Right" />
<RowStyle BackColor="White" ForeColor="#333333" />
<SelectedRowStyle BackColor="#CC3333" Font-Bold="True" ForeColor="White" />
</asp:GridView>
后台:第一步:获取你要现实的列名从数据库表中。
public List<string> GetColumnField(string connection)
{
List<string> Columnlist = new List<string>();
SqlConnection objConnetion = new SqlConnection(connection);
try
{
if (objConnetion.State == ConnectionState.Closed)
{
objConnetion.Open();
}
SqlCommand cmd = new SqlCommand("select * from SysColumns where id=Object_Id('参赛队员表')", objConnetion);
SqlDataReader objReader = cmd.ExecuteReader();
while (objReader.Read())
{
Columnlist.Add(objReader[0].ToString());
}
}
catch
{
}
objConnetion.Close();
return Columnlist;
}
第二步:获取数据从数据库中。
public DataTable getDataSource()
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = connstring;
conn.Open();
string sql = "select 队员ID,身份,综合体能总秒数,单兵破拆用时秒数,单兵破拆成绩是否可改,带压快速堵漏是否检录 from 参赛队员表";
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
da.Fill(ds, "table");
DataTable dt = ds.Tables["table"];
conn.Close();
return dt;
}
第三步:给GirdView绑定数据源
BoundField bc = new BoundField();
bc.DataField = dt[i].ToString();
bc.HeaderText = dt[i].ToString();
//GridView.Columns.Add(bc);
//this.GridView.DataKeyNames = new string[] { "队员ID" };
GridView.DataSource = dt1;
GridView.DataBind();