How can use if else statement in datatable

Question

0.00/5 (No votes)

See more:

but it not work
i store data in viestaete
and i use dropdownlist to filter record
now my problem is when dropdown selecting index is zero then show all record other wise show only selecting record

What I have tried:

<pre> DataTable dt = (DataTable)ViewState["dtQueAns"];
        DataView dv = new DataView(dt);
        dv.RowFilter = "if Date =0 then Date else Date ='" + Date.ToString("dd/MM/yyyy") + "'";
        dt = dv.ToTable();
        rptEvantlog.DataSource = dt;
        rptEvantlog.DataBind();

Posted 17-Jun-19 21:01pm

Member 13484654

Updated 17-Jun-19 23:52pm

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)

OriginalGriff · Answer 1 · 2019-06-17T21:38:00

Row filters can't involve "external values": they have no access to the variables in your program. So while you can include the current value of the selection in your filter, if it changes, that won't affect the display unless you change the filter string.

Start by using the view directly:

private DataView dv = null;
...
dv = new DataView(dt);
...
rptEvantlog.DataSource = dv;

You can then set the RowFilter in the SelectionChanged event for your dropDown:

dv.RowFilter = $"{index} = 0 OR Date = #{matchDate}#";

Maciej Los · Answer 2 · 2019-06-17T23:53:00

Please, read the documentation, especially Remarks: DataView.RowFilter Property (System.Data) | Microsoft Docs[^]

RowFilter accepts an expression, so, it has to contain a column name and a value, for example:

C#

dv.RowFilter = "DateOfTransaction=#{ProperDate}#";

In other words, you can built your own expression this way:

C#

string s = DropDown1.SelectedIndex==0 ? DateTime.Today.ToString("d") : DropDown1.Value.ToString("d");
dv.RowFilter = string.Format("DateColumn=#{0}#", s);

For further details, please see:
DataColumn.Expression Property (System.Data) | Microsoft Docs[^]
DateTime.Date Property (System) | Microsoft Docs[^]

How can use if else statement in datatable

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0