如何在vb.net中导入sql? [英] How to import sql in vb.net?

问题描述

我的意思是程序最上部的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
        }
    }
}

这篇关于如何在vb.net中导入sql?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！