how to fetch latest updated coloum values from database to label in asp.net

Question

1.00/5 (2 votes)

See more:

C#

ASP.NET

guys please help me its urgent kindly send me code for this.

Posted 30-Sep-14 0:14am

Member 10874581

Add a Solution

Comments

ChintanShukla 30-Sep-14 6:20am

What kind of urgency? did you try? Please provide your code.

Member 10874581 30-Sep-14 6:49am

ok i will provide

Member 10874581 30-Sep-14 6:54am

ublic partial class _Default : System.Web.UI.Page
{
string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
string str;
SqlCommand com;

protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(strConnString);
con.Open();
str = "select * from emp";
com = new SqlCommand(str, con);
SqlDataReader reader = com.ExecuteReader();
reader.Read();
labelname1.Text = reader["Name"].ToString();
reader.Read();
labelname2.Text = reader["Name"].ToString();
reader.Read();
labelname3.Text = reader["Name"].ToString();
reader.Close();
con.Close();
con.Open();
SqlDataReader reader1 = com.ExecuteReader();
reader1.Read();
labelage1.Text = reader1["Age"].ToString();
reader1.Read();
labelage2.Text = reader1["Age"].ToString();
reader1.Read();
labelage3.Text = reader1["Age"].ToString();
reader.Close();
con.Close();
}
}
}
i amusing this code this is fetching only first row from table i want to fetch the latest value from table which has been inserted please help me

Shemeemsha (ഷെമീംഷ) 30-Sep-14 6:46am

Give more details about your question.... Are you using LINQ ?

Member 10874581 30-Sep-14 6:48am

i am using sql 2008 bt the code i am using fetching only first row.

Sinisa Hajnal 30-Sep-14 6:52am

Do not ask for finished code! Ask the question, describe what YOU TRIED before asking here...do some research. It is urgent to you only. My vote of 1.

Member 10874581 30-Sep-14 6:55am

ublic partial class _Default : System.Web.UI.Page
{
string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
string str;
SqlCommand com;

protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(strConnString);
con.Open();
str = "select * from emp";
com = new SqlCommand(str, con);
SqlDataReader reader = com.ExecuteReader();
reader.Read();
labelname1.Text = reader["Name"].ToString();
reader.Read();
labelname2.Text = reader["Name"].ToString();
reader.Read();
labelname3.Text = reader["Name"].ToString();
reader.Close();
con.Close();
con.Open();
SqlDataReader reader1 = com.ExecuteReader();
reader1.Read();
labelage1.Text = reader1["Age"].ToString();
reader1.Read();
labelage2.Text = reader1["Age"].ToString();
reader1.Read();
labelage3.Text = reader1["Age"].ToString();
reader.Close();
con.Close();
}
}
}
i have tried this code bt it is only fetching the first row from table bt i want to fetch latest row in the label please help..

JR009 30-Sep-14 7:15am

what is your database table fields? Is your sql query is right?

Member 10874581 30-Sep-14 7:45am

databse fields firstname, secondname, phonenumber, address , email , password, query .i have to show password and username of user after submitting data tonext page on label

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)

ChintanShukla · Accepted Answer · 2014-09-30T01:17:00

Solution 1

If You have Primary key then Change your query, instead of

SQL

select * from emp

do

SQL

select * from emp where iD = (select MAX(iD) from emp)

Assuming that iD is your primary key and keeps on increasing after every insert.

Posted 30-Sep-14 1:17am

ChintanShukla

v2

Comments

Member 10874581 30-Sep-14 7:21am

mine code is correct or not..