Click here to Skip to main content
15,886,110 members
Home / Discussions / C#
   

C#

 
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 
GeneralLearned something new.. Pin
Rocky Moore16-Jan-04 8:14
Rocky Moore16-Jan-04 8:14 
GeneralRe: Learned something new.. Pin
Mazdak16-Jan-04 8:22
Mazdak16-Jan-04 8:22 
GeneralRe: Learned something new.. Pin
leppie16-Jan-04 9:01
leppie16-Jan-04 9:01 
QuestionHow to test Microphone, Pin
Shahin7716-Jan-04 6:57
Shahin7716-Jan-04 6:57 
AnswerRe: How to test Microphone, Pin
Hauptman(n)16-Jan-04 7:25
Hauptman(n)16-Jan-04 7:25 
GeneralRe: How to test Microphone, Pin
eggie516-Jan-04 11:39
eggie516-Jan-04 11:39 
GeneralRe: How to test Microphone, Pin
Guillermo Rivero16-Jan-04 12:09
Guillermo Rivero16-Jan-04 12:09 
GeneralRe: How to test Microphone, Pin
Hauptman(n)17-Jan-04 0:47
Hauptman(n)17-Jan-04 0:47 
Generalseting focus on a control Pin
elena1234516-Jan-04 6:54
elena1234516-Jan-04 6:54 
GeneralRe: seting focus on a control Pin
Heath Stewart16-Jan-04 7:11
protectorHeath Stewart16-Jan-04 7:11 
Question.NET Bug or bad code ? Pin
Guinness4Strength16-Jan-04 5:11
Guinness4Strength16-Jan-04 5:11 
AnswerRe: .NET Bug or bad code ? Pin
Daniel Turini16-Jan-04 5:20
Daniel Turini16-Jan-04 5:20 
GeneralRe: .NET Bug or bad code ? Pin
Guinness4Strength16-Jan-04 5:29
Guinness4Strength16-Jan-04 5:29 
GeneralRe: .NET Bug or bad code ? Pin
Heath Stewart16-Jan-04 5:42
protectorHeath Stewart16-Jan-04 5:42 

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.