http://forums.asp.net/search/SearchResults.aspx?q=&tag=Executespscalar.&orTags=0&o=DateDescendingSearch results matching tag 'Executespscalar.'en-USCommunityServer 2007 SP1 (Build: 20510.895)http://forums.asp.net/thread/2266314.aspxMon, 31 Mar 2008 04:00:00 GMT4c671506-2930-414c-a40b-8bf57ded5924:2266314suresh.pydi<p>create procedure CheckLoginDetails</p> <p>(</p> <p><a href="mailto:=@username">@username</a>&nbsp; nvarchar(100),</p> <p>@password nvarchar(100)</p> <p>)</p> <p>As</p> <p>Begin</p> <p>&nbsp;</p> <p>select Count(*) from tablename where Username=@username ,password=@password</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>End</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>in Codebehind Ur using Executescalar.</p>