How to display the last record from the database in c# ado .net

Question

0.00/5 (No votes)

See more:

Store procdure

if(@Activity = 'All')
select top 1 FullName,Email,Pasword,imgurl registration order by id desc
End

in UserDal

public List<user>All(ActivityMode a)
{
SqlConnection con = ConnectionDAL.SQL();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = &quot;Sp_User&quot;;
cmd.Parameters.AddWithValue(&quot;@activity&quot;, a.ToString());
List&lt;User&gt; lst = null;
con.Open();
using (con)
{
SqlDataReader DR = cmd.ExecuteReader();
if (DR.HasRows)
{
lst = new List&lt;User&gt;();
while (DR.Read())
{
User obj = new User();
obj.Id = Convert.ToInt32(DR[&quot;ID&quot;]);
obj.FullName = DR[&quot;FullName&quot;].ToString();
obj.Email = DR[&quot;Email&quot;].ToString();
obj.Password = DR[&quot;Password&quot;].ToString();
obj.Address = DR[&quot;Address&quot;].ToString();
obj.Imgurl = DR[&quot;Imgurl&quot;].ToString();
lst.Add(obj);
}
}
}
return lst;
}</pre></pre>
,

What I have tried:

i`m running the project the show the error..

how to resolve..
i am only disply last record..plz help me..

Server Error in '/' Application.

ID

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IndexOutOfRangeException: ID

Source Error:

Line 90: {
Line 91: User obj = new User();
Line 92: obj.Id = Convert.ToInt32(DR["ID"]);
Line 93: obj.FullName = DR["FullName"].ToString();
Line 94: obj.Email = DR["Email"].ToString();

Posted 9-Mar-16 15:51pm

Mehak Naaz

Updated 9-Mar-16 17:04pm

Add a Solution

Comments

[no name] 11-Mar-16 2:35am

Try changing your sp. as instructed by "AnvilRanger".

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)

AnvilRanger · Accepted Answer · 2016-03-09T17:04:00

Look at your stored procedure. You are not selecting the ID column.

Edit
That is not how it works around here. Code Project members will not do your work for you. We take our personal time to help people on this forum, and we are not paid for anything. We do this because we love development and what to help others with their development issues. I know nothing about your system, what you are trying to accomplish, expect for wanting the last record. You are best person to complete your task. If I were to do you work for you, what would you learn. Nothing. Even asking me to write a complete solution is very rude.

The solution to your problem is very simple. All you need to do is look at the error message and your code. You error message clearly tells you that you are trying to reference a item that does not exists, in this case ID. And you can see from your code that you are trying to set obj.Id = Convert.ToInt(DR["ID"]). That is where your error is coming from.

Now look at your stored procedure. In you select list,FullName,Email,Pasword,imgurl, you are selecting 4 items, but one of those is not ID.