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

Question

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()

How does it not work? Do you get an error? Wher does the error happen? What is the state of the relevant objects at the time? — David
– David, Commented Nov 9, 2011 at 2:28
@LarsTech: still can't insert the data on database and the database is still empty.. :( — Michael Frans
– Michael Frans, Commented Nov 9, 2011 at 2:32
When you debug into the code,mod these statements get executed? Do they have the values you expect? If you profile the database, does the query get executed? If you copy the query from the profiler and execute it manually, what happens? — David
– David, Commented Nov 9, 2011 at 11:06

Adam Wenger · Accepted Answer · 2011-11-09 02:39:37Z

1

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

answered Nov 9, 2011 at 2:39

Adam Wenger

17.7k8 gold badges55 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related