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

narasiman rao

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)

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

nallya13y ago
Accepted answer
try to use this at page_loaad:

int id=convert.toint32(Session["Loginid"]);
con.Open();
SqlCommand cmd = new SqlCommand("select Firstname,Lastname from login where Loginid = '" + id + " ' ",con);
cmd.executenonquery();
0
nallya13y ago
if entry table contains the column "Loginid" then it will works
try to use this at page_loaad:

int id=convert.toint32(Session["Loginid"]);
con.Open();
SqlCommand cmd = new SqlCommand("select Firstname,Lastname from entry where Loginid = '" + id + " ' ",con);
cmd.executenonquery();
0

narasiman rao13y ago

i try your code as follows

int id = Convert.ToInt32(Session["Loginid"]);

con.Open();

SqlCommand cmd = new SqlCommand("select Firstname,Lastnmae from entry where Loginid = '" + id + " ' ", con);

cmd.ExecuteNonQuery();

but in next page in page load value is not retrieving from the login page.

in the next page

Firstname  
Lastname 


Firstname and lastname as empty in the pageloag(  next page)

output as empty

but the output  i want as follows

Firstname ram (this ram is retrieving from the loginpage table name entry)
Lastname sam (this sam is retrieving from the loginpage table name entry)

Satyapriya Nayak13y ago
If the above post helps you mark it as answer
0