Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jaimin
Starting Member
21 Posts |
 Posted - 2007-05-30 : 11:30:19
|
| i am having a stored procedure and i want to use dataset to retrieve the first row of my table. |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-05-30 : 12:41:06
|
| Post your stored proc code, some sample data, and your expected result. As it stands, your question isn't very clear.Mark |
 |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2007-05-31 : 23:42:31
|
| I would use the sqldata reader rather then filling a dataset. Just read the first record to your table, then close out the connection. |
|
|
|
mahesh_bote
Constraint Violating Yak Guru
298 Posts |
Posted - 2007-06-07 : 07:12:10
|
quote:
Originally posted by Vinnie881
I would use the sqldata reader rather then filling a dataset. Just read the first record to your table, then close out the connection.
I will suggest to use Dataset even in this case. using Dataset better option over other objects. Fill the dataset with resultset and get any record anywhere. May it 1st or last or even any records.Mahesh |
|
|
|
|
|
|
how to use dataset?