VB.net和SQL Server怎么做插入

来源:百度知道 编辑:UC知道 时间:2024/06/27 14:15:58

Imports Microsoft.VisualBasic
Imports System.Data
Imports System.Data.SqlClient

Dim cmd As New SqlCommand
Dim conn As New SqlConnection
Dim sqldel = "insert into b values('ren','5')"

conn.ConnectionString = "server=a;database=b;uid=c;pwd=d;"
conn.Open()
cmd.Connection = conn
cmd.CommandText = sqldel
cmd.ExecuteNonQuery()
conn.Close()