question about CommandType TableDirect

[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

 

[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.