Hi!
There is a little bit think I didnt understand. I should be wrong in my way.This is my log in interface. When I leave textbox blank he let you inform that textbox are blank, etc...Then when I introduce the username and password. Even it's correct its bugging on this line of code:
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["mfwamba"].ConnectionString);
After that I do try this:
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["localhost\\sqlexpress\\mfwamba"].ConnectionString);
Even this line of code that's not work.
I put the right that DBconnection. But its does not work. What's happen. Need help please:
using System;using System.Data;using System.Data.SqlClient;using System.Configuration;
protected void btnSubmit_Click(object sender, EventArgs e){SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["mfwamba"].ConnectionString);con.Open();SqlCommand cmd = new SqlCommand("select * from UserInformation where UserName =@username and Password=@password",con);cmd.Parameters.AddWithValue("@username", txtUserName.Text);cmd.Parameters.AddWithValue("@password", txtPWD.Text);SqlDataAdapter da = new SqlDataAdapter(cmd);DataTable dt = new DataTable();da.Fill(dt);if(dt.Rows.Count>0){Response.Redirect("Details.aspx");}else{ClientScript.RegisterStartupScript(Page.GetType(), "validation", "<script language='javascript'>alert('Invalid Username and Password')</script>");}}