求教各位大虾 关于修改 删除表的问题
开发一个WINDOWS应用程序 我用的是SQL SERVER数据库 把表导入窗体中后 怎么在点击事件中修改和删除表的内容……???
[解决办法]
导入到窗体的什么控件?如果是DataGridView或DataGrid的话,请看:
Public Class Form1
Dim conn As Data.OleDb.OleDbConnection
Dim da As Data.OleDb.OleDbDataAdapter
Dim ds As Data.DataSet
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
DataGridView1.AllowUserToOrderColumns = False
conn = New OleDb.OleDbConnection( "Provider=Microsoft.Jet.OleDb.4.0;Data Source=D:\data.mdb ")
conn.Open()
da = New OleDb.OleDbDataAdapter( "SELECT * FROM 表1 ", conn)
ds = New Data.DataSet
da.Fill(ds)
conn.Close()
DataGridView1.DataSource = ds.Tables(0)
End Sub
Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim b As OleDb.OleDbCommandBuilder = New OleDb.OleDbCommandBuilder(da)
Try
da.Update(ds)
ds.AcceptChanges()
MsgBox( "Updated ")
Catch ex As Exception
MsgBox( "Error ")
End Try
End Sub
End Class
点击Button1时修改自动加入源数据库。
OleDbCommandBuilder是SQL语句生成器。如果您要改变的只是DataTable,那么直接ds.AcceptChanges()就可以了。