Log in Validation

Question

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

Dipa Ahuja · Answer

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 Calvo · Answer

im making windows apps in C#.. plz help.

Dipa Ahuja · Answer

are u working in C# or asp.net?

Felix Calvo · Answer

can you give me the whole code?please!!!!!!!!!!!!!!!!!!!...

Crish · Answer

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 Mathews · Answer

Hi Built-in service available in asp.net. Check below link. http://msdn.microsoft.com/en-us/library/ff649314.aspx

Dipa Ahuja · Answer

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 { 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); } } }