Hi! Sorry if this is a stupid newbie question; I'm new to using Visual Studio 2005 with sql server/asp.net/c# .
I'm currently creating a website and i need functionality to search for a particular reference in my database and have it displayed on the page. For example, the way you can search for a book on amazon.com.
I know what needs to be done, but I'm having issues with where to insert the sql commands? I have code behind my page(c#) if (dropdownlist1.value) = whatever... then I need to have select * from [table] where textbox1.text = value to be search for.
Can I insert sql commands in the middle of my c# code?? I'm pretty confused! Or does it need to be in the asp.net code? If so, how do I link the c# and asp code??
Thanks for your help I'm so confused!!
JAK