用数据绑定啊,非常简单。
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.SqlClient"%>
<%@Import Namespace="System.Data.OleDb"%>
<%@Import Namespace="System.Web"%>
<%@Import Namespace="System.Web.Security"%>
<%@Import Namespace="System.Web.UI"%>
<%@Import Namespace="System.Web.UI.WebControls"%>
<%@Import Namespace="System.Web.UI.HtmlControls"%>
<html>
<form id="form1" runat="server">
<Script Language=C# Runat=Server>
void Page_Load(Object Src, EventArgs E)
{
SqlConnection dtcon = new SqlConnection("server=10.6.17.7.;database=data2008;uid=sa;pwd=123");
SqlCommand dtcmd = new SqlCommand("exec test_1 '2010-1-1','2010-1-31'", dtcon);
//dtcon.Open();
SqlDataAdapter NewAdapter=new SqlDataAdapter();
NewAdapter.SelectCommand=dtcmd;
DataSet dtSet = new DataSet();
NewAdapter.Fill(dtSet,"ta");
DataView dv=new DataView(dtSet.Tables[0]);
MyDataGrid.DataSource=dv;
MyDataGrid.DataBind();
dtcon.Close();
}
<h3><font face="宋体">将 SQL 数据绑定到 DataGrid</font></h3>
<ASP:DataGrid id="MyDataGrid" runat="server"
Width="700"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="宋体"
Font-Size="9pt"
HeaderStyle-BackColor="#aaaadd"
EnableViewState="false"
align=left
/>
<br>
以上是我在用的代码
温馨提示:答案为网友推荐,仅供参考