Iam Having three dropdown lists named Department,StaffID,StaffType,textbox Name and one submit button...If I select Department as BEMechanical and click the button i have to get all the details regarding that branch and if i select Department,StaffID,stafftype and name i should get the details of the selected one.Any one plz help me..i want this in C# Web Application
neetika reddy
-1
Newbie Poster
Recommended Answers
Jump to PostUse nullable search parameters in your sql query:
declare @id int = 1 declare @Name nvarchar(20) = null SELECT * FROM Products WHERE (@id is null OR Products.ProductID = @id) AND (@Name is null OR Products.Name = @Name
By making the search terms nullable and checking for …
Jump to PostThe code is available in the original post here. Which is precisely why we the forum rules state NOT to post duplicate questions. The answers get spread out and it makes it difficult and confusing for the solvers to help you and other forum readers to learn from :(
Jump to PostHi Kayfar, please avoid asking questions in existing threads unless they directly relate to the thread matter.
If you ened help with a MS Access connection, post a new thread. It keeps related code together and ensures you get help from those who can best answer your problem :)
All 12 Replies
Geekitygeek
480
Nearly a Posting Virtuoso
neetika reddy
-1
Newbie Poster
Geekitygeek
480
Nearly a Posting Virtuoso
Geekitygeek
480
Nearly a Posting Virtuoso
neetika reddy
-1
Newbie Poster
Geekitygeek
480
Nearly a Posting Virtuoso
kayfar
0
Junior Poster in Training
Geekitygeek
480
Nearly a Posting Virtuoso
kayfar
0
Junior Poster in Training
Geekitygeek
480
Nearly a Posting Virtuoso
neetika reddy
-1
Newbie Poster
Geekitygeek
480
Nearly a Posting Virtuoso
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.