Visual Web developer 2005 and SQL server

Hi to everyone, somebody can tell me how to validate a login with an aspx page and sql server with visual web developer 2005, it's my first time using web developer so i don't know how to do that!!

Any help would be appreciated



Answer this question

Visual Web developer 2005 and SQL server

  • Dr. Zoop

    You can use the Login controls with SQL Server 2000, but you will have to reconfigure the membership and role providers.

    Have a look at the following post,
    Configuring ASP.Net 2.0 Application services to use SQL2000 or SQL2005

  • HK.Lee

    Thanks for the info guys, but what i'm trying to do is to login and validate the user via SQL server, with a table of the database, and i don't know if visual web developer 2005 express allow this or maybe i need another version  Tongue Tied

    Already tried with the login control and nothing, i tried with a text box and buttons and labels, but i don't know the property to read the data for the sql selection, you know like in delphi the sentence execute and then pass the value to a variable but i'm having problems with that Tongue Tied

    Thanks to all for your comments and i hope that can help me to solve this issue.

  • alpstar01

     i tried Tongue Tied but i get an error:

    check this link for the image:

    www.clubcorsachiwas.com.mx/images/sqlerror.jpg

    Idea Any ideas to solve it!!!

    Thank you!!!

    Big Smile

  • GavinT

    That is a conflict between the collation on you server and the scripts that you are trying to load, It has been a while since I played with collation problems. I would go to the SQL Server forums and ask the guys there.

  • EricEarle

    What exactly are you trying to do For simple user validation, all you have to do really is drag/drop a Login control onto on of your pages. You can allow users to register on your website with the CreateUserWizard control.

    There are also other security type controls on the Login tab of the toolbox. Start looking there...

  • Manish_Jain

    Have a look at the following post, it goes through setting up a login system in about 24 lines of code.

    http://weblogs.asp.net/scottgu/archive/2005/10/18/427754.aspx



  • Visual Web developer 2005 and SQL server