filter a gridview using logical conditions that were filled dropdownlist

Question

0.00/5 (No votes)

See more:

hii i am newbie to .net programming,i am trying to filter a gridview, using logical conditions that were filled dropdownlist

eg: select * from emp where salary < 10000 (i filled "<" operator in dropdownlist)
using the above query i want to display emp names less than 10000 in asp.net

Posted 30-May-13 0:50am

anudeep varikoti

Add a Solution

Comments

Rockstar_ 30-May-13 6:53am

Can i have ur code?

Rockstar_ 30-May-13 6:53am

What u do is , write if condition for lessthan and greaterthan

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dharmendra-18 · Answer 1 · 2013-05-30T01:11:00

Solution 1

You can try this..

C#

string query = "select * from emp where salary < 1000";
cmd = new SqlCommand(query,con);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dropdownList1.DataSource = dt;
dropdownList1.DataValueField = "empName";
dropdownList1.DataTextField= "empName";
dropdownList1.DataBind();

Posted 30-May-13 1:11am

Dharmendra-18

Comments

anudeep varikoti 30-May-13 9:09am

****i just want my logical conditions to be applied from dropdownlist only****.

i have a database with empnames,sal nd empid,
when i just wish to filter my db with logical conditions(say,.sal > 10000) i want to display those filtered values to my gridview..

Dharmendra-18 31-May-13 5:32am

use like this

gridview1.DataSource=dt;
gridview1.DataBind();

filter a gridview using logical conditions that were filled dropdownlist

1 solution

Solution 1

Add your solution here

Preview 0

filter a gridview using logical conditions that were filled dropdownlist

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us