>Hi
>
>How I make to insert dataset in sqlserver 2005 database with vs 2003.
>
>Thank'u

Daniel,

        Dim myCon As New System.Data.SqlClient.SqlConnection
        myCon.ConnectionString = "Persist Security Info=False;Integrated Security=SSPI;database=northwind;server=mySQLServer"

        Dim myCmd As New System.Data.SqlClient.SqlCommand
        With myCmd
            .Connection = myCon
            .CommandText = "INSERT INTO [Customers] (CompanyName) VALUES ('MyCompany')"
            .CommandType = CommandType.Text
        End With

        myCon.Open()
        If myCmd.ExecuteNonQuery() <> 1 Then
            ' An error occurred, do something
        End If
        myCon.Close()