How to fetch all rows against one column value in combobox.

Question

0.00/5 (No votes)

See more:

i am fetching data from database table against one column value. i want to fetch all rows against that value. for example if value 8 exists twice in column then query should fetch all rows against value 8.

Posted 2-Jul-14 1:56am

Member 9991234

Add a Solution

2 solutions

Solution 1

use where condition and fetch the data

SQL

select * from yourtable where yourcolumn = 'columnVal'

Posted 2-Jul-14 2:04am

DamithSL

Comments

[no name] 2-Jul-14 8:23am

actually 5 values are present against one primary key and i want to bound all that 5 values in combobox against that primary key. here is my code

DataTable dt1 = new DataTable();
SqlConnection con1 = new SqlConnection(str);
con1.Open();

string query1 = "select Lot_No from tblStockDetail where ItemID = '" + txtItemID.Text + "'";
SqlDataAdapter ad1 = new SqlDataAdapter(query1, con1);
ad1.Fill(dt1);

cboLotNo.Text = dt1.Rows[0]["Lot_No"].ToString();
txtQty.Focus();

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)

prasanth37 · Accepted Answer · 2014-07-03T02:29:00

Use the query :

Select * from Table_name WHERE Column_Name = Your_Value

Lets say your result datatable has 5 rows and you want to bind Column1 to your dropdown.

All you need to do is just bind your values from datatable to dropdownlist

Here Iam changing your code

DataTable dt1 = new DataTable();
SqlConnection con1 = new SqlConnection(str);
con1.Open();

string query1 = "select Lot_No from tblStockDetail where ItemID = '" + txtItemID.Text + "'";
SqlDataAdapter ad1 = new SqlDataAdapter(query1, con1);
ad1.Fill(dt1);
 
cboLotNo.DataSource = dt1;
cboLotNo.DataTextField = "Column_Name"; // Lot_No Text displayed for User
cboLotNo.DataValueField = "Column_Name"; // Associated Primary key for each item
cboLotNo.DataBind();

txtQty.Focus();