Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If IsPostBack = False Then
getFind(0)
End If
End Sub
Sub getFind(PageIndex As Integer)
Dim sql As New StringBuilder
sql.Append("mActivities_Name.Contains(""" & txtFind.Text & """)")
sql.Append("|| mActivities_teacher.Contains(""" & txtFind.Text & """)")
sql.Append("|| mActivities_place.Contains(""" & txtFind.Text & """)")
sql.Append("|| mActivities_note.Contains(""" & txtFind.Text & """)")
LinqDataSource1.WhereParameters.Clear()
LinqDataSource1.Where = sql.ToString
LinqDataSource1.DataBind()
GridView1.DataSourceID = "LinqDataSource1"
GridView1.PageIndex = PageIndex
GridView1.DataBind()
End Sub
Private Sub GridView1_PageIndexChanging(sender As Object, e As GridViewPageEventArgs) Handles
GridView1.PageIndexChanging
getFind(e.NewPageIndex)
End Sub
***********************************************
<asp:LinqDataSource ID="LinqDataSource1" runat="server" ContextTypeName="studentActivities.DataClasses_ViewDataContext"
EntityTypeName="" OrderBy="mActivities_Name" TableName="View_mActivities_Selects">
</asp:LinqDataSource>
<asp:GridView ID="GridView1" runat="server"
AllowPaging="True" AutoGenerateColumns="False" >
<Columns>
<asp:BoundField DataField="mActivities_ID" HeaderText="mActivities_ID" SortExpression="mActivities_ID" />
</Columns>
<PagerStyle CssClass="pager" />
</asp:GridView>
ไม่มีความคิดเห็น:
แสดงความคิดเห็น