Michael Frans
Michael Frans

Reputation: 623

How to insert data on SQL Server Database in VB.NET?

has anyone know how to insert some data on SQL Server database?? i've tried this code, but it not works for me.. here's the code:

    Dim constring As String = "Data source=.\sqlexpress;attachDbFilename=|DataDirectory|\Database1.mdf;integrated security=true;connect timeout=30;user instance=true"
    Dim connection As SqlConnection = New SqlConnection(constring)
    Dim query As SqlCommand

        Dim s As String

        connection.Open()

        s = "insert into login values(@un,@pass)"
        query = New SqlCommand(s, connection)
        query.Parameters.AddWithValue("@un", "111")
        query.Parameters.AddWithValue("@pass", "222")

        query.ExecuteNonQuery()

        connection.Close()

Upvotes: 1

Views: 6065

Answers (1)

Adam Wenger
Adam Wenger

Reputation: 17580

Your syntax to create a login is incorrect. You are looking for:

CREATE LOGIN <loginName>
WITH PASSWORD = 'YourPassword'

More information about Create Login can be found on MSDN

Upvotes: 1

Related Questions