in the home page, login page value to be retrieved from the database

Question

first i create a table login and fields as follows;
table name login
Loginid,Firstname,Lastname,Password and Lastlogin.
1 ram sam 123 8/12/2012 11:30
then i create loginpage design as follows;
 
username txtusername.text
 
Password txtpassword.text
 
in that run page when i type 1 in username and 123 in password and click the button it shows the message validloginid and password. and when i type some value in username and password it shows loginid and password does not match.
 
it is working.
 
for that code has follows;

using System;
using System.Data;
using System.Configuration;
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.Drawing;
using System.Data.SqlClient;
 
public partial class _Default : System.Web.UI.Page 
{
    SqlConnection con = new SqlConnection("Data Source=MOORTHY;Initial Catalog=master;Integrated Security=True ");
    protected void Page_Load(object sender, EventArgs e)
    {
              
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        con.Open();
        SqlCommand cmd = new SqlCommand("select Loginid,Password from entry where Loginid = '" + txt_username.Text + " ' and Password = '" + txt_password.Text + "'",con);
        SqlDataReader dr = cmd.ExecuteReader();
        if(dr.HasRows)
        {
            Session["Loginid"] = txt_username.Text ;
            dr.Close();
            con.Close();
            Label3.Text = "Valid Login ID  and Password";
            Label3.ForeColor = System.Drawing.Color.DarkGreen;
            //Server.Transfer("default2.aspx");
        }
        else
        {
            Label3.Text = "Login ID  Does Not Match";
            Label3.ForeColor = System.Drawing.Color.DarkOrange;
 
        }
 
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        txt_username.Text = "";
        txt_password.Text = "";
        Label3.Text = "";
    }
}

then i design the next page design as follows;
 
Firstname textbox1
Lastname textbox2
 
when i click the login page it goes to next page in that page 
 
Firstname ram (value from the login table to be retrieve)
Lastname sam (value from the login table to be retrieve)