Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jan 13, 2012 01:59 PM by hans_v
Member
24 Points
26 Posts
Jan 13, 2012 05:27 AM|LINK
Dear All
Using various crosstabs I have created a metrix type query in MS Access in which I am using some external parameters also.
I wanted to create table adaptor for that query in my ASP.NET Project.
But while creating the adaptor I am not able to see that particular query in query builder in View tab.
If I remove all the parameters from query then I can see that query in Builder.
Please let me know if somebody has any idea about this.
Appreciate all your help.
Regards
Somnath
All-Star
35986 Points
6550 Posts
Jan 13, 2012 01:59 PM|LINK
As you've have noticed, the wizards in Visual Studio do not really support Access, especially when you use parameterized queries. But that doesn't mean it doesn't work, but sometimes you need to do things manually instead of using the wizards....
somnath.ting...
Member
24 Points
26 Posts
MS Access parameterised query not showing for Table Adaptor
Jan 13, 2012 05:27 AM|LINK
Dear All
Using various crosstabs I have created a metrix type query in MS Access in which I am using some external parameters also.
I wanted to create table adaptor for that query in my ASP.NET Project.
But while creating the adaptor I am not able to see that particular query in query builder in View tab.
If I remove all the parameters from query then I can see that query in Builder.
Please let me know if somebody has any idea about this.
Appreciate all your help.
Regards
Somnath
hans_v
All-Star
35986 Points
6550 Posts
Re: MS Access parameterised query not showing for Table Adaptor
Jan 13, 2012 01:59 PM|LINK
As you've have noticed, the wizards in Visual Studio do not really support Access, especially when you use parameterized queries. But that doesn't mean it doesn't work, but sometimes you need to do things manually instead of using the wizards....