Henter connection string fra din app.config, laver en SqlConnection udfra den, laver en SqlCommand med SQL sætning, kalder ExecuteReader/ExecuteNonQuery/ExecuteScalar på den.
Imports System Imports System.Data.SqlClient Imports System.Configuration
Namespace E Public Class Program Public Shared Sub Main(args As String()) Dim con As New SqlConnection(ConfigurationManager.ConnectionStrings("ExpressTest").ConnectionString) con.Open() Dim cmd As New SqlCommand("SELECT * FROM T1", con) Dim rdr As SqlDataReader = cmd.ExecuteReader() While rdr.Read() Console.WriteLine(rdr(0) & " " & rdr(1)) End While rdr.Close() con.Close() Console.ReadKey() End Sub End Class End Namespace
Dim strSQL As String = "INSERT INTO Projects (Title, StartingDate, EndDate, Employe, Costumer) VALUES (@Title, @StartingDate, @EndDate, @Employe, @Costumer)"
Dim con As New SqlConnection(ConfigurationSettings.AppSettings("Conn")) con.Open() Dim cmd As New SqlCommand(strSQL, con)
Dim paramID As SqlParameter paramID = New SqlParameter("@Title", SqlDbType.VarChar) paramID.Value = Title.Text cmd.Parameters.Add(paramID)
Dim paramStartingDate As SqlParameter paramStartingDate = New SqlParameter("@StartingDate", SqlDbType.Date) paramStartingDate.Value = StartingDate.Text cmd.Parameters.Add(paramStartingDate)
Dim paramEndDate As SqlParameter paramEndDate = New SqlParameter("@EndDate", SqlDbType.Date) paramEndDate.Value = EndingDate.Text cmd.Parameters.Add(paramEndDate)
Dim paramEmploye As SqlParameter paramEmploye = New SqlParameter("@Employe", SqlDbType.VarChar) paramEmploye.Value = Employe.Text cmd.Parameters.Add(paramEmploye)
Dim paramCostumer As SqlParameter paramCostumer = New SqlParameter("@Costumer", SqlDbType.Int) paramCostumer.Value = Costumer.SelectedValue cmd.Parameters.Add(paramCostumer)
cmd.ExecuteNonQuery()
con.Close()
Men den kommer med en fejl når jeg køre koden:
The ConnectionString property has not been initialized.
Så kommer den igen med det med at ConfigurationManager ikke er "declared"..
Du får lige hele siden:
Imports System Imports System.Data.SqlClient Imports System.Configuration
Public Class NewProject
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim strSQL As String = "INSERT INTO Projects (Title, StartingDate, EndDate, Employe, Costumer) VALUES (@Title, @StartingDate, @EndDate, @Employe, @Costumer)"
Dim con As New SqlConnection(ConfigurationManager.ConnectionStrings("Conn").ConnectionString) con.Open() Dim cmd As New SqlCommand(strSQL, con)
Dim paramID As SqlParameter paramID = New SqlParameter("@Title", SqlDbType.VarChar) paramID.Value = Title.Text cmd.Parameters.Add(paramID)
Dim paramStartingDate As SqlParameter paramStartingDate = New SqlParameter("@StartingDate", SqlDbType.Date) paramStartingDate.Value = StartingDate.Text cmd.Parameters.Add(paramStartingDate)
Dim paramEndDate As SqlParameter paramEndDate = New SqlParameter("@EndDate", SqlDbType.Date) paramEndDate.Value = EndingDate.Text cmd.Parameters.Add(paramEndDate)
Dim paramEmploye As SqlParameter paramEmploye = New SqlParameter("@Employe", SqlDbType.VarChar) paramEmploye.Value = Employe.Text cmd.Parameters.Add(paramEmploye)
Dim paramCostumer As SqlParameter paramCostumer = New SqlParameter("@Costumer", SqlDbType.Int) paramCostumer.Value = Costumer.SelectedValue cmd.Parameters.Add(paramCostumer)
Arh.. Har fundet ud af at lave en reference til System.Configuration.dll..
Men den udføre ikke koden.. Jeg har tilføjet en Close() i bunden af kode, så den lukke min form når jeg klikker på knappen.. og det virker fint.. Men den tilføjer ikke noget til databasen, og kommer heller ikke med fejl..
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.