asp.net 中使用sqlcommandbuilder

最新推荐文章于 2013-10-23 11:45:17 发布

mdot

最新推荐文章于 2013-10-23 11:45:17 发布

阅读量986

点赞数

分类专栏： .net 文章标签： asp.net security command exception table insert

本文链接：https://blog.youkuaiyun.com/mdot/article/details/201246

版权

.net 专栏收录该内容

91 篇文章

订阅专栏

本文介绍了在ASP.NET中使用SqlCommandBuilder的方法。通过示例展示了如何用它产生增加、删除、选择等SQL语句，还演示了对DataTable进行插入、更新和删除操作，最后处理了可能出现的异常。

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

asp.net 中使用sqlcommandbuilder,用它来产生增加，删除，选择等SQL语句，也比较方便的，下面给出个例子

Private Sub UseCommandBuilder()
        Dim connectionString As String = _
           "Integrated Security=SSPI;Persist Security Info=False;" + _
           "Initial Catalog=Northwind;Data Source=LAP800"

        Dim connection As SqlConnection = _
           New SqlConnection(connectionString)
        connection.Open()
        Try
            Dim command As SqlCommand = _
                New SqlCommand("SELECT * FROM Customers", connection)

            Dim adapter As SqlDataAdapter = _
               New SqlDataAdapter(command)
            Dim builder As SqlCommandBuilder = _
               New SqlCommandBuilder(adapter)
            ' Show commands
            Console.WriteLine(builder.GetInsertCommand().CommandText)
            Console.WriteLine(builder.GetUpdateCommand().CommandText)
            Console.WriteLine(builder.GetDeleteCommand().CommandText)

            Dim table As DataTable = New DataTable
            adapter.Fill(table)

            'Use Insert
            Dim row As DataRow  = table.NewRow
            row("CustomerID")   = "PAULK"
            row("CompanyName")  = "Pauly's Edibles"
            row("ContactName")  = "Paul Kimmel"
            row("ContactTitle") = "The Fat Man"
            table.Rows.Add(row)

            'Use Update
            Dim results() As DataRow = _
               table.Select("CustomerID = 'ALFKI'")
            results(0)("Region") = "DE"

            'Use Delete
            Dim deleteThese() As DataRow = _
               table.Select("CustomerID = 'FARLA'")
            For Each row In deleteThese
                row.Delete()
            Next

            adapter.Update(table)
            table.AcceptChanges()

        Catch ex As Exception
            Debug.WriteLine(ex.Message)
            Throw
        Finally
            connection.Close()
        End Try
End Sub

End Module