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()