dataset删除数据

最新推荐文章于 2018-01-29 10:17:21 发布

xuandhu

最新推荐文章于 2018-01-29 10:17:21 发布

阅读量1.6k

点赞数

CC 4.0 BY-SA版权

分类专栏： ASP.NET数据处理文章标签： dataset datagrid button webform function web

本文链接：https://blog.youkuaiyun.com/xuandhu/article/details/104340

ASP.NET数据处理专栏收录该内容

25 篇文章

订阅专栏

这篇博客展示了如何在VB.NET的Web表单中实现数据删除操作。通过实例，作者解释了如何利用DataSet、DataGrid和DropDownList控件，结合OleDb连接删除指定ID的记录，并在页面上显示更新后的数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Imports System.Data
Imports System.Data.OleDb

Public Class WebForm4
Inherits System.Web.UI.Page

#Region " Web 窗体设计器生成的代码 "

'该调用是 Web 窗体设计器所必需的。
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

    End Sub
    Protected WithEvents DataGrid1 As System.Web.UI.WebControls.DataGrid
    Protected WithEvents Button1 As System.Web.UI.WebControls.Button
    Protected WithEvents DropDownList1 As System.Web.UI.WebControls.DropDownList

    '注意: 以下占位符声明是 Web 窗体设计器所必需的。
    '不要删除或移动它。
    Private designerPlaceholderDeclaration As System.Object

    Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
        'CODEGEN: 此方法调用是 Web 窗体设计器所必需的
        '不要使用代码编辑器修改它。
        InitializeComponent()
    End Sub

#End Region

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        If Not IsPostBack Then
            mydatashow()
        End If
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Response.Write(DropDownList1.SelectedItem.Value)
        Dim myconnection As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("aspnet.mdb"))
        Dim myadapter As OleDbDataAdapter = New OleDbDataAdapter("select * from student where id=" + DropDownList1.SelectedItem.Value.ToString, myconnection)
        Dim mydataset As DataSet = New DataSet
        myadapter.Fill(mydataset, "student")
        Dim mybuilder As OleDbCommandBuilder = New OleDbCommandBuilder(myadapter)
        mydataset.Tables("student").Rows(0).Delete()
        myadapter.Update(mydataset, "student")
        mydatashow()
    End Sub

    Private Function mydatashow()
        Dim myconnection As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("aspnet.mdb"))
        Dim myadapter As OleDbDataAdapter = New OleDbDataAdapter("select * from student ", myconnection)
        Dim mydataset As DataSet = New DataSet
        myadapter.Fill(mydataset, "student")
        DataGrid1.DataSource = mydataset.Tables("student").DefaultView
        DataGrid1.DataBind()
        DropDownList1.DataSource = mydataset.Tables("student").DefaultView
        DropDownList1.DataTextField = "id"
        DropDownList1.DataValueField = "id"
        DropDownList1.DataBind()
        myconnection.Close()
    End Function
End Class