Need a little help getting started on accessing a DB in codebehind.

Question

User-601222424 posted

I have been at learning DOT NET for about 3-4 weeks now(coming from the old ASP) and have primarly worked with Web Studio. I am now diving deeper in and need a little "getting Started" help. I undersand the Datacontrols form a gui standpoint but. now I want to access and chage data in the codebehind (VB)

IE when a user clicks a button control or puts a check-mark in a checkbox  I would like run some SQL statments and add(or update)  some records. In the past I would do something like:

Conn=yada yada connection string yada
conn.open MyAccessDB

SQLSTM="Insert into table1....yada yada yada....)"
Conn.execute(SQLSTM)

conn.close

Thanks in Advance