Log in Validation

Felix Calvo

16y2.9kVisual Basic .NET

How to validate my username and password from my database?help plz...

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dipa Ahuja16y ago
create the login table, and

in design mode take 2textbox and one button(login) and its click event write the code to validate...

i already show you the way, and also Crish has shown another way..

try to use them in your code and if you found any query then post here..
Felix Calvo16y ago
im making windows apps in C#.. plz help.
Dipa Ahuja16y ago
are u working in C# or asp.net?
Felix Calvo16y ago
can you give me the whole code?please!!!!!!!!!!!!!!!!!!!...
Crish16y ago
hi

you can pass the parameter username and password in databse and write query like

if exists(select * from adminuser where username=@username and Password=@Password) , here @username and @password are your passing

parameter value.

If this value exist then return 1 for True and not exist then return 0 for False.

Don't forget to Mark Do you like this Answer that solved your problem!
Jaish Mathews16y ago
Hi,
Built-in service available in asp.net. Check below link.
http://msdn.microsoft.com/en-us/library/ff649314.aspx
Dipa Ahuja16y ago
create the dataAdapter and dataset object..

SqlDataAdapter da;
DataSet ds;

public login()
   {
   InitializeComponent();
   da = new SqlDataAdapter("Select * from login, );
   ds = new DataSet();
   da.Fill(ds, "login");

   }
//submit button clicked
private void btnsubmit_Click(object sender, EventArgs e)
   {
    int cnt=ds.Tables["login"].Rows.Count;
   string id = txtuname.Text.ToString();
   string pwd = txtpw.Text.ToString();

//navigate through login table records
for (int i = 0; i < cnt; i++)
{

       if (ds.Tables[0].Rows[i]["Id"].ToString() == id &&ds.Tables[0].Rows[i]["pw"].ToString() == pwd)
   {
MessageBox.Show("Successfully login !", "Login", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
     }
     }
}