TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Sel Soft
NA
1
1.1k
Query building methods based on mulitple parameter
Jun 14 2013 9:51 AM
Hi all,
What is the best way to build a query (that depends on multiple parameters) for the purposes of updating a DataGridView from a database table.
Is creating query strings based on all the combination an efficient way of doing it?
(i.e. query strings for all combinations like [a,x,1],[a,b,x,1],[a,c,x,1]....)
---------------------------------------------
Parameter_1 Parameter_2 Parameter_3
option_a option_x option_1
option_b option_y option_2
option_c option_z
option_d
---------------------------------------------
Parameter_1
Parameter_2
Parameter_3
Reply
Answers (
1
)
I want search engine who compitible with sql server
PIVOT - Non Aggregate