我如何插入，更新和放大删除Datagridview中的记录 [英] How can i Insert, Update & Delete Records in Datagridview

问题描述

你好

我正在使用vb.net 2010和sql server 2005制作一些应用程序，我的表中有12列Beini并且有datagridview1。使用以下代码我可以将存储在sql数据库中的所有数据填充到datagridview1。

Hello
i am making some application using vb.net 2010 and sql server 2005, i have 12 columns in my table "Beini" and have datagridview1. usign the following code i can populate all data stored in sql database to datagridview1.

Dim cmd As SqlCommand = New SqlCommand("Select * FROM Beini", conn)
        conn.Open()
        Dim myDA As SqlDataAdapter = New SqlDataAdapter(cmd)
        Dim myDataSet As DataSet = New DataSet()
        myDA.Fill(myDataSet, "Beini")
        DataGridView1.DataSource = myDataSet.Tables("Beini").DesignMode
        conn.close

my问题是我不知道如何添加，删除和更新数据库来自Datagridview1

*当用户对datagridview进行任何更改时，必须在数据库中进行更改

*用户可以通过datagridview将记录插入数据库

*用户可以通过datagridview删除记录



所以我怎么能这样做？

谢谢

i希望你能帮助我

my problem is i didn't know how to Add, Delete And Update Database from Datagridview1
* when the user made any changes on the datagridview, changes must be made at the database
* the user can insert records to the database through datagridview
* the user can delete records through datagridview

so how can i make this ?
thank you
i hope you will help me

推荐答案

转到这个链接你会得到答案你的问题。



http://www.aspdotnet-suresh.com/2011/02/how-to-inserteditupdate-and-delete-data.html [ ^ ]

Go to this link you will get the answer of your question.

http://www.aspdotnet-suresh.com/2011/02/how-to-inserteditupdate-and-delete-data.html[^]

这是你如何开始使用VB.NET编辑DataGridView [ ^ ]



和使用分页在DataGridView中添加，编辑和删除 [ ^ ]

This is how you start DataGridView editing using VB.NET[^]

And Add, Edit, and Delete in DataGridView with Paging[^]

这篇关于我如何插入，更新和放大删除Datagridview中的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！