How to disable column in repeater based on null values?

Question

1.00/5 (2 votes)

See more:

SQL-Server-2008R2

Dear All,

I have a table as tblStudentsInfo with SId, SName, and Phone.

Now I want display SName and Phone using Repeater control.

If Phone has null values I want to disable SName column.
The expected output like,

tblStudentsInfo

SName Phone
----- ------
Sai 1234567890
Raju 1245678922
Alex null
Rabet null
Ramesh 1245678990

Posted 13-Dec-15 20:43pm

Member 10021658

Updated 13-Dec-15 22:34pm

Arasappan

v3

Add a Solution

Comments

Amit Jadli 14-Dec-15 3:31am

You can put where clause in sql query..by that you will not get the rows who have null values...

Sinisa Hajnal 14-Dec-15 3:43am

WHERE PHONE IS NULL. You didn't do any research and this is bad question because no attempt to solve the problem is apparent. My vote of 1.

Member 10021658 14-Dec-15 3:58am

Dear Sinisa, Thanks for your reply.
Thanks

Member 10021658 14-Dec-15 4:00am

Dear Sinisa, Thanks for your reply. I have already used where condition. But I need to display SName always and disable the address if Phone is null.
O/p
SName Address Phone
Sai Bglr 1234567890
Alex (Alex don't have phone so disabled the address data)
Raju hyd 1245678990

Thanks

Amit Jadli 14-Dec-15 4:09am

Not clear what u wants to do...

Arasappan 14-Dec-15 4:11am

please clearly explain

Member 10021658 14-Dec-15 4:19am

<table style="border: 1px solid #c1650f; width: 35%; padding: 10px 0px 10px 10px"
cellpadding="0">
<asp:Repeater ID="Repeater2" runat="server">
<itemtemplate>
<tr align="right">
<td>
<asp:Label ID="Label1" runat="server" Text='<%#Eval("SName")%>' />
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label4" runat="server" Text='<%#Eval("Address")%>' />
<asp:Label ID="Label3" runat="server" Text='<%#Eval("Phone") %>' />
</td>
</tr>

</table>

Here I want to display three columns data like SName, Address and Phone. If Student don't have phone number that row should be displayed on SName data, at same time Address and Phone numner is disabled. Thanks

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)

Arasappan · Answer 1 · 2015-12-13T22:23:00

Solution 1

Use with and without where condition

SQL

SELECT sname,(ISNULL(phone,'disabled')) as phone,(ISNULL(address,'disabled')) as address from tablename

Posted 13-Dec-15 22:23pm

Arasappan

Updated 13-Dec-15 22:28pm

v4