question about CommandType TableDirect

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hi,

this code is for stored procdure:
comd = New SqlCommand()
comd.Connection = connection
comd.CommandText = "mysp"
comd.CommandType = CommandType.StoredProcedure

My question: i also saw when choosing the comd.CommandType in VWD:
"TableDirect". What's the purpose of this and how to use it?

thanks
Chris
 
i found it:
CommandType.TableDirect: Should be used when you want all records from a
table returned. You would specify only the name of the table as the command.
This type can only be used with the OLEDB command object, OleDbCommand.
 
Back
Top