一个关于datagrid分页的基础问题~~~~~
把数据库绑定到dropdownlist,在SelectedIndexChanged事件中编写编写,可是当调试时,选择dropdownlist的下拉菜单后,出现以下的错误:
“当 AllowPaging 设置为真并且选定的数据源不实现 ICollection 时,AllowCustomPaging 必须为真,并且 ID 为 dgdlist 的 DataGrid 必须设置 VirtualItemCount。”
代码如下:
-------------------------------------------------------------------------
private void dgdlist_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
dgdlist.CurrentPageIndex = e.NewPageIndex;
dgdlist.DataBind();
}
private void ddlrelation_SelectedIndexChanged(object sender, System.EventArgs e)
{
string strcontact_name = ddlcontact_name.SelectedItem.Text.ToString();
string strrelation = ddlrelation.SelectedItem.Value.ToString();
string strSql = "SELECT friend_name,mobil,co_phone,home_phone,email,MSN,address,post,detail FROM my_contact WHERE"+
" relation='"+strrelation+"' ORDER BY id";
string strCn = "server=xxx;database=mydb;uid=sa;pwd=xxx;";
SqlConnection ObjCn = new SqlConnection(strCn);
SqlCommand ObjCmd = new SqlCommand(strSql,ObjCn);
if(strcontact_name == "bb")
{
ObjCn.Open();
dgdlist.DataSource=ObjCmd.ExecuteReader();
dgdlist.DataBind();
ObjCn.Close();
}
-------------------------------------------------------------------------
请问VirtualItemCount是什么?应该如何设置?如何才能让下拉菜单内容绑定数据库并分页显示成功?请大家赐教,谢谢!!