.net light box

Hi
    Atal
          u can refer this code it is working textbox values are passing from lightbox textbox  to sql you can also check below link

http://www.aspdotnet-suresh.com/2010/08/lightbox-effect-for-login-page-in.html

.aspx code
-----------

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Login1.aspx.cs" Inherits="Login1" %>




   
   


   

   
        Click Here
   

                    width="100%">
           
               
           
           
               
           
       

width="100%">                                                                                                                                                                                                                                                                                                                                                                     Login Form                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               Username:                                                                                                                                                                                                                 Password:

       

           

   

   

   

   

code behind:-
-------------

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Text;
using System.Net.Mail;
using System.Net;

public partial class Login1 : System.Web.UI.Page
{

    String connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["Constring"].ToString();
    DataTable dt;
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void sub_Click(object sender, EventArgs e)
    {
                SqlConnection con = new SqlConnection(connectionString);
                con.Open();
                string query = "select * from Admin where userid='" + txtUser.Text + "'and password='" + txtPwd.Text + "'";
                SqlDataAdapter da = new SqlDataAdapter(query, con);
                DataTable dt = new DataTable();
                da.Fill(dt);
                con.Close();
                if (dt.Rows.Count > 0)
                {                  
                    Response.Redirect("CandidateDetails1.aspx");
                }
                else
                {
                    Response.Redirect("Login1.aspx");
                }
           
              
    }     
}