I've been using Access for years, doing a lot of record manipulation programmatically. I've just started with Visual Web Developer using Visual Basic and I'm totally frustrated with how to programmatically manipulate records.
When I try to SET a variable to a database object the intellisense indicates that the command SET is not available. The nearest thing is Settatr or somthing like that. I have looked as several tutorials on the web but they seem to be using VB Script? the code usually starts with a <asp tag. I'm trying to develop in the ASP IDE.
I'm just very confused right now (as you can probably tell). Can someone point me to a tutorial that would show me how to manually add records, retrieve records, etc., on form events like button_click and so forth? Using Access would be ideal.
I'm also very much in the dark as to how to create new SQL server databases.
thanks
Vince