private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
改成:
private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
改成:
private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
D:\web\dataconnect\WebForm1.aspx.cs(66): 方法“dataconnect.WebForm1.DataGrid1_PageIndexChanged(object, System.Web.UI.WebControls.DataGridPageChangedEventArgs)”与委托“void System.EventHandler(object, System.EventArgs)”不匹配我把代码改成
private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
后就出这错,哪儿不对?
DataGrid1.PageIndexChanged += new DataGridPageChangedEventHandler(this.DataGrid1_SelectedIndexChanged);在写这些代码...
private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
然后写事件代码,如下二行
DataGrid1.CurrentPageIndex = e.NewPageIndex;
getData();private void getData()
{
SqlDataAdapter aSqlDataAdapter = new SqlDataAdapter("SELECT CustomerID,City,Country,Phone from Customers",sqlConn);
DataSet aDataSet = new DataSet();
aSqlDataAdapter.Fill(aDataSet,"Customers");
this.DataGrid1.DataSource = aDataSet.Tables[0];
DataGrid1.DataBind();
}
datagrid_PageIndexChanged
{
datagrid.CurrentPageIndex=e.NewPageIndex;
datagrid.SelectedIndex=-1;
getData(); //参照楼上朋友写的!
}
别忘了设置AllowPaging=True;
SqlDataAdapter aSqlDataAdapter = new SqlDataAdapter("SELECT CustomerID,City,Country,Phone from Customers",sqlConn);
里面这个
SELECT CustomerID,City,Country,Phone from Customers
是不是得写成我所联接的那个表的字段和表名吧,呵呵
是不是得写成我所联接的那个表的字段和表名吧,呵呵那是,而且大小写也要注意!
写数据库就要特别注意SQL语句的正确性