在asp.net中怎样让取出来的记录集前三行后面有个“NEW”字样,也就是让数据集的前三行让自己来控
制显示的方式,在asp中就简单了可是.net小弟刚学啊。。
以下是代码:
index.aspx首页
<asp:DataList ID=RepeaterNews Runat=server Width=220>
<ItemTemplate>
<table width="220" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
·
<a href="NewsManage/NewsDetail.aspx?Flag=1&&NewsId=<%# DataBinder.Eval(Container.DataItem, "NewsId") %>">
<%# DataBinder.Eval(Container.DataItem, "Title") %>
</a>
</td>
</tr>
</table>
</ItemTemplate>
</asp:DataList>index.aspx.cs首页的绑定文件 void BindNews()
{
Operation Op=new Operation();
DataSet ds=Op.GetNewsTopn(9);
RepeaterNews.DataSource=ds.Tables[0].DefaultView;
RepeaterNews.DataBind();
}
Operation.cs中一个方法
public DataSet GetNewsTopn(int n)
{
Database data = new Database(); SqlParameter[] prams = {
data.MakeInParam("@n",System.Data.SqlDbType.Int,4,n)
}; try
{
DataSet SearchContactResult = data.RunProcedure("gzy_GetNewsTopn", prams,"News"); // if the customer id is an empty string, then the create failed
if (SearchContactResult.Tables["News"].Rows.Count > 0 )
return SearchContactResult;
else
return SearchContactResult;
} catch (Exception ex)
{
string strError = ex.Message;
return null;
}
}
database.cs中一个方法
public DataSet RunProcedure(string procName, SqlParameter[] prams,string tableName)
{
DataSet dataSet =new DataSet();
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();
mySqlDataAdapter.SelectCommand =CreateCommand(procName, prams);
mySqlDataAdapter.Fill(dataSet, tableName);
this.Close();
return dataSet; }
制显示的方式,在asp中就简单了可是.net小弟刚学啊。。
以下是代码:
index.aspx首页
<asp:DataList ID=RepeaterNews Runat=server Width=220>
<ItemTemplate>
<table width="220" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
·
<a href="NewsManage/NewsDetail.aspx?Flag=1&&NewsId=<%# DataBinder.Eval(Container.DataItem, "NewsId") %>">
<%# DataBinder.Eval(Container.DataItem, "Title") %>
</a>
</td>
</tr>
</table>
</ItemTemplate>
</asp:DataList>index.aspx.cs首页的绑定文件 void BindNews()
{
Operation Op=new Operation();
DataSet ds=Op.GetNewsTopn(9);
RepeaterNews.DataSource=ds.Tables[0].DefaultView;
RepeaterNews.DataBind();
}
Operation.cs中一个方法
public DataSet GetNewsTopn(int n)
{
Database data = new Database(); SqlParameter[] prams = {
data.MakeInParam("@n",System.Data.SqlDbType.Int,4,n)
}; try
{
DataSet SearchContactResult = data.RunProcedure("gzy_GetNewsTopn", prams,"News"); // if the customer id is an empty string, then the create failed
if (SearchContactResult.Tables["News"].Rows.Count > 0 )
return SearchContactResult;
else
return SearchContactResult;
} catch (Exception ex)
{
string strError = ex.Message;
return null;
}
}
database.cs中一个方法
public DataSet RunProcedure(string procName, SqlParameter[] prams,string tableName)
{
DataSet dataSet =new DataSet();
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();
mySqlDataAdapter.SelectCommand =CreateCommand(procName, prams);
mySqlDataAdapter.Fill(dataSet, tableName);
this.Close();
return dataSet; }
<%# ((ItemIndex+1)<=3)? "New " + Convert.ToString(DataBinder.Eval(Container.DataItem, "Title")):Convert.ToString(DataBinder.Eval(Container.DataItem, "Title")) %>
</a>