Question

datalist 控制每行显示数据条数的RepeatColumns属性 能否绑定数据 如何绑定数据

<%
string strconn=ConfigurationManager.AppSettings["FLConnectionString"].ToString();
string sql = "select count(*) from Picture";
int i=0;
using (SqlConnection conn = new SqlConnection(strconn))
{ conn.Open();
SqlCommand cmd = new SqlCommand(sql,conn);
i = (int)cmd.ExecuteScalar();
conn.Close();
}
%> 如何把i绑定给<asp:DataList ID="DataList1" runat="server" RepeatColumns=" " DataSourceID="SqlDataSource1" DataKeyField="id" RepeatDirection="Horizontal" >中的RepeatColumns=" " 啊

Answer 1

把i写成一个方法.int Geti(){string strconn=ConfigurationManager.AppSettings["FLConnectionString"].ToString();
string sql = "select count(*) from Picture";
int i=0;
using (SqlConnection conn = new SqlConnection(strconn))
{conn.Open();
SqlCommand cmd = new SqlCommand(sql,conn);
i = (int)cmd.ExecuteScalar();
conn.Close();return i;
}然后这样写绑定一下就能得到I了
<asp:DataList ID="DataList1" runat="server" RepeatColumns='<%#Eval(Geti())>' DataSourceID="SqlDataSource1" DataKeyField="id" RepeatDirection="Horizontal" >}

Answer 2

恐怕不能。我的意思是你不得不人为的代码修改（比如在点击一个按钮的时候写上：Repeater1.RepeatColumns= XX);请参考这个： http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.datalist.repeatcolumns.aspx