Answer / vimal katiyar

daer Archana your answer is nt complete so this s complete query fr last inserted record fetch from table

select * from <tablename> where id=(select max(id) from <table name>)

Answer / raji22559

CommanObject.CommandText="Select @@Identity";

** Note: Over a given connection if any insert statement is
executed on a table with identity column , the back end
sql-server for the connection initializes a parameter by
name "@@Identity" with the value of Identity column for the
last inserted record.

Answer / skumar

We can use the query like
SELECT TOP 1 ID FROM table ORDER BY ID DESC

Answer / nitin kaushik

"select @@identity"
@@identity is used to get the current transaction value .

** Note: Over a given connection if any insert statement is
executed on a table with identity column , the back end
sql-server for the connection initializes a parameter by
name "@@Identity" with the value of Identity column for the
last inserted record.

Answer / jk

By using scope_identity

Answer / sudhakar sakthivel

select * from tableName where rowid = (select max(rowid)
from tableName);

in oracle

Answer / neha

Through this statement, we can retrieve the same:

ds.Tables[0].Rows[ds.Tables[0].Rows.Count-1]

Answer / muskaan

if(ds.Tables["tablename"].Rows.Count>0)
{
ds.Tables{"tablename"].Rows.Count-1;
}

Answer / shashi

we get data from this Query

ds.table[0].rows.count-1

Answer / archana

If a table have identity column then u can fetch the last
inserted record through following query:

"select max(ID) from test"

What is the difference between ADO and ADO.Net?

0 Answers  

Sequence to connect and retrieve data from database useig dataset ?

6 Answers   MMTS,

How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

0 Answers   CGI,

What are the steps you will take to improve performance? Will you use dataset or datareader?

0 Answers  

Name which operations can you not perform on an ado.net dataset?

0 Answers  

What is disconnected data?

0 Answers  

What are typed and untyped dataset?

0 Answers  

Which database is the ado.net?

0 Answers  

We all know that Dataset is purely disconnected architechure, but we also know that we can update the changes made to the dataset can be updated in the backend database. when there is no connection how does the update happedn?

6 Answers   Accenture, FastStream,

Why is it important to close an ado.net application?

0 Answers  

What is ADO .NET and what is difference between ADO and ADO.NET?

7 Answers   Ksb,

What are the pre-requisites for connection pooling?

0 Answers