Selecting Values > 0 in GridView ASP.NET

Question

0.00/5 (No votes)

See more:

In this i m Binding Data From dataBase to GridView DropDownList
it shows 80 records
i want to use a condition it in that select that record whose value is > 0
any ideas how it can be done

XML

private void bindCombo(string ddlName)
        {
               if (ddlName == &quot;ddlCustCode&quot;)
           {
               ddlCustCode.DataSource = dl.getCustCode("S");
               ddlCustCode.DataTextField = "CardCode";
               ddlCustCode.DataValueField = "CardName";

               ddlCustCode.DataBind();
           }
        }

Posted 9-Oct-13 19:50pm

xibit89

Updated 9-Oct-13 20:07pm

Thanks7872

v2

Add a Solution

Comments

Zafar Sultan 10-Oct-13 1:54am

What do you mean by record whose value > 0? You can check that condition in your SP or SQL query. Or is there something else your question is pointing to? Please elaborate.

chitransh635 10-Oct-13 1:56am

Please clarify Your question .

xibit89 10-Oct-13 2:03am

there are 3 columns CustName, CustCode, Qty
the upper code bind the gridview with CustName and CustCode from database, OnSelectedItem it automatically generate the value into the Qty column from database.

I want to add condition there that the Qty column only shows the value which are greater than 0.

xibit89 10-Oct-13 1:59am

there are 3 columns CustName, CustCode, Qty
the upper code bind the gridview with CustName and CustCode, OnSelectedItem it automatically generate the value into the Qty column.

I want to add condition there that the Qty column only shows the value which are greater than 0.

JoCodes 10-Oct-13 2:09am

anyways you are fetching the QTy value from the database right? So whats stopping you from adding filtering/condition in the sql query.

xibit89 10-Oct-13 2:12am

yep it is the simplest way, but i am not allowed to edit DataBase..

JoCodes 10-Oct-13 2:21am

You can use generic list and filter with condition greater than 0 . Here dl.getCustCode("S") method can return a generic list.

xibit89 10-Oct-13 2:29am

Can u please clarify, HOW to use the generic list??

JoCodes 10-Oct-13 3:03am

Have created a demo to filter generic list and lambda expression and added as a solution.

Zafar Sultan 10-Oct-13 2:09am

Why don't you put a condition in your SQL query to populate gridview only with columns having quantity greater than zero? In this way you won't have to check on selecting an item.

xibit89 10-Oct-13 2:12am

yep it is the simplest way, but i am not allowed to edit DataBase..

3 solutions

Solution 1

in database you can do

declare @quantity int
set @quantity=select quantity from table where quantity>0
if @quantity>0
begin
select CustName,CustCode,qty from table
end

try this and let me know

Posted 9-Oct-13 20:05pm

chitransh635

Comments

xibit89 10-Oct-13 2:09am

i am not allowed to edit dataBase. what i have to use is in asp.net.\

Second it is stored Procedure. Not Table.

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)

chitransh635 · Accepted Answer · 2013-10-09T20:42:00

Solution 2

You Can do like this
You are fetching your data in datatable

Suppose you are fetching your datatable name dt
create ne datatable name myNewTable
DataTable myNewTable = dt.Select("qty<> '0'").CopyToDataTable();

try it and let me know this will help you without making any changes in database

Posted 9-Oct-13 20:42pm

chitransh635

Comments

xibit89 10-Oct-13 2:45am

thanks chitransh635. It Worked!!

JoCodes · Accepted Answer · 2013-10-09T21:01:00

You can try using Generic list so that it can be filtered easily.

C#

private void Bind()
        {
            List<Item> items = new List<Item>()
            {
                 new Item(){ Cust = "One", QTY=8 },
                 new Item(){ Cust = "Two", QTY=0},
                 new Item(){ Cust = "Three", QTY=14 }
            };//Adding list item just to demonstrate

            DropDownList1.DataSource = items.Where(itm=>itm.QTY>0) ;
            DropDownList1.DataTextField = "Cust";
            DropDownList1.DataValueField = "Cust";
            DropDownList1.DataBind();
        }

C#

public class Item// this can be replaced as per your type that you fetch from your DL layer ( like dl.getCustCode("S") )
   {
       public string Cust { get; set; }
       public int QTY { get; set; }
   }

Hope this helps

Selecting Values > 0 in GridView ASP.NET

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us