Creating a Web User ID Password

Question

User115673193 posted

I want to create a web form which have a user id and password someone can tell me how its possible. pls write a example code.

 without using of dataset and dataadaptor.

 

Answer 1

User-574293449 posted

hi,

  Can you explain in detail what you need. If you need to check authentication without dataset / data adapter, you can use datareader / exceutescalar with status or set status in output varible.

 

Answer 2

User115673193 posted

i have a database in sqlserver express edition. which have a which have table admin with two field userid and password.

i want to check authentication with datareader. so pls give me some example code.

 

Answer 3

User-306750178 posted

Hi,

Refer below links

http://www.codeproject.com/Questions/339666/verify-user-name-and-password-in-csharp-form

http://www.nullskull.com/q/10235644/how-to-check-existing-username-and-password-with-database-c-net.aspx

http://social.msdn.microsoft.com/Forums/vstudio/en-US/52c538b3-101a-4416-a628-dcc341653150/login-check-using-c-database

Above links have example codes which will help you.

Answer 4

User-574293449 posted

using (SqlConnection conn = new SqlConnection('your connection string'))
using(SqlCommand cmd = new SqlCommand(sqlStatement, conn))
{
   conn.open();
   using (SqlDataReader dr = cmd.ExecuteReader())
   {
        while (dr.Read())
        {
           //read here
        }
   }
}

IF the data present then you can return as authentication passed