/Default.aspx.cs

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;



public partial class _Default : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {



    }

    protected void btnLogin_Click(object sender, EventArgs e)

    {

        object uid = SqlHelper.ExecuteScalar(GlobalVariable.con, CommandType.Text, "select UserId from tbl_user where UserName='" + txtUserName.Text + "' and Password='" + txtPassword.Text + "'");

        //int userid = Convert.ToInt32(uid.ToString());

        if (uid!=null)

        {

            Response.Redirect("groups.aspx");

        }

        else

        {

            lblMessage.Text = "Invalid login details! try again.";

        }

    }

}