i want to retrive latest update user detail in a label in my asp.net project,

Question

0.00/5 (No votes)

See more:

this is mine code..
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;

public partial class Default5 : System.Web.UI.Page
{
string strconn = ConfigurationManager.ConnectionStrings["touchconnectionstring7"].ConnectionString;

string conny;
SqlCommand cmd;

protected void Page_Load(object sender, EventArgs e)
{

SqlConnection con = new SqlConnection(strconn);
con.Open();
string conny = "select userid, FIRSTNAME, PASSWORD, EMAILID FROM registration WHERE userid= max(userid);
cmd = new SqlCommand(conny, con);
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
Label1.Text = dr["FIRSTNAME"].ToString();
dr.Read();
Label2.Text = dr["PASSWORD"].ToString();
dr.Read();
Label3.Text = dr["EMAILID"].ToString();
dr.Read();
dr.Close();
con.Close();

}

}

this code is not working guys help me its urgent.

Posted 16-Nov-14 23:00pm

Member 10874581

Add a Solution

Comments

Kiran Wilson 17-Nov-14 5:08am

what is the error you are getting?

Member 10874581 17-Nov-14 5:20am

data is not dislpaying to my labels

Member 10874581 17-Nov-14 5:22am

and this error is also coming...An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.

Kiran Wilson 17-Nov-14 5:47am

Please check this

http://www.sql-server-helper.com/error-messages/msg-147.aspx

This will help you..

Member 10874581 17-Nov-14 6:04am

I am trying this code bt also giving error execute reader : connection property string not intitilized

Member 10874581 17-Nov-14 6:05am

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;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ string constr = System.Configuration.ConfigurationManager.ConnectionStrings["touchConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
SqlDataAdapter adp = new SqlDataAdapter();

SqlCommand cmd = new SqlCommand( " select userid , FIRSTNAME from register where userid = select( Max(userid) from register)");
con.Open();
SqlDataReader dr = cmd.ExecuteReader();

while( dr.Read())
{
Label1.Text = dr["userid"].ToString();
Label2.Text = dr["FIRSTNAME"].ToString();

}

con.Close();
}

}

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mathew Soji · Answer 1 · 2014-11-16T23:11:00

Solution 1

You need to use a while loop or for each loop to fetch the row data;

Change the code as below and try.

C#

while (dr.Read())
            {
                Label1.Text = dr["FIRSTNAME"].ToString();
                Label2.Text = dr["PASSWORD"].ToString();
                Label3.Text = dr["EMAILID"].ToString();
            }

Check below for an msdn sample on using DataReader.

http://msdn.microsoft.com/en-us/library/haa3afyz%28v=vs.110%29.aspx[^]

Posted 16-Nov-14 23:11pm

Mathew Soji

Updated 16-Nov-14 23:12pm

v3

Comments

Member 10874581 17-Nov-14 6:03am

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;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ string constr = System.Configuration.ConfigurationManager.ConnectionStrings["touchConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
SqlDataAdapter adp = new SqlDataAdapter();

SqlCommand cmd = new SqlCommand( " select userid , FIRSTNAME from register where userid = select( Max(userid) from register)");
con.Open();
SqlDataReader dr = cmd.ExecuteReader();

while( dr.Read())
{
Label1.Text = dr["userid"].ToString();
Label2.Text = dr["FIRSTNAME"].ToString();

}

con.Close();
}

}
giving error connecction execute reader: connection property not initilized what is this?

Mathew Soji 17-Nov-14 6:10am

You have not assigned connection for the command object.

con.Open();
cmd.Connection = con; //add this line once connection is opened.
SqlDataReader dr = cmd.ExecuteReader();

while( dr.Read())
{
Label1.Text = dr["userid"].ToString();
Label2.Text = dr["FIRSTNAME"].ToString();

}