asp.net i have some doubt help me please

Question

while i wanna click login button and i want to go to the next webpage...how to do it help me ... i just starting to learn

Rohatash Kumar · Answer

Hi Please refer the below link: http://www.c-sharpcorner.com/uploadfile/rohatash/simple-user-login-in-Asp-Net-using-C-Sharp/

rachayita jaiswal · Answer

Hi Nizam Check your connection string or share you code then we can help you better.

Safeer Safeer · Answer

what is this error sir plz.. Fill: SelectCommand.Connection property has not been initialized.

Iftikar Hussain · Answer

try like this SqlCommand c=new SqlCommand(select userNamepassWord from tbl_login where userName=@username and password=@password); Regards Iftikar

rachayita jaiswal · Answer

protected void btnSubmit_Click(object sender EventArgs e) { DataTable dt = new DataTable(); SqlConnection con = new SqlConnection(Data Source=test; Initial Catalog=test); SqlCommand cmd = new SqlCommand(select * from tablename where name= ' + txtUserName.Text + ' and password= ' + txtUserpassword.text + 'con); SqlDataAdapter ad = new SqlDataAdapter(cmd); ad.Fill(dt); if(dt.Rows.Count>0) { Response.Redirect(Account.aspx); } else { lblerrormsg.Text = wrong details; } } if you are using stored procedure then protected void btnSubmit_Click(object sender EventArgs e) { DataSet ds = new DataSet(); ds = obj_login.GetValidateUser(Validate txtUserName.Text.Trim() txtUserPassword.Text); if (ds.Tables[0].Rows.Count > 0) { Response.Redirect(Home.aspx); } else { lblerrormsg.Text = Invalid UserName or Password!!!; } } public DataSet GetValidateUser(string Fetchtype string Username string Userpwd) { DataSet ds = new DataSet(); try { dbcon.OpenDbConnection(); SqlCommand cmd = new SqlCommand(M_ValidateUser dbcon.MyCon); cmd.CommandType = CommandType.StoredProcedure; SqlParameter p1 = new SqlParameter(); p1.ParameterName = @FetchType; p1.DbType = DbType.String; p1.Direction = ParameterDirection.Input; p1.Value = Fetchtype; SqlParameter p2 = new SqlParameter(); p2.ParameterName = @UserName; p2.DbType = DbType.String; p2.Direction = ParameterDirection.Input; p2.Value = Username; SqlParameter p3 = new SqlParameter(); p3.ParameterName = @UserPassword; p3.DbType = DbType.String; p3.Direction = ParameterDirection.Input; p3.Value = Userpwd; cmd.Parameters.Add(p1); cmd.Parameters.Add(p2); cmd.Parameters.Add(p3); cmd.ExecuteNonQuery(); SqlDataAdapter ad = new SqlDataAdapter(cmd); ad.Fill(ds); } catch (Exception ex) { throw ex; } finally { dbcon.CloseDBConnection(); } return ds; } and the stored procedure will be - ALTER PROCEDURE [dbo].[M_ValidateUser] @UserName nvarchar(100) = '' @UserPassword nvarchar (20) = '' @FetchType nvarchar(10) = '' AS BEGIN if(@FetchType = 'Validate') begin select * from tablename where User_Name = @UserName and User_Password = @UserPassword end END this code will work.

Safeer Safeer · Answer

tbl_login loginId userName passWord and stored procedure like this ALTER PROCEDURE loginadd @userName varchar(50) @passWord varchar(50) as INSERT INTO tbl_login (userName passWord) VALUES (@userName @passWord)

Safeer Safeer · Answer

when am loggin i got error like this

Iftikar Hussain · Answer

Hi Please refer the below link http://www.aspdotnet-suresh.com/2011/12/how-to-create-simple-login-form-using.html Regards Iftikar