在SQl数据库中插入datagridview [英] Insert datagridview in SQl database

问题描述

你好，

使用此代码，可以在datagridview中显示来自数据库的数据.

并使用按钮对其进行更新.

但是如何插入在datagridview中的新数据?

导入System.Data.SqlServerCe
公开课表格1
    将myDA昏暗为SqlCeDataAdapter
    将myDataSet变暗为DataSet

    私有子Form1_Load(ByVal发送者作为System.Object，ByVal e作为System.EventArgs)处理MyBase.Load
        Dim con As SqlCeConnection =新的SqlCeConnection(数据源= C:\ Users \ BAS \ Documents \ Visual Studio 2010 \ Projects \ WindowsApplication11 \ WindowsApplication11 \ bin \ Debug \ Spullen.sdf")
        Dim cmd As SqlCeCommand =新的SqlCeCommand("SELECT * FROM Inkoop"，con)
    结束子


    

    私有子Update_Click(发送者为System.Object，e为System.EventArgs)处理Update.Click
        Me.Validate()
        Me.myDA.Update(Me.myDataSet.Tables("Inkoop"))
        Me.myDataSet.AcceptChanges()
    结束子

    私有Sub Laden_Click(发送者为System.Object，e为System.EventArgs)处理Laden.Click
        Dim con As SqlCeConnection =新的SqlCeConnection(数据源= C:\ Users \ BAS \ Documents \ Visual Studio 2010 \ Projects \ WindowsApplication11 \ WindowsApplication11 \ bin \ Debug \ Spullen.sdf")
        Dim cmd As SqlCeCommand =新的SqlCeCommand("SELECT * FROM Inkoop"，con)
        con.Open()
        myDA =新的SqlCeDataAdapter(cmd)
        '一个CommandBuilder对象是必需的，它将为DataAdapter对象自动生成DeleteCommand，UpdateCommand和InsertCommand.
        昏暗的生成器为SqlCeCommandBuilder =新的SqlCeCommandBuilder(myDA)
        myDataSet =新的DataSet()
        myDA.Fill(myDataSet，"Inkoop")
        DataGridView1.DataSource = myDataSet.Tables("Inkoop").DefaultView
        con.Close()
        con =什么都没有
    结束子
末级

解决方案

如果您没有对此感到惊讶，那么datagridview的底部会有一个新行部分.

Hello ,

With this code shows data from a database in a datagridview.

And update it with the button.

But how can i insert new data that i put in the datagridview?

Imports System.Data.SqlServerCe
Public Class Form1
    Dim myDA As SqlCeDataAdapter
    Dim myDataSet As DataSet

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim con As SqlCeConnection = New SqlCeConnection("data source=C:\Users\BAS\Documents\Visual Studio 2010\Projects\WindowsApplication11\WindowsApplication11\bin\Debug\Spullen.sdf")
        Dim cmd As SqlCeCommand = New SqlCeCommand("SELECT * FROM Inkoop", con)
    End Sub


    

    Private Sub Update_Click(sender As System.Object, e As System.EventArgs) Handles Update.Click
        Me.Validate()
        Me.myDA.Update(Me.myDataSet.Tables("Inkoop"))
        Me.myDataSet.AcceptChanges()
    End Sub

    Private Sub Laden_Click(sender As System.Object, e As System.EventArgs) Handles Laden.Click
        Dim con As SqlCeConnection = New SqlCeConnection("data source=C:\Users\BAS\Documents\Visual Studio 2010\Projects\WindowsApplication11\WindowsApplication11\bin\Debug\Spullen.sdf")
        Dim cmd As SqlCeCommand = New SqlCeCommand("SELECT * FROM Inkoop", con)
        con.Open()
        myDA = New SqlCeDataAdapter(cmd)
        'One CommandBuilder object is required, which automatically generates DeleteCommand,UpdateCommand and InsertCommand for DataAdapter object   
        Dim builder As SqlCeCommandBuilder = New SqlCeCommandBuilder(myDA)
        myDataSet = New DataSet()
        myDA.Fill(myDataSet, "Inkoop")
        DataGridView1.DataSource = myDataSet.Tables("Inkoop").DefaultView
        con.Close()
        con = Nothing
    End Sub
End Class

解决方案

If you have not surpressed that, then the datagridview has in the bottom a new line part. 

这篇关于在SQl数据库中插入datagridview的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！