求vb.net执行SQL方法！！ - 编程论坛

#2

myhuangjin2013-02-16 19:49

sql

sqlCmd As New SqlCommand("", sqlCn)
dim strSql as string="insert into #tmp select * from TableA"
= strSql
sqlCmd.ExecuteNonQuery()

#3

pgjtz2013-11-12 01:07

Imports System.Data.SqlClient
Imports System.Data

Dim sqlconn As New SqlConnection
        Dim sqlcomm As New SqlCommand
        Dim connStr As String
        '应加上数据库服务器名，数据库名，数据库密码
        connStr = "Server=192.168.10.89;Database=dvr-data;user Id=sa;Password="
        sqlconn.ConnectionString = connStr

        '应加上数据库服务器测试，数据库名及数据库密码测试
        sqlconn.Open()
        sqlcomm.Connection = sqlconn
        Dim dataRd As SqlDataReader
         = CommandType.Text
        Dim commStr As String
        commStr = "SELECT DVR_Data.* FROM DVR_Data"
         = commStr
        sqlconn.Close()
        sqlconn.Open()
        dataRd = sqlcomm.ExecuteReader

#4

xiezhouyi2016-08-01 12:36

这样写如果换了数据库名称和电脑IP改变了怎么办

#5

xiezhouyi2016-08-01 12:36

这样写如果换了数据库名称和电脑IP改变了怎么办