溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
這篇文章主要為大家展示了“VB.NET數據庫怎么用”，內容簡而易懂，條理清晰，希望能夠幫助大家解決疑惑，下面讓小編帶領大家一起研究并學習一下“VB.NET數據庫怎么用”這篇文章吧。
VB.NET數據庫代碼示例：
Imports System
Imports System.Data
Imports System.Data.SqlClient
public Class MainClassclass MainClass
Shared Sub Main()Sub Main()
Dim thisConnection As New SqlConnection
("server=(local)\SQLEXPRESS;" & _
"integrated security=sspi;database=
MyDatabase")
' Sql Query
Dim sql As String = "SELECT *
FROM Employee "
Dim insertSql As String = "INSERT
INTO Employee " & _
"(ID, FirstName, LastName)VALUES" & _
"(@ID, @FirstName, @LastName)"
Try
' Create Data Adapter
Dim da As New SqlDataAdapter
da.SelectCommand = New SqlCommand
(sql, thisConnection)
' Create and fill Dataset
Dim ds As New DataSet
da.Fill(ds, "Employee")
' Get the Data Table
Dim dt As DataTable = ds.Tables
("Employee")
' Display Rows Before Changed
Console.WriteLine("Before altering
the dataset")
For Each row As DataRow In dt.Rows
Console.WriteLine("{0} | {1} | {2}", _
row("ID").ToString().PadRight(10), _
row("FirstName").ToString().PadRight(10), _
row("LastName"))
Next
' Add A Row
Dim newRow As DataRow = dt.NewRow()
newRow("FirstName") = "Edna"
newRow("LastName") = "Everage"
newRow("ID") = "2"
dt.Rows.Add(newRow)
' Display Rows After Alteration
Console.WriteLine("=========")
Console.WriteLine("After
altering the dataset")
For Each row As DataRow In dt.Rows
Console.WriteLine("{0} | {1} | {2}", _
row("ID").ToString().PadRight(10), _
row("FirstName").ToString().PadRight(10), _
row("LastName"))
Next
' Insert employees
' 1. Create command
Dim insertCmd As New SqlCommand
(insertSql, thisConnection)
' 2. Map parameters
insertCmd.Parameters.Add("@FirstName", _
SqlDbType.NVarChar, 10, "FirstName")
insertCmd.Parameters.Add("@LastName", _
SqlDbType.NVarChar, 20, "LastName")
insertCmd.Parameters.Add("@ID", _
SqlDbType.Int, 15, "ID")
' 3. Insert employees
da.InsertCommand = insertCmd
da.Update(ds, "Employee")
Catch ex As SqlException
' Display error
Console.WriteLine("Error: "
& ex.ToString())
Finally
' Close Connection
thisConnection.Close()
Console.WriteLine("Connection
Closed")
End Try
End Sub
End Class
以上是“VB.NET數據庫怎么用”這篇文章的所有內容，感謝各位的閱讀！相信大家都有了一定的了解，希望分享的內容對大家有所幫助，如果還想學習更多知識，歡迎關注億速云行業資訊頻道！
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
