Write data to SQL database

[rockking]

alright so when i make a SProc, where do i store it exactly? in the database itself? or where?

[talksandy]

I'd propose some reading. Use some samples and read a DB book. You will be able to run (solve) most of your queries.
http://msdn.microsoft.com/en-us/libr...v=sql.80).aspx

[rockking]

I'd propose some reading. Use some samples and read a DB book. You will be able to solve most of your queries.
http://msdn.microsoft.com/en-us/libr...v=sql.80).aspx

haha queries, database humor. lol

[VictorN]

I'd propose some reading. Use some samples and read a DB book. You will be able to run (solve) most of your queries.
http://msdn.microsoft.com/en-us/libr...v=sql.80).aspx

haha queries, database humor. lol

Excuse me, but what is the reason here to lol?

[TechGnome]

It's not like you have a choice of where to store them. by their very nature they are kept in the database. That said, it would be a good idea to store the sql scripts you used to create them so that if you need to make changes it's easier... those files you can store where ever you like, but what gets run is what's in the database.

-tg

[rockking]

not sure. i was looking for something to take the stress away from trying to get this working. i did make a SProc for inserting data into a database. i need to create a few more, one to update and delete. i dont think they will be to bad, i am going to use the insert one as a sort of template. the only other thing i need to get working, is using a "config" file to give the dataconnection string. this way i can have the app available on more than just one machine, because it would allow for an easy way to change database paths.

[rockking]

alright everyone. i have gotten the "config" file working. i have all my stored procedures created. now the ultimate part.

i need to select data in the database and return the data received. once returned it will be assigned to variables and those variable will be set to the text of the corresponding textboxes.

suggestions?

[TechGnome]

It's geared towards VB, but the principles (and objects/namespaces) are the same....
http://www.vbforums.com/showpost.php...53&postcount=2

-tg

[vinayshirish]

1. I have a jsp file which has dropdown containing product names which are fetched from the sql table. 2. My problem is, when i click the product name from the drop down, it should fetch the productID associated with the product name from the database and that product ID should be updated in another table. So everytime I select product name, it's product ID must be updated in another SQL table**

[VictorN]

1. I have a jsp file which has dropdown containing product names which are fetched from the sql table. ...

And does your problem have to do with this 4.5 years old thread?
And what does this jsp file have to do with the C-Sharp Programming forum?

Please, start a new thread in the appropriate forum and describe your problem (if any) a bit more carefully!