interacting between asp.net and sql server

[keizersoz]

Hi to all,

I have some basic knowledge of sql server and asp.net. Now I would like to write a program that interacts between both. Can someone give me please some guidelines, how I should do this? Should this special code be added to the asp.net code or sql server code? Actually, I would like to read some input values through an asp.net page and initialize some fields of sql table. Furthermore, if someone knows useful links on the matter, please tell me.

thanks in advance,
D. T.

 

[nigelrivett]

You will use ado.net in asp.net to call stored procedures in sql server.
You can access the tables directly but I would advise against it.

Theer should be examples of calling SPs and ado.net with visual studio and loads of books and resourses on the internet for it.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.