hello, im programing in VB.NET
and im trying to get into how i shoud work with my Access Database in .NET
hope you can help me...i have tried getting code examples for varius examples, some i have gotten to work, but its a jungle out there =)
hope you can help me with the most of these atleast, i prefer a little code example if you feel like helping or a nice little link =)
i know how to connect to an database already so i dont need to know that, i am using OleDbConnection to do that btw.
what i need to know is this...
how to...
update an value
delete an value
add a new value (rs.addnew in ordinary ASP)
check if value exists
(the first 4 may be fuzzy explained, im using Swedish Office and didnt find any good words atm, hope "value" will do fine
)
add tables
delete tables
rename tables
copy tables
check if an table exists
add column in table
delete column in table
rename column in table
copy column in table
check if column exists in table
big thanks in advance
and im trying to get into how i shoud work with my Access Database in .NET
hope you can help me...i have tried getting code examples for varius examples, some i have gotten to work, but its a jungle out there =)
hope you can help me with the most of these atleast, i prefer a little code example if you feel like helping or a nice little link =)
i know how to connect to an database already so i dont need to know that, i am using OleDbConnection to do that btw.
what i need to know is this...
how to...
update an value
delete an value
add a new value (rs.addnew in ordinary ASP)
check if value exists
(the first 4 may be fuzzy explained, im using Swedish Office and didnt find any good words atm, hope "value" will do fine
)add tables
delete tables
rename tables
copy tables
check if an table exists
add column in table
delete column in table
rename column in table
copy column in table
check if column exists in table
big thanks in advance