Gridview not displaying records depend on drop down selection

Question

0.00/5 (No votes)

See more:

How to skip a grid column on drop down select index..

if i select all it should display all Records , if i select list item depend on selection in drop down it should display grid skipping one column..I have taken a stored procedure if else block in else i have skipped a column and wrote stored procedure but that gives error seems i have to do it in another way..

How to skip a column in grid depending on drop down selection.??

help ??

suggestions??

What I have tried:

Stored procedure i have written if else statement skipping one column in else statement that gives column not found error.. how to do it..

Posted 3-Mar-17 2:29am

Mahesh2223

Updated 3-Mar-17 22:22pm

v6

Add a Solution

Comments

Mahesh2223 3-Mar-17 8:30am

Cannot find what is wrong but grid is not displaying records on drop down selection

Jochen Arndt 3-Mar-17 8:45am

Does your database contain recordsets where B.GroupCode == "GroupCode"?

Because that is what you are actually looking for according to the posted code snippets.

Mahesh2223 3-Mar-17 9:32am

Yes It contains Records

Mahesh2223 3-Mar-17 9:34am

My doubt is Stored Procedure Comparing with if please tell me whether the stored procedure is correct or not

Dave Kreskowiak 3-Mar-17 8:48am

Looking at your code the problem isn't with the grid but with your database query. The grid is displaying everything your query is returning. Your first step is to figure out if the query works as expected and very it's returning everything you're expecting.

Mahesh2223 3-Mar-17 9:32am

Yes i checked in the database its returning records but in gridview its not displayng records

Dave Kreskowiak 3-Mar-17 17:24pm

You apparently are not checking the result of the query in your code. That's what the debugger is for.

You checked an arbitrary query in the database tool, not your code. As you've no doubt found out already, they are NOT the same.

Mahesh2223 4-Mar-17 2:19am

How do i skip one grid column on drop down selection

Bryian Tan 3-Mar-17 10:18am

The else should throw the error on the UI "A field or property with the name 'GroupName' was not found on the selected data source." because GroupName is not part of the query but the grid is looking for it. The query should be

SELECT B.GroupName, B.DoctorLastName ....

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Answer 1 · 2017-03-03T04:07:00

Solution 1

In Search_Click you are calling

C#

BindGrid("GroupCode");

which means you are passing the value "GroupCode" to your stored procedure.

That forces the following query to run:

SQL

SELECT B.DoctorLastName + ', ' + B.DoctorFirstName AS DoctorName
    ,C.UpperLimit
    ,C.DownLimit
    ,C.isKMC
    ,C.KMCDOCCODE
FROM DoctorDetails B
INNER JOIN VRRatio C ON B.GroupCode = C.GroupCode
WHERE B.GroupCode = @GroupCode

I doubt very much your data actually has B.GroupCode = 'GroupCode'
Try changing your button code to

C#

BindGrid("ALL Groups");

or using a specific Group code that you know exists on your database

Posted 3-Mar-17 4:07am

CHill60

Comments

Mahesh2223 3-Mar-17 10:10am

well i will try lik that

Mahesh2223 3-Mar-17 23:55pm

Yes I have Changed the button code to All Groups its working fine..I have two blocks like if and else.. if is all groups else is depending on drop down selection.

Mahesh2223 3-Mar-17 23:56pm

One is working fine but drop down selected is not working

CHill60 5-Mar-17 19:16pm

I'm not sure what your new problem is. Can you give more specific info