SharePoint, .Net, SQL, MS BI, Collaboration and Gadgets

If you have two aspx pages (sharepoint views) and need to pass some value from the parent view (aspx page1) to the child view (aspx page2) based on the user selection and filter the second view based on that parameter. Please check it out here…

http://www.theserverside.net/tt/articles/showarticle.tss?id=WebParts2

We must use xp_cmdshell and an application which executes the command like sqlcmd or OSQL (and the –I switch). Here’s an example of how to do it:

osql -S%1 -U%2 -P%3 -d%4 -i”.\DataConversion.sql”

where –S,-U etc are the various options…