ExecuteNonQuery方法用来执行INSERT、UPDATE、DELETE和其他没有返回结果集的SQL语句,并返回执行命令后影响的行数。如果UPDATE和DELETE命令所对应的目标记录不存在,返回0。如果出错,返回-1。
Imports System.Data.SqlClient
Public Class Form1
Dim conn As SqlConnection
Dim da As SqlDataAdapter
Dim ds As DataSet
Private Function GetConnection() As SqlConnection
Return New SqlConnection(My.Settings.SalesConnectionString)
End Function
Private Sub displayData(ByVal str As String)
DataGridView1.DataSource = Nothing
conn = GetConnection()
conn.Open()
Dim comm As New SqlCommand(str, conn)
Dim dr As SqlDataReader = comm.ExecuteReader
Dim dt As New DataTable
dt.Load(dr)
conn.Close()
DataGridView1.DataSource = dt
End Sub
Private Sub InsertRecord()
conn = GetConne