using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
/// <summary>
/// Summary description for Class1
/// </summary>
public class Class1
{
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["testConnectionString"].ToString());
	public Class1()
	{
		//
		// TODO: Add constructor logic here
		//
	}

    protected void btnlogin(object sender, EventArgs e)
    {
        
        

        string qry = "SELECT * FROM login_table WHERE (eid = '" + txtid + "')AND (epass = '" + txtpass + "')"; "there are error msg show how to use this "
        SqlDataAdapter da = new SqlDataAdapter(qry, con);
        DataSet ds = new DataSet();
        da.Fill(ds);
        if (ds.Tables[0].Rows.Count > 0)
        {
            Response.Redirect("afterlogin.aspx");
            //Session["eid"] = TextBox1.Text;
        }
        else
        {
            Page.RegisterClientScriptBlock("saved", "<script language='javascript' type='text/javascript'>alert('invailid login .');</" + "script>");
            return;
        }

    }
}