Click here to Skip to main content
15,903,854 members
Home / Discussions / C#
   

C#

 
AnswerRe: how can i save this? Pin
Mazdak17-Jan-04 0:29
Mazdak17-Jan-04 0:29 
AnswerRe: how can i save this? Pin
Corinna John17-Jan-04 6:34
Corinna John17-Jan-04 6:34 
GeneralWindows Application Screen Resolution problem Pin
koosala16-Jan-04 18:13
koosala16-Jan-04 18:13 
GeneralRe: Windows Application Screen Resolution problem Pin
Mazdak16-Jan-04 19:27
Mazdak16-Jan-04 19:27 
GeneralRe: Windows Application Screen Resolution problem Pin
Heath Stewart16-Jan-04 19:40
protectorHeath Stewart16-Jan-04 19:40 
GeneralRe: Windows Application Screen Resolution problem Pin
leppie17-Jan-04 7:05
leppie17-Jan-04 7:05 
GeneralRe: Windows Application Screen Resolution problem Pin
je_gonzalez17-Jan-04 8:40
je_gonzalez17-Jan-04 8:40 
GeneralRe: Windows Application Screen Resolution problem Pin
leppie17-Jan-04 9:26
leppie17-Jan-04 9:26 
GeneralRe: Windows Application Screen Resolution problem Pin
je_gonzalez17-Jan-04 9:33
je_gonzalez17-Jan-04 9:33 
QuestionWho can help me about this question? Pin
Feelyn200816-Jan-04 15:24
Feelyn200816-Jan-04 15:24 
AnswerRe: Who can help me about this question? Pin
Colin Angus Mackay16-Jan-04 15:53
Colin Angus Mackay16-Jan-04 15:53 
GeneralRe: Who can help me about this question? Pin
je_gonzalez16-Jan-04 17:02
je_gonzalez16-Jan-04 17:02 
GeneralRe: Who can help me about this question? Pin
Forrest Feather17-Jan-04 9:43
Forrest Feather17-Jan-04 9:43 
AnswerRe: Who can help me about this question? Pin
je_gonzalez16-Jan-04 17:18
je_gonzalez16-Jan-04 17:18 
GeneralRe: Who can help me about this question? Pin
Daniel Turini17-Jan-04 5:03
Daniel Turini17-Jan-04 5:03 
GeneralRe: Who can help me about this question? Pin
je_gonzalez17-Jan-04 8:57
je_gonzalez17-Jan-04 8:57 
GeneralDatagrid and c# Pin
caheo16-Jan-04 14:08
caheo16-Jan-04 14:08 
GeneralRe: Datagrid and c# Pin
Heath Stewart16-Jan-04 19:29
protectorHeath Stewart16-Jan-04 19:29 
QuestionEditboxes show unknown chars as ?? Pin
Anonymous16-Jan-04 14:02
Anonymous16-Jan-04 14:02 
AnswerRe: Editboxes show unknown chars as ?? Pin
LiquidKnight16-Jan-04 14:06
LiquidKnight16-Jan-04 14:06 
AnswerRe: Editboxes show unknown chars as ?? Pin
Heath Stewart16-Jan-04 19:22
protectorHeath Stewart16-Jan-04 19:22 
GeneralGive name to table from stored procedure Pin
laphijia16-Jan-04 8:29
laphijia16-Jan-04 8:29 
I've built a fairly complex stored procedure that has a couple of selects in it that are only functional while I'm only interested in reading the resultset from the last select.

Now when I fill my dataset, apart from retrieving useless data from the database, I have to acess my data doing something like ds.Tables[2].Rows

I have thought of two possible solutions even though I don't know how to implement any of them.

1. Have the stored procedure return only the last recordset. If this is possible I'm missing some T-SQL command. Anybody on this?

2. Give a name to the table that I'm interested in reading so that I could access it disregarding it's index like ds.Tables["MyRecordset"].Rows
This is much more elegant than accessing with numeric index bacause if I change the stored procedure I don't have to change my code.
Anyway how does one give a name to a table from a stored procedure?

Thanks

Edd
GeneralRe: Give name to table from stored procedure Pin
Rocky Moore16-Jan-04 8:44
Rocky Moore16-Jan-04 8:44 
GeneralRe: Give name to table from stored procedure Pin
Guillermo Rivero16-Jan-04 12:51
Guillermo Rivero16-Jan-04 12:51 
GeneralRe: Give name to table from stored procedure Pin
Heath Stewart16-Jan-04 19:18
protectorHeath Stewart16-Jan-04 19:18 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.