Multiple conditions in If Else in C#

ankit gaur

8y1.1k.NET

Hello

I have four Dropdownlist and i want to show data in gridview.

when i select from ddlCategory[Dropdownlist] is not Null and other dropdown are null then i want to show only one category that time else return all the category.

But its showing all the category in if condition..plz help

con.Open();

if (ddlCategory.SelectedValue != "" && ddlSubCategory.SelectedItem.Text == "" && ddlBrand.SelectedItem.Text == "" && ddlItem.SelectedItem.Text == "")

{

SqlCommand cmd = new SqlCommand("select Distinct Category from tblMatCat where Category = @Category ", con);

cmd.Parameters.AddWithValue("@Category", ddlCategory.SelectedItem.Text);

SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(dt);

}

else

{

SqlCommand cmd = new SqlCommand("select Distinct Category from tblMatCat ", con);

SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(dt);

}

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ruchi Sharavat8y ago
Hi Ankit,

You will have t debug to check that what are the exact values of each dropdown in case when Category dropdown is not null (means something selected) and other are null (means none of them is selected).

What is the value for option "All" in each dropdown? Is that blank?

So you may try that by changing your condition to :
if (ddlCategory.SelectedValue != "" && ddlSubCategory.SelectedValue == "" && ddlBrand.SelectedValue == "" && ddlItem.SelectedValue == "")
OR
if (!String.IsNullOrEmpty(ddlCategory.SelectedValue) && String.IsNullOrEmpty(ddlSubCategory.SelectedValue) && String.IsNullOrEmpty(ddlBrand.SelectedValue) && String.IsNullOrEmpty(ddlItem.SelectedValue ))
0
Jignesh Kumar8y ago
Again this code you need to call in selectedindex change event because when you select then your valsue of category should pass to sp
0
ankit gaur8y ago
Hi Jignesh,

Thanku for ur post . I have use this condition that u have post .
As i say i have the four dropdownlist and i want to show data based on these dropdown.
In ur condition if i select all ..then it show all the category. its right.
But if i select one category then it shows all the category. its wrong for me.

And Other condition if i select one category..and all subcategory from the dropdownlist..
then i want to show one category and all subcategory related to this category.

0
Code Alone8y ago
con.Open();
if (ddlCategory.SelectedValue != "" || (ddlSubCategory.SelectedItem.Text == "" && ddlBrand.SelectedItem.Text == "" && ddlItem.SelectedItem.Text == ""))
{
SqlCommand cmd = new SqlCommand("select Distinct Category from tblMatCat where Category = @Category ", con);
cmd.Parameters.AddWithValue("@Category", ddlCategory.SelectedItem.Text);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
}
else
{
SqlCommand cmd = new SqlCommand("select Distinct Category from tblMatCat ", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
}
0
Vincent Maverick Durano8y ago
You have to debug your code and step into it. What are the values of each DropDownList?
0
Jignesh Kumar8y ago
does it resolved your issue ?
0
Jignesh Kumar8y ago
Please Try this one
if (ddlCategory.SelectedValue != "" || ( ddlSubCategory.SelectedItem.Text == "" && ddlBrand.SelectedItem.Text == "" && ddlItem.SelectedItem.Text == ""))
{
+2