Click here to Skip to main content
15,888,984 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: A new introduction video Pin
LloydA11115-Apr-10 14:44
LloydA11115-Apr-10 14:44 
Questiondisable users mailbox account from exchange server 2007 using vb.net Pin
myms.net15-Apr-10 2:48
myms.net15-Apr-10 2:48 
AnswerRe: disable users mailbox account from exchange server 2007 using vb.net Pin
Michel Godfroid15-Apr-10 7:36
Michel Godfroid15-Apr-10 7:36 
QuestionSELECT & COMPARE database column entries ! Pin
jeshra27915-Apr-10 1:06
jeshra27915-Apr-10 1:06 
AnswerRe: SELECT & COMPARE database column entries ! Pin
Simon_Whale15-Apr-10 1:10
Simon_Whale15-Apr-10 1:10 
AnswerRe: SELECT & COMPARE database column entries ! Pin
Michel Godfroid15-Apr-10 1:11
Michel Godfroid15-Apr-10 1:11 
AnswerRe: SELECT & COMPARE database column entries ! Pin
Kschuler15-Apr-10 7:51
Kschuler15-Apr-10 7:51 
QuestionAdvice: stored procedure parameters, lists of sqlparameters or using sqlparametercollections Pin
Simon_Whale15-Apr-10 0:19
Simon_Whale15-Apr-10 0:19 
Need some advice on which would be better!

1. creating a function that take a list(of sqlparameters)

<br />
  Dim ParamList As New List(Of SqlParameter)<br />
<br />
  Dim param As New SqlParameter("@SectionNo", SqlDbType.Int)<br />
  param.Value = SectionNo<br />
<br />
  ParamList.Add(param)<br />


or

2. Creating a data dictionary storing parameter name, type and value and then building up a sqlparametercollection e.g.

<br />
  dim pc as sqlparametercollection<br />
  pc = da.selectcommand.parameters<br />
  for each entry in the datadictionary<br />
    pc.add(paramName, Type, value)<br />
  next<br />


reason for asking i need to created a stored proc that could have upto 100 parameters and am looking for speed and re-useability.

Many Thanks for your help and hope it makes sense
Simon
AnswerRe: Advice: stored procedure parameters, lists of sqlparameters or using sqlparametercollections Pin
Dave Kreskowiak15-Apr-10 6:40
mveDave Kreskowiak15-Apr-10 6:40 
GeneralRe: Advice: stored procedure parameters, lists of sqlparameters or using sqlparametercollections Pin
Ray Cassick15-Apr-10 8:38
Ray Cassick15-Apr-10 8:38 
GeneralRe: Advice: stored procedure parameters, lists of sqlparameters or using sqlparametercollections Pin
Simon_Whale15-Apr-10 11:55
Simon_Whale15-Apr-10 11:55 
GeneralRe: Advice: stored procedure parameters, lists of sqlparameters or using sqlparametercollections Pin
Dave Kreskowiak15-Apr-10 12:31
mveDave Kreskowiak15-Apr-10 12:31 
JokeRe: Advice: stored procedure parameters, lists of sqlparameters or using sqlparametercollections Pin
Luc Pattyn15-Apr-10 6:57
sitebuilderLuc Pattyn15-Apr-10 6:57 
QuestionHow to make text go away after a few seconds? Pin
Adam Wike14-Apr-10 4:05
Adam Wike14-Apr-10 4:05 
AnswerRe: How to make text go away after a few seconds? PinPopular
Steven J Jowett14-Apr-10 4:10
Steven J Jowett14-Apr-10 4:10 
GeneralRe: How to make text go away after a few seconds? Pin
Adam Wike14-Apr-10 4:11
Adam Wike14-Apr-10 4:11 
GeneralRe: How to make text go away after a few seconds? Pin
Dalek Dave14-Apr-10 8:35
professionalDalek Dave14-Apr-10 8:35 
AnswerRe: How to make text go away after a few seconds? Pin
William Winner14-Apr-10 8:28
William Winner14-Apr-10 8:28 
QuestionSplitting a .txt file and sorting it Pin
offroaderdan14-Apr-10 3:11
offroaderdan14-Apr-10 3:11 
AnswerRe: Splitting a .txt file and sorting it Pin
tosch14-Apr-10 3:42
tosch14-Apr-10 3:42 
GeneralRe: Splitting a .txt file and sorting it [modified] Pin
offroaderdan14-Apr-10 3:48
offroaderdan14-Apr-10 3:48 
GeneralRe: Splitting a .txt file and sorting it Pin
tosch14-Apr-10 4:15
tosch14-Apr-10 4:15 
GeneralRe: Splitting a .txt file and sorting it [modified] Pin
offroaderdan14-Apr-10 4:38
offroaderdan14-Apr-10 4:38 
GeneralRe: Splitting a .txt file and sorting it Pin
tosch14-Apr-10 4:48
tosch14-Apr-10 4:48 
AnswerRe: Splitting a .txt file and sorting it [modified] Pin
Ian Shlasko14-Apr-10 5:50
Ian Shlasko14-Apr-10 5:50 

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.