如何将vb2010与sql 2008 r2连接? [英] how to connect vb2010 with sql 2008 r2?

问题描述

你能告诉我如何将Visual Basic 2010与sql2008 r2数据库连接，以及如何添加，检索
数据来自sql 2008 r2数据库?

hi can you tell me how to connect visual basic 2010 with sql2008 r2 database and also add,retrieve
data from sql 2008 r2 database?

推荐答案

有很多方法.
这是最基本的.
检索信息:

There are loads of ways.
Here is the most basic.
Retrieve info:

Using con As New SqlConnection(strConnect)
	con.Open()
	Using com As New SqlCommand("SELECT iD, description FROM myTable", con)
		Using reader As SqlDataReader = com.ExecuteReader()
			While reader.Read()
				Dim id__1 As Integer = CInt(reader("iD"))
				Dim desc As String = DirectCast(reader("description"), String)
				Console.WriteLine("ID: {0}" & vbLf & "    {1}", iD, desc)
			End While
		End Using
	End Using
End Using

插入新行:

Insert new rows:

Using con As New SqlConnection(strConnect)
	con.Open()
	Using com As New SqlCommand("INSERT INTO myTable (myColumn1, myColumn2) VALUES (@C1, @C2)", con)
		com.Parameters.AddWithValue("@C1", myValueForColumn1)
		com.Parameters.AddWithValue("@C2", myValueForColumn2)
		com.ExecuteNonQuery()
	End Using
End Using

这篇关于如何将vb2010与sql 2008 r2连接?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！