file:///C:\Users\j\Desktop\WebSite\Default.aspx.vb新写法-CSDN博客

本文链接：https://blog.csdn.net/eds124/article/details/86682179

Partial Class _Default
    Inherits System.Web.UI.Page

    Protected Sub GridView1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.Load
        If IsPostBack Then
            Return
        End If
        Using sds As SqlDataSource = New SqlDataSource("data source=192.168.0.44;initial catalog=master;user id=sa;password=Abc2008def", "select * from t_user")
            Me.GridView1.AllowPaging = True
            Me.GridView1.AutoGenerateDeleteButton = True
            Me.GridView1.AutoGenerateEditButton = True
            Me.GridView1.AutoGenerateSelectButton = True
            Me.GridView1.DataKeyNames = New String() {"p_user_id"}
            Me.GridView1.DataSource = sds
            Me.GridView1.DataBind()
        End Using
    End Sub

    Protected Sub GridView1_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs) Handles GridView1.PageIndexChanging
        Using sds As SqlDataSource = New SqlDataSource("data source=192.168.0.44;initial catalog=master;user id=sa;password=Abc2008def", "select * from t_user")
            Me.GridView1.PageIndex = e.NewPageIndex
            Me.GridView1.DataSource = sds
            Me.GridView1.DataBind()
        End Using
    End Sub

    Protected Sub GridView1_RowCancelingEdit(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCancelEditEventArgs) Handles GridView1.RowCancelingEdit
        Using sds As SqlDataSource = New SqlDataSource("data source=192.168.0.44;initial catalog=master;user id=sa;password=Abc2008def", "select * from t_user")
            Me.GridView1.EditIndex = -1
            Me.GridView1.DataSource = sds
            Me.GridView1.DataBind()
        End Using
    End Sub

    Protected Sub GridView1_RowDeleting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewDeleteEventArgs) Handles GridView1.RowDeleting
        Using sds As SqlDataSource = New SqlDataSource("data source=192.168.0.44;initial catalog=master;user id=sa;password=Abc2008def", "select * from t_user")
            sds.DeleteCommand = "delete from t_user where p_user_id = @p_user_id"
            sds.DeleteParameters.Add("p_user_id", Me.GridView1.DataKeys(e.RowIndex).Values("p_user_id").ToString())
            sds.Delete()
            Me.GridView1.DataSource = sds
            Me.GridView1.DataBind()
        End Using
    End Sub

    Protected Sub GridView1_RowEditing(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewEditEventArgs) Handles GridView1.RowEditing
        Using sds As SqlDataSource = New SqlDataSource("data source=192.168.0.44;initial catalog=master;user id=sa;password=Abc2008def", "select * from t_user")
            Me.GridView1.EditIndex = e.NewEditIndex
            Me.GridView1.DataSource = sds
            Me.GridView1.DataBind()
        End Using
    End Sub

End Class