protected void Page_Load(object sender, EventArgs e)
{
if (DataList1.Items.Count == 0)
{
LabelMessage.Text = "No Records";
LabelMessage.Visible = true;
}
else
{
LabelMessage.Visible = false;
}
}Protected Sub SqlDataSource1_Selected()Sub SqlDataSource1_Selected(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceStatusEventArgs) Handles SqlDataSource1.Selected
If e.AffectedRows = 0 Then
myLabel.Text = "No record found!"
Else
myLabel.Text = ""
End If
End Sub
GridView.rows.Count,返回的是GridView當前頁面的記錄數
objectdatasource的selected事件,:e.AffectedRows返回-1
解決辦法:
在ObjectDataSource的Selected事件,取e.ReturnValue的類型,強制轉換類型取這個DataSet的行數
protected void ObjectDataSource1_Selected(object sender, ObjectDataSourceStatusEventArgs e)
{
//Response.Write(e.ReturnValue.GetType().ToString());
EventDataSet.T_EventListDataTable dt = new EventDataSet.T_EventListDataTable();
dt = (EventDataSet.T_EventListDataTable)e.ReturnValue;
Label1.Text = dt.Rows.Count.ToString();
}
啟動並執行時候:
1、注釋藍色和灰色部分,用紅色部分取e.ReturnValue的類型
2、注釋紅色,修改藍色部分,設定類型轉換
e.ReturnValue返回的對象肯定是select的全部,一個DataSet,不過要對應你自己的在資料集裡設定的Adapter