Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mayellj
Starting Member
1 Post |
 Posted - 2008-03-15 : 13:00:40
|
| Hello all!I am currently building a website and have reached a brickwall called SQL..I hope this is ok to post on this forum I wasn't sure if I had come to the right place!Basically I have an SQL database on my server and I would like to have my website access it and update information on a page i.e. :Item Name: Quantity Sold: Price:T-shirt 50 $10Jeans 25 £20How easy is such a thing to do as I have a very limited knowledge of SQL and especially incorporating it into web code..Thanks!jake |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-15 : 13:17:37
|
| You can use connection strings to pull data from SQL Server.check http://connectionstrings.com/ |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-03-15 : 14:19:48
|
| create a connection with the corect connection stringcreate a sql command with the sql text you want to execute.attach the connection to your sql commandexecute the command.if you're using .net look into SqlConnection, SqlCommand, SqlDataAdapter, SqlDataReader in msdn_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
|
|
|
Reading database question..