Dispaly values into datagridview combobox column according to search

Question

1.00/5 (1 vote)

See more:

Hi,
I have a combobox in datagridview,successfully adding the record into db and storing the combobox id(value member)value into db.I am using search button to dispaly that saved values into datagridview.
Ex:
combo box column:
display members: A,B,C(Prod)
Value Memeber:1,2,3(ID)

Table:---
ID Date Prod
2 7/26/2012 B
3 7/27/2012 C
2 7/27/2012 B
1 7/28/2012 A

when search from 7/26/2012 to 7/27/2012, Datagridview display the 3 records:

my Datagridview consists Combobox-(Products),textbox(Date)
i am displaying the products in combobox and date in textbox

Products Date

B 7/26/2012
C 7/27/2012
B 7/27/2012

any one please send the code

Thanks in advance
Sucharitha

Posted 27-Jul-12 2:00am

RagSuchi

Updated 30-Jul-12 19:32pm

v10

Add a Solution

Comments

Menon Santosh 27-Jul-12 8:24am

please elaborate

1 solution

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)

Menon Santosh · Answer 1 · 2012-07-27T02:50:00

Query the DB

C#

sql="Select uID,cUnit from tblUnit";

Now add a combo column in datagridview and pass datatable

C#

public  void AddColumnCombo(DataGridView Grid, string sCaption, DataTable dt, string sDisplayMember, string sValueMember)
        {
           
            DataGridViewComboBoxColumn GColumn = new DataGridViewComboBoxColumn
            {
                HeaderText = sCaption,
                DataSource = dt,
                DisplayMember = sDisplayMember,
                ValueMember = sValueMember
            };            
            Grid.Columns.Add(GColumn);            
            
        }

now asign the value to set required data for eg set 2 to display B

C#

DataGridView[0,0].Value = Convert.ToString(datarow["UId"]) == "" ? null : (object)Convert.ToInt32(datarow["UId"]);