dataGridView中更新数据到数据库中
来源:互联网 发布:唯一网络 怎么了 编辑:程序博客网 时间:2024/05/23 19:12
Imports System.Data
Imports System.Data.SqlClient
Public Class Form1Class Form1
Dim ds As DataSet
Dim da As SqlDataAdapter
Dim cb As SqlCommandBuilder
Dim cmd As SqlCommand
Dim conn As New SqlConnection("data source=localhost;Database=HAWK;Integrated Security=SSPI;")
Private Sub Form1_Load()Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
conn.Open()
cmd = conn.CreateCommand
cmd.CommandText = "Select sID,sName,class,pro from studentInfo"
da = New SqlDataAdapter(cmd)
ds = New DataSet()
da.Fill(ds)
DataGridView1.DataSource = ds.Tables(0)
End Sub
Private Sub Button1_Click()Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
cmd.CommandText = "Select sID,sName,class,pro from studentInfo"
da = New SqlDataAdapter(cmd)
cb = New SqlCommandBuilder(da)
da.Update(ds)
DataGridView1.Update()
End Sub
End Class
Imports System.Data.SqlClient
Public Class Form1Class Form1
Dim ds As DataSet
Dim da As SqlDataAdapter
Dim cb As SqlCommandBuilder
Dim cmd As SqlCommand
Dim conn As New SqlConnection("data source=localhost;Database=HAWK;Integrated Security=SSPI;")
Private Sub Form1_Load()Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
conn.Open()
cmd = conn.CreateCommand
cmd.CommandText = "Select sID,sName,class,pro from studentInfo"
da = New SqlDataAdapter(cmd)
ds = New DataSet()
da.Fill(ds)
DataGridView1.DataSource = ds.Tables(0)
End Sub
Private Sub Button1_Click()Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
cmd.CommandText = "Select sID,sName,class,pro from studentInfo"
da = New SqlDataAdapter(cmd)
cb = New SqlCommandBuilder(da)
da.Update(ds)
DataGridView1.Update()
End Sub
End Class
- dataGridView中更新数据到数据库中
- 将datagridview内容直接更新到ACCESS数据库中
- 导出DataGridView中数据到EXCEL中
- 更新 DataGridView 中修改过的Cell值到数据库中
- C#中DataGridView的数据批量更新
- dataGridView 粘贴数据并更新到数据库及发送邮件
- 从一个数据库中更新数据到另一个数据库
- Excel中数据读取到datagridview
- DataGridView中数据导出到Excel里
- datagridview中的数据导入到excel中
- C#DataGridView数据拖动到TreeView中
- datagridview数据拖到textbox中
- C#中DataGridView数据导出到Excel
- VB.NET中DataGridView删除指定数据行,并更新数据库
- VB.NET中DataGridView删除指定数据行,并更新数据库
- DataGridView中数据存入数据库方法
- C#中datagridview显示数据库数据
- 在DataGridView中修改后的数据如何保存到数据库
- 北大学子的暴有才诗和同样暴有才的回帖
- Pl/SQL中的数组
- C语言运算符及其优先级汇总表口诀
- "Unsupported major.minor version 49.0"错误
- 易普特--数据处理外包为主的专业bpo公司
- dataGridView中更新数据到数据库中
- 正则表达式
- ASCII表
- 在各种类型字符串之间转换
- 小试将jquery用到自己做的项目
- Access restrictions on Jars 错误
- 正则表达式收集
- packages exported from a fragment are not visible at build time
- 对话框程序中捕获WM_KEYDOWN消息