which method to use so that last inserted value can be retrieve.
This is a discussion on which method to use so that last inserted value can be retrieve. within the Database Support forums, part of the Web Development category; Dear all, i am using asp.net ,C# (VS 2005) and sql server 2005. i have written sp for inserting ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
08-06-2007, 10:30 PM
| |||
| |||
 which method to use so that last inserted value can be retrieve. Dear all, i am using asp.net ,C# (VS 2005) and sql server 2005. i have written sp for inserting the the data which written last inserted idendity no. i would like to which method should i use(reader , nonexecutequery or executescalar ) so that i get that value and display the value in the form. Thnx     |
|
#2
08-06-2007, 11:13 PM
| |||
| |||
| Re: which method to use so that last inserted value can be retrieve. Use ExecuteScalar ....
__________________ S.VinothkumaR Behind me is infinite power, Before me is Endless Possibility, Around me is Boundless Opportunity, Why should I fear! |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Retrieve only the Nth row from a table? | santhakumar | Database Support | 6 | 11-14-2008 04:12 AM |
| How to Retrieve a Cookie Value? | sundarraja | PHP Programming | 4 | 04-02-2008 06:00 AM |
| Autoplay When USB is inserted using C# | Anandavinayagam | C# Programming | 3 | 10-03-2007 02:53 AM |
| How do I retrieve the values from the URL? | Pvinothkumar | HTML, CSS and Javascript Coding Techniques | 1 | 09-13-2007 05:30 AM |
| Get a inserted record field value in PHP-mySQL | venkat_charya | PHP Programming | 0 | 08-24-2007 08:52 AM |
All times are GMT -7. The time now is 05:17 AM.