Database

[Gandalf]

I study the manual of W3Schools, And couldn't find enough
explanation for Databases.
I managed to understand how to pull out data from table, But don't
know yet how to update and insert data.

This code pulls data from a table. I would like you to show me how
should I update and insert data to the same table, if you too busy,
then link for a good manual that explain this stuff would be nice too.
(sorry for my english)
thanks

dim dbconn,sql,dbcomm,dbread
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data
source=" & server.mappath("/a/northwind.mdb"))
dbconn.Open()
sql="SELECT * FROM customers"
dbcomm=New OleDbCommand(sql,dbconn)
dbread=dbcomm.ExecuteReader()
customers.DataSource=dbread
customers.DataBind()
dbread.Close()
dbconn.Close()

 

[sloan]

Here are some samples:
http://www.asp101.com/samples/

make sure you get the "DotNet" versions.

 

[David Wier]

Will you be using a combination of textboxes, dropdownlists, etc for the
insert form, or one of the built in controls, like a DetailsView?

(All the items containing 'insert', at ASPNet101.com:
http://www.aspnet101.com/aspnet101/search.aspx?item=insert)

 

[Gandalf]

Will you be using a combination of textboxes, dropdownlists, etc for the
insert form, or one of the built in controls, like a DetailsView?

(All the items containing 'insert', at ASPNet101.com:http://www.aspnet101.com/aspnet101/search.aspx?item=insert)

thanks guys!