Sunday, June 24, 2012

ASP.Net : SQL Data Connection แบบที่ 3

คล้ายแบบที่ 2 แต่ใช้ DataView
    Dim ds As New DataSet
        Dim dt As New DataTable
        Dim dv As DataView
            DA.Fill(ds, "Table1")
            dt = ds.Tables("Table1")
            dv = dt.DefaultView
            dv.Sort = "Column1 DESC, Column2"
            dv.RowFilter = "Column2 > 800000"
            GridView1.DataSource = dv
            GridView1.DataBind()

No comments:

Post a Comment