Help with Search for 1 table db and VWD Express
Hi folks.. I'm new to VWD Express, and I hope this is the place to post. I have the book from Wrox, ASP.NET 2.0 Visual Web Developer 2005 Express Edition which is great, but it doesn't have the solution to my problem.. as I'm trying to figure out how to impliment
a search.. Here's the problem / question..
I have a page.. that has a form with form fields that I'll pass the names of these fields as variables using the query string.. Or at least that's my plan.. On page 2 which I want to receive the query string variables, I want to use a grid control to show
all of the found records.. and I was going to use a SQL Datasource control.. with SP's for updates, deletes, inserts, etc.. SP's period for that matter, but I'm wondering if I have to use a Paramater in the TSQL to do so? If I do, then can I pass the value of the form query string variables to the parameter? If I can, can I do so using the wizzards, etc, ? I mean I want to just drag the Grid control on the second page, and use the SQL datasource control to pick out the SP's? It seems logical, but I dont' have the time to try it yet, and thought I'd ask before I do since I'm so limited on time, I don't get to play with these sort of problems much any more!
I thought I'd design the same SP's in Visual DB express which I just love.. Beats the heck out of Access! I don't even see the reason for it now, but that's another subject..
Thank you in advance for you're time!
Tim / AKA HoosierDaddy! (Pronounced Whos ur Daddy, and taken from the fact that I'm from Indiana where folks are called "Hoosiers".. which is again pronoucned "Whosur".. in case you didn't know..as I get asked this all the time!
Regards
|