Good point, but I'm sure that's absolutely not necessary, a simple test will convince you that this is not true! The reason can be found in the same MSDN article:
"The AccessDataSource control inherits the SqlDataSource class and replaces the ConnectionString property with a DataFile property to make it more convenient to connect to a Microsoft Access database"
So if named parameters cannot be used, they could not be used with as SqlDataSource either! The only difference in OleDb between named parameters and ? is that every ? is threaded as a different parameter, and named parameters that are used multiple times
are threaded as 1
hans_v
All-Star
35986 Points
6550 Posts
Re: Submitting session parameters into a select command on a asp.datasource
Jun 12, 2009 02:34 AM|LINK
Good point, but I'm sure that's absolutely not necessary, a simple test will convince you that this is not true! The reason can be found in the same MSDN article:
"The AccessDataSource control inherits the SqlDataSource class and replaces the ConnectionString property with a DataFile property to make it more convenient to connect to a Microsoft Access database"
So if named parameters cannot be used, they could not be used with as SqlDataSource either! The only difference in OleDb between named parameters and ? is that every ? is threaded as a different parameter, and named parameters that are used multiple times are threaded as 1