燕鱼的水温是多少合适:数据绑定后无法显示

来源:百度文库 编辑:高考问答 时间:2024/04/29 02:54:31
using System;
using System.Data;
using System.Data.SqlClient ;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace news
{
public class First : Page
{
protected System.Web.UI.WebControls.DataGrid MyList;
protected System.Web.UI.WebControls.DataGrid MyList1;

private void Page_Load(Object sender, EventArgs e)
{

if(!IsPostBack)
{

string strConn="Data Source=(local);user id=sa;pwd="+"Initial Catalog=ecollege";
SqlConnection myConnection = new SqlConnection (strConn);
SqlDataAdapter myCommand = new SqlDataAdapter ("select top 12 aa.* FROM aa WHERE typeid=1 order by shijian desc", myConnection);
SqlDataAdapter myCommand1 = new SqlDataAdapter ("select top 12 aa.* FROM aa WHERE typeid=2 order by shijian desc", myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "aa");
myCommand1.Fill(ds, "bb");
MyList.DataSource = ds.Tables["aa"].DefaultView;
MyList1.DataSource = ds.Tables["bb"].DefaultView;
MyList.DataBind();
MyList1.DataBind();
}
}

private void InitializeComponent()
{
this.MyList.DataBinding += new System.EventHandler(this.Page_Load);
this.DataBinding += new System.EventHandler(this.Page_Load);

}

protected string FormatString(string str)
{
str=str.Replace(" ","  ");
str=str.Replace("<","<");
str=str.Replace(">",">");
str=str.Replace('\n'.ToString(),"<br>");
return str;
}

}
}

<td width="608">
<div align="center">
<ASP:DataGrid id="MyList" runat="server" Width="400" GridLines="None" ShowFooter="false" CellPadding="2"
CellSpacing="1" Font-Name="宋体" Font-Size="8pt" EnableViewState="false" AutoGenerateColumns="false">
<Columns>
<asp:TemplateColumn>
<ItemTemplate>
<asp:HyperLink Text='<%# FormatString(DataBinder.Eval(Container.DataItem,"biaoti").ToString())%>' NavigateUrl='<%# "javascript:newwin(\"shownews.aspx?id="+DataBinder.Eval(Container.DataItem,"id").ToString()+"\");" %>' runat="server"/>
<%# DataBinder.Eval(Container.DataItem, "shijian","{0:d}")%>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</ASP:DataGrid>
</div>
</td>