Related:
- How to Store Data In Sql Server
- Play store download - Download - App downloads
- How to hide app store on ipad - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Incoming mail server for gmail - Guide
- Export diagram sql server - Guide
2 replies
tommo2785
Posts
15
Registration date
Wednesday June 17, 2009
Status
Member
Last seen
June 19, 2009
2
Jun 18, 2009 at 09:47 AM
Jun 18, 2009 at 09:47 AM
here is a link that shows examples on PHP
will give you the general format
http://www.webmasterworld.com/databases_sql_mysql/3011940.htm
still though check out w3schools they have good information easily explained covering all the basics. another place to look for questions others have already answered is SQLteam.com I also regularly go through there reading threads and learning more.
will give you the general format
http://www.webmasterworld.com/databases_sql_mysql/3011940.htm
still though check out w3schools they have good information easily explained covering all the basics. another place to look for questions others have already answered is SQLteam.com I also regularly go through there reading threads and learning more.
tommo2785
Posts
15
Registration date
Wednesday June 17, 2009
Status
Member
Last seen
June 19, 2009
2
Jun 18, 2009 at 08:13 AM
Jun 18, 2009 at 08:13 AM
what exactly are you refering to? question about taking information off the form or question relating to the input of data into the DB/
If it is the former i cannot help as i have not learned that yet, however SQL language is Easy
INSERT INTO table_name
VALUES (value1, value2, value3,...);
INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...);
both those examples were plagiarized from w3schools. Really good information on here and easy to follow this was one of the sites i studied whilst doing Modules on Databases, helped me receive a 7 or high distinction.
they also have tutorials on ASP PHP CSS HTML etc. study that,and you will work out your own answer it is very easy working on database.
If your database is already functional with tables and relations correctly assigned and constrained with DDL the rest is easy, Designing a good EER DB is a fair bit mor challenging, hence why those guys are some of the best paid in the industry
If it is the former i cannot help as i have not learned that yet, however SQL language is Easy
INSERT INTO table_name
VALUES (value1, value2, value3,...);
INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...);
both those examples were plagiarized from w3schools. Really good information on here and easy to follow this was one of the sites i studied whilst doing Modules on Databases, helped me receive a 7 or high distinction.
they also have tutorials on ASP PHP CSS HTML etc. study that,and you will work out your own answer it is very easy working on database.
If your database is already functional with tables and relations correctly assigned and constrained with DDL the rest is easy, Designing a good EER DB is a fair bit mor challenging, hence why those guys are some of the best paid in the industry
Aug 4, 2009 at 05:47 AM
Well if u design asp page than for insrting data in sql server 2000 . u recquired to import namespaces sql.data and sq.data.client
after that u define object for sqlconnection.sqlcommand and sqldatareader
make a connection on page load.
and open that connection.
After making connection with server u have to fire sql query for insert values and pas the textbox values .
finally execute ommand executenonquery.