VMD / SQLServer 2005 Express Stored Procedure

I am building a Visual Web Developer site with a SQL Server 2005 Express backend. I am trying to create the login page, I have written a stored procedure that takes in the username and password and returns a value which indicates whether the user is valid or not.

My problem now is integrating this stored procedure into the page. In Visual Studio 2003 you could just drag and drop the stored procedure from the Database Explorer window and it would create the neccessary SQLCommand which you can then pass parameters too and recieve return values, i.e:

 

sqlcommand1.Paramters[ "@username" ].value = TextUsername.Text;

sqlcommand1.Paramters[ "@password" ].value = TextPassword.Text;

sqlConnection1.Open();

sqlCommand1.ExecuteNonQuery();

Int Result = (int)sqlcommand.Parameters["@returnvalue"].value;

sqlConnection1.Close();

 

I see in VWD there are SqlDataSource's etc, is this what I need to use to do what I'm looking for and how do they exactly work? Ideally what I'm looking for is when a user clicks login, the contents of the 'username' and 'password' text boxes are queried against the database. What controls and configuration is required to achieve this?

 

Many thanks in advance,

 

Mervski