Click here to Skip to main content
14,691,601 members
Home » Discussions » Design and Architecture
   

Design and Architecture

 
QuestionMultiple resource files per culture Pin
agolddog1-Oct-19 10:43
Memberagolddog1-Oct-19 10:43 
AnswerRe: Multiple resource files per culture Pin
Gerry Schmitz1-Oct-19 11:36
mveGerry Schmitz1-Oct-19 11:36 
AnswerRe: Multiple resource files per culture Pin
Eddy Vluggen1-Oct-19 15:59
professionalEddy Vluggen1-Oct-19 15:59 
AnswerRe: Multiple resource files per culture Pin
Leon Swift21-Nov-19 2:40
MemberLeon Swift21-Nov-19 2:40 
QuestionLoading Dropdown Pin
chennaiprince13-Jul-19 4:18
Memberchennaiprince13-Jul-19 4:18 
AnswerRe: Loading Dropdown Pin
Gerry Schmitz13-Jul-19 9:23
mveGerry Schmitz13-Jul-19 9:23 
AnswerRe: Loading Dropdown Pin
Mycroft Holmes13-Jul-19 12:06
professionalMycroft Holmes13-Jul-19 12:06 
AnswerRe: Loading Dropdown Pin
C. David Johnson13-Sep-19 8:58
MemberC. David Johnson13-Sep-19 8:58 
Can it be done YES, is it appropriate probably not.

First I STRONGLY suggest you NOT use select * its really a lazy way to do things
Second if your going do do it you have to return a DataSet not a DataTable in your ADO Call
Then your proc would look like this

Create procedure dbo.myproc_GetParameters as

Select id,name from Customer
Select id,name from products
Select id,name from cities


Then set.Tables[0] will be customers set.Tables[1] will be products...

This is a LOT of data to pull at once and poor performance...

Your MUCH better off to pull them individually in separate calls
GeneralRe: Loading Dropdown Pin
Eddy Vluggen13-Sep-19 9:02
professionalEddy Vluggen13-Sep-19 9:02 
QuestionHow to get applicable OOP / software structure knowledge Pin
qkhanhpro1-Jul-19 22:34
Memberqkhanhpro1-Jul-19 22:34 
AnswerRe: How to get applicable OOP / software structure knowledge Pin
OriginalGriff1-Jul-19 22:46
mveOriginalGriff1-Jul-19 22:46 
AnswerRe: How to get applicable OOP / software structure knowledge Pin
Gerry Schmitz2-Jul-19 7:41
mveGerry Schmitz2-Jul-19 7:41 
AnswerRe: How to get applicable OOP / software structure knowledge Pin
Benktesh Sharma7-Aug-19 19:55
MemberBenktesh Sharma7-Aug-19 19:55 
QuestionDesign an algorithm for generic database analytics Pin
Michael Sterling30-May-19 0:18
MemberMichael Sterling30-May-19 0:18 
AnswerRe: Design an algorithm for generic database analytics Pin
Eddy Vluggen30-May-19 1:04
professionalEddy Vluggen30-May-19 1:04 
GeneralRe: Design an algorithm for generic database analytics Pin
Michael Sterling30-May-19 2:42
MemberMichael Sterling30-May-19 2:42 
PraiseRe: Design an algorithm for generic database analytics Pin
Eddy Vluggen30-May-19 3:32
professionalEddy Vluggen30-May-19 3:32 
AnswerRe: Design an algorithm for generic database analytics Pin
Mycroft Holmes30-May-19 13:22
professionalMycroft Holmes30-May-19 13:22 
GeneralRe: Design an algorithm for generic database analytics Pin
Michael Sterling1-Jun-19 3:17
MemberMichael Sterling1-Jun-19 3:17 
GeneralRe: Design an algorithm for generic database analytics Pin
Mycroft Holmes1-Jun-19 14:43
professionalMycroft Holmes1-Jun-19 14:43 
AnswerRe: Design an algorithm for generic database analytics Pin
Gerry Schmitz30-May-19 15:11
mveGerry Schmitz30-May-19 15:11 
QuestionWhat is an image map? Pin
Shraddha_Patel26-May-19 21:36
MemberShraddha_Patel26-May-19 21:36 
AnswerRe: What is an image map? Pin
Richard MacCutchan26-May-19 22:26
mveRichard MacCutchan26-May-19 22:26 
AnswerRe: What is an image map? Pin
Eddy Vluggen27-May-19 0:48
professionalEddy Vluggen27-May-19 0:48 
AnswerMessage Closed Pin
13-Dec-19 2:43
MemberMember 1468847913-Dec-19 2:43 

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.