ASP GRIDVIEW

Question

0.00/5 (No votes)

See more:

Hi all,

I have a table contains name, age, dob, mobileno, landphoneno, officeno, fax.

I want to display the name, age, dob and any of the contact Nos from mobileno, phoneno, officeno, fax Nos that was given by the user.

If the user had not given the mobileno but given the phoneno then the phoneno is diplayed in gridview as cotactno heading.The precedency is landphoneno,mobileno and officeno

Thanks in Advance!

Posted 12-Dec-10 19:40pm

Starlene

Add a Solution

2 solutions

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)

Brij · Answer 1 · 2010-12-12T20:00:00

Solution 1

There are various ways to do this,

you just fetch only that number that are present in DB
else

fetch all the columns from DB and there is an event called Rowdatabound. In this you can check what data is present and take the decision according, I mean show or hide accordingly

Posted 12-Dec-10 20:00pm

Brij

senguptaamlan · Answer 2 · 2010-12-12T20:42:00

you can use the following code in a procedure, get the result and bind it to your gridview

SQL

select Name,Age, DOB, "Contact No"=
    CASE
        WHEN landphone IS NOT NULL THEN (SELECT landphone from customer cst where cst.CustID = outCust.CustID)
        WHEN mobilephone IS NOT NULL THEN (SELECT mobilephone from customer cst where cst.CustID = outCust.CustID)
        WHEN officeno IS NOT NULL THEN (SELECT officeno from customer cst where cst.CustID = outCust.CustID)
        WHEN fax IS NOT NULL THEN ( SELECT fax from customer cst where cst.CustID = outCust.CustID)
        ELSE 'no contact no'
    END
FROM Customer outCust

I've used a table something like your table definition (only the difference is I've one Primary Key CustID)