I am able to create "functions" in SQL2008, but I cannot understand how to execute them within my Visual Studio applications. I have many books that I've purchased which help me greatly, but I find none that discuss directly how to use
SQL with objects on a windows form or how to create actions using "Functions" or "Procedures" by connecting them to objects like bttns or combo boxes to execute them. There needs to be more help in directions that show how to tie screen applicatons to
server side applications. I am able to use Queries within datasets,but not functions or procedures.
Problem I am trying to solve:
I have a Login form that uses two parameters, @UserName and @UserPassword to select a row from my UserTable and to get the data for column "UserStatus" to verify that content shows "Active" rather than "Inactive" or "Null". When all conditions
are correct the "LogIn" Bttn allows movement to the opening screen which is a loan list where a loan (i.e. "LoanNo") is chosen. When a loan number is selected, all other screens and datasets should be filtered to that single loan selection and
locked to that user until released.
I own SQL 2008 and Visual Studio2008, but have 2010
View Complete Post