20分求：如何将datatable中检索出来的数据库数据显示到datagrid中？最好有代码实例？

nmd06 2004-10-19 07:58:38

谢谢各位哥哥们

...全文

114 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

qixiao 2004-10-19

打赏
举报

sub page_load()
if not ispostback then
datagrid.datasource=datatable
datagrid.databind
end if
end sub

berlin8600 2004-10-19

打赏
举报

同意思楼上。贴个程序，可以运行的。^O^
<%@ Page Debug="true" Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<html>
<head>
<title>DataGrid的自动分页</title>
<script language="C#" runat="server" >

// This data container will be initialize when Page is loaded
DataTable dataTable;

public void Page_Load()
{
string dataSource = "Data Source=localhost;";
string security = "user id=sa; password=;";
string initialCatalog = "initial catalog=pubs;";
string cnnString = dataSource + security + initialCatalog;
SqlConnection connection = new SqlConnection(cnnString);

string strSql = "select * from [authors]";
SqlCommand command = new SqlCommand(strSql, connection);
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = command;
dataTable = new DataTable();

try
{
connection.Open();
adapter.Fill(dataTable);
}
catch(SqlException e)
{
Response.Write(e.ToString());
return;
}
finally
{
connection.Close();
}

if(!IsPostBack)
{
grid1.DataSource = dataTable;
grid1.DataBind();
}
}

public void Grid_PageIndexChanged(object sender, DataGridPageChangedEventArgs e)
{
grid1.CurrentPageIndex = e.NewPageIndex;
grid1.DataSource = dataTable;
grid1.DataBind();
}
</script>
</head>

<body>
<form id="form1" runat="server">
<h3>DataGrid的自动分页</h3>
<asp:DataGrid id="grid1" runat="server" AutoGenerateColumns="true"
AllowPaging="true" OnPageIndexChanged="Grid_PageIndexChanged" >
<HeaderStyle BackColor="lightblue" Font-Name="Arial" Font-Bold="true" />
<ItemStyle BackColor="lightyellow"/>
<PagerStyle Mode="NextPrev" HorizontalAlign="Right"
NextPageText="下一页" PrevPageText="上一页" />
</asp:DataGrid>
</form>
</body>
</html>

WZCNet 2004-10-19