两个SQL语句有关系么?一个有条件 PID is null ,一个没有
会不会符合条件的的确如此?
会不会符合条件的的确如此?
解决方案 »
- 超链接打开文件乱码
- =====有大型网站架构经验的朋友进来讨论下...=====
- dropdownlist绑定数据后的“初始化”问题
- SqlDataReader.HasRows的正确用法?
- URL重写 问题来了,正则表达式
- VS.NET调试时不报错了
- 在VS2003里面怎么调用config 配置文件的连接字符串???在配置文件中怎么配置Access数据连接???(急求)
- 如下代码,为什么数据库连接不上?
- w3wp.exe占用资源过大的问题(被挂马后)
- WinFrom嵌入IE中,下拉菜单被挡住,如何解决?(难,高分请教)
- 关于插入行的问题
- 为什么打开模式窗口的脚本在IE 6.0.26以上的版本均不支持,有解决办法么?
dr.Fill(ds,0,8,"voidTable");
dr2.Fill(ds,0,8,"voidTable");
他们的“最小纪录数”和“最大纪录数”去了就正确了,但这样我还怎么样限制我想要这两个DataList显示的最大纪录?
<ItemStyle VerticalAlign="Top"></ItemStyle>
<ItemTemplate>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="3%"><img name="Right_Title_r1_c1" src="Images/Right_Title/Right_Title_r1_c1.gif" width="28" height="25" border="0" alt=""></td>
<td width="88%" background="Images/Right_Title/Right_Title_r1_c2.gif">
<font class="fontfan">
<%# GetTitle(DataBinder.Eval(Container, "DataItem.Title").ToString()) %>
</font>
</td>
<td width="9%" align="right" background="Images/Right_Title/Right_Title_r1_c2.gif"><img name="Right_Title_r1_c3" src="Images/Right_Title/Right_Title_r1_c3.gif" width="68" height="25" border="0" alt=""></td>
</tr>
</table>
<table width="100%" height="154" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" width="100%">
<asp:datagrid id="DataGrid1" DataSource='<%# DataBinder.Eval(Container, "DataItem.myrelation") %>' PageSize="10" runat="server" Width="100%" CssClass="f12" AutoGenerateColumns="False" CellPadding="2" ShowHeader="False" AllowCustomPaging="True" AllowPaging="True" BorderStyle="None" BorderWidth="0px">
<HeaderStyle Font-Names="华文行楷" ForeColor="#330066" BackColor="#7E90B9"></HeaderStyle>
<Columns>
<asp:TemplateColumn>
<ItemTemplate>
<a href='Dataview.aspx?ID=<%# DataBinder.Eval(Container, "DataItem.ID") %>' class="topmenu" target="_blank" title="">
<%# GetTitle(DataBinder.Eval(Container, "DataItem.Title").ToString()) %>
</a>
</ItemTemplate>
</asp:TemplateColumn>
<asp:BoundColumn DataField="RegDate" HeaderText="申请时间">
<HeaderStyle HorizontalAlign="Center" Width="120px" CssClass="f15"></HeaderStyle>
<ItemStyle HorizontalAlign="Center" Width="120px"></ItemStyle>
</asp:BoundColumn>
</Columns>
<PagerStyle Visible="False" Mode="NumericPages"></PagerStyle>
</asp:datagrid>
</td>
<td align="right" width="1" background="Images/Right_middle.gif"><img src="Images/Right_middle.gif" width="1" height="24"></td>
</tr>
</table>
</ItemTemplate>
<HeaderStyle Font-Size="14pt" Font-Names="Arial" Font-Bold="True" ForeColor="#777777" BackColor="#DDDDDD"></HeaderStyle>
</asp:datalist>
----------------------------------------CS----------------------------------------private void Page_Load(object sender, System.EventArgs e)
{
if(!Page.IsPostBack)
{
Right();}
}private void Right()
{
try
{
string CommandText = "Select ID,Title From BigFrom Where PID is null and IndexShow = 1";
SqlConnection Conn = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
DataSet ds = new DataSet();
SqlDataAdapter dr = new SqlDataAdapter(CommandText,Conn);
dr.Fill(ds,"voidTable");SqlDataAdapter dr2 = new SqlDataAdapter("Select ID,Title,Regdate,PID From BigFrom order by Regdate desc",Conn);
dr2.Fill(ds,"voidTable2");
ds.Relations.Add("myrelation", ds.Tables["voidTable"].Columns["ID"], ds.Tables["voidTable2"].Columns["PID"]);dlCategories.DataSource = ds.Tables["voidTable"].DefaultView;
DataBind();
}
catch(System.Exception Ex)
{
Message.Visible = true;
Message.Text = Ex.Message;
}
}//截断字符串
public string GetTitle(string Title)
{
string result = Title.Length > 10? Title.Substring(0,10) + ".":Title;
return result;
}