如何在vb.net中导入sql?

2021-09-16 00:00:00 vb.net sql-server

我的意思是程序最上部的imports关键字.我应该在那里输入什么?

I mean the imports keyword on the uppermost part of the program. What should I type in there?

推荐答案

Imports System.Data
Imports System.Data.SqlClient

下面是一个如何与数据库对话的例子:

Then here's an example of how to talk to the db:

Using cn As New SqlConnection("connection string here"), _
      cmd As New SqlCommand("Sql statements here")

    cn.Open()

    Using rdr As SqlDataReader = cmd.ExecuteReader()
        While rdr.Read()
            ''# Do stuff with the data reader
        End While
    End Using
End Using

和 c# 翻译，因为人们在评论中很好奇:

and a c# translation, because people were curious in the comments:

using (var cn = new SqlConnection("connection string here"))
using (var cmd = new SqlCommand("Sql statements here"))
{
    cn.Open();
    using (var rdr = cmd.ExecuteReader())
    {
        while (rdr.Read())
        {
            // Do stuff with the data reader
        }
    }
}

相关文章