Updating SQL table.

Question

Hello, probally (hopefully) a simple question.

I use a C#application to put data in a SQL table, with a command string ( INSERT INTO value1, value2, etc) one off these values is a datestamp.
This works fine, but I need to the inserted data in the SQL table rightaway back in the application to avoid declaringing doublle data in de SQL table.

When INSERT command has been. looking in the SQL server Table, the insert data is not present, but when I at the server( management console) CHOOSE SHOW TOP 1000 the inserted data is there..

So what i,m looking for is; somehow to kick to the Server to do this select top 1000 query, after the Insert command, then I clould use a reader to reading the data in a array in my C# application.
 I looked for the update statement , but thats no clear for me. could it not getting to work.

thanks for answer.

groet.

Willie.