dewi you need to learn ado.net to do this and it's a big subject. You can add/delete records using just a command object or a dataadapter which is more complicated. Unfortunately posting here and asking somebody to write a book for you in a week is a bit hopeful. In any case here's an example:-
dim conn as SqlConnection
dim cmd as SqlCommand
dim sql as string
conn.connectionstring = [your connections string]
sql = "insert into table (field1, field2) values (value1, value2)"
try
conn.open
cmd.commandtext = sql
cmd.executenonquery
finally
conn.close
end try
My point being if this code raises more questions then a week won't be enough for you to figure this stuff out.
Enter your message below
Sign in or Join us (it's free).