Click here to Skip to main content
15,908,581 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionTime Trial software Pin
lindamaccarthy20-Apr-06 3:18
lindamaccarthy20-Apr-06 3:18 
AnswerRe: Time Trial software Pin
Eric Dahlvang20-Apr-06 4:03
Eric Dahlvang20-Apr-06 4:03 
QuestionActive Directory Pin
_tasleem20-Apr-06 3:02
_tasleem20-Apr-06 3:02 
AnswerRe: Active Directory Pin
MohammadAmiry20-Apr-06 7:10
MohammadAmiry20-Apr-06 7:10 
QuestionRTF controll for mobile applications Pin
_tasleem20-Apr-06 2:58
_tasleem20-Apr-06 2:58 
AnswerRe: Problem with code access Security Pin
J4amieC20-Apr-06 1:53
J4amieC20-Apr-06 1:53 
Questionvb.net class Pin
Mohammad Daba'an19-Apr-06 21:00
Mohammad Daba'an19-Apr-06 21:00 
AnswerRe: vb.net class Pin
MatthysDT20-Apr-06 0:43
MatthysDT20-Apr-06 0:43 
I'm not sure how to do it with your approach but i did it by returning a table with a SQL UDF.
I don't think this approach is too friendly on the overhead, wont advise doing it with large amounts of data.


CREATE	FUNCTION udfReturnMyData(<br />
	@MyArg1 varchar(30),<br />
	@MyArg2 int)<br />
<br />
RETURNS @v TABLE (Column1 int, Column2 int, Column3 Varchar(10))<br />
AS<br />
BEGIN<br />
	<br />
	insert into @v (column1, column2, column3)<br />
	(SELECT	Column1, Column2, Column3 From MyTable Where MyCondition = True)<br />
<br />
	return<br />
END


I call this function from VB by doing a simple SELECT * FROM udfReturnMyData(MyArg1, MyArg2)
Hope it helps.



you can't forget something you never knew...
Questionhow to print a file from VB 6.0 Pin
himuskanhere19-Apr-06 19:30
himuskanhere19-Apr-06 19:30 
AnswerRe: how to print a file from VB 6.0 Pin
MohammadAmiry20-Apr-06 7:36
MohammadAmiry20-Apr-06 7:36 
QuestionSearching Directories/Folders Pin
cowtech19-Apr-06 19:06
cowtech19-Apr-06 19:06 
AnswerRe: Searching Directories/Folders Pin
Chatura Dilan19-Apr-06 21:46
Chatura Dilan19-Apr-06 21:46 
GeneralRe: Searching Directories/Folders Pin
cowtech20-Apr-06 13:06
cowtech20-Apr-06 13:06 
Questionvariable value accessing problem Pin
Amit Agarrwal19-Apr-06 19:03
Amit Agarrwal19-Apr-06 19:03 
AnswerRe: variable value accessing problem Pin
Dave Kreskowiak20-Apr-06 3:56
mveDave Kreskowiak20-Apr-06 3:56 
AnswerRe: variable value accessing problem Pin
Rob Graham20-Apr-06 11:09
Rob Graham20-Apr-06 11:09 
QuestionASP COmponent in visual basic .net Pin
Budii19-Apr-06 19:03
Budii19-Apr-06 19:03 
Questionstring & math function in VB Pin
Mridang Agarwalla19-Apr-06 18:04
Mridang Agarwalla19-Apr-06 18:04 
AnswerRe: string & math function in VB Pin
sathish s19-Apr-06 20:32
sathish s19-Apr-06 20:32 
QuestionHelp About VB.Net DLL Pin
ALQallaf19-Apr-06 14:04
ALQallaf19-Apr-06 14:04 
AnswerRe: Help About VB.Net DLL Pin
Christian Graus19-Apr-06 14:19
protectorChristian Graus19-Apr-06 14:19 
GeneralRe: Help About VB.Net DLL Pin
ALQallaf20-Apr-06 6:56
ALQallaf20-Apr-06 6:56 
Questionerror after application installation Pin
wiseyuss19-Apr-06 13:48
wiseyuss19-Apr-06 13:48 
AnswerRe: error after application installation Pin
mr_1234519-Apr-06 15:32
mr_1234519-Apr-06 15:32 
GeneralRe: error after application installation Pin
wiseyuss19-Apr-06 16:02
wiseyuss19-Apr-06 16:02 

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.