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.

"Gandalf" <go******@gmail.comwrote in message
news:11*********************@o61g2000hsh.googlegro ups.com...

>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()

[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/s...px?item=insert)
--
David Wier
MVP/ASPInsider
http://aspnet101.com
http://iWritePro.com

"Gandalf" <go******@gmail.comwrote in message
news:11*********************@o61g2000hsh.googlegro ups.com...

>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()

[Gandalf]

On Jul 16, 4:56 pm, "David Wier" <[e-mail]>
wrote:

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/s...px?item=insert)
--
David Wier
MVP/ASPInsiderhttp://aspnet101.comhttp://iWritePro.com

"Gandalf" <[e-mail] in message

news:11*********************@o61g2000hsh.googlegro ups.com...

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()

thanks guys!