Display Saved value of item in Dropdown

Question

Dear all
1)I have created Group Table (grp_id,Grp_Name) where iam storing group like 'Nokia,Samsung' etc
2)then i have created Product Master(pid,ProductName,grp_id,rate)
In Product Master form i have use Displaymemeber & valuemember property of combo box which display Grp_Name & grp_id in combobox from Group Master table.

When iam saving data to Product Master, it save like this:

Pid ProductName grp_id rate
1 Nokia1100 1 1200
2 Nokia1000 1 1500
3 Samsung3500 2 2000

Till it is ok.
My problem occurs when displaying record.
It doesn't fectch groupNam on form. i know that iam not saving Groupname.
But can i show groupname in Combobox at the time of editing record Same as when i loading form.

Plz help me out!!!!!!!

Javeed M Shaikh · Answer

Please try to use SelectedValue instead of SelectedItem

Pravin Ghadge · Answer

prblm solved....

Pravin Ghadge · Answer

Hi Iam now using datagridview comboboxcell. Here iam working with same scenario. But here it is not showing name. & how should i use Selectedvalue property of combobox same for Comboboxcell

Pravin Ghadge · Answer

Thanx Javeed & Suthish Javeed I have replaced selecteditem to selectedvalue. At that time it wasn't worked for mw. Bt yesterday when i put debug to run code. The debug was not matching with that code. Then i have deleted the debug folder of my project. so it is working right now with same code only. Thanx

Suthish Nair · Answer

But where the code written for binding the records for cmbGroupName. You are just using SelectedItem for selecting Item there must be a datasource. I agree this method ( Fill_Combo_Value_Display_ID ) is used but not sure about this method during edit. Put a break point and check combo box count at each level.

Pravin Ghadge · Answer

@Javeed no result @Suthish No iam not using combobox in datagridview Thanx

Pravin Ghadge · Answer

At load Event: oDAL.Fill_Combo_Value_Display_ID(cmbGroupName Select grp_idGrp_Name from tbl_Master_Group grp_id Grp_Name); public void Fill_Combo_Value_Display_ID(ComboBox cmb string Querystring Valuestring Display) { cmd = new SqlCommand(Query OpenConnection()); SqlDataReader rsAutors = cmd.ExecuteReader(); ArrayList Authors = new ArrayList(); Authors.Add(new AddValue(Select 0)); while (rsAutors.Read()) { Authors.Add(new AddValue(rsAutors.GetString(1)rsAutors[0].ToString())); } rsAutors.Close(); cmb.DataSource = Authors; cmb.DisplayMember = Display; cmb.ValueMember = Value; } I have use AddValue class For fetching values public class AddValue { private string m_Display; private string m_Value; public AddValue(string Display string Value) { m_Display = Display; m_Value = Value; } public string Display { get { return m_Display; } // set { m_Display =; Display} } public string Value { get { return m_Value; } // set { m_Value = Value; } } } Edit Record: private bool FBShowRecord(string vCode) { try { SqlCommand vCmd = new SqlCommand(); SqlDataReader vDrd; vCmd.Connection = oDAL.OpenConnection(); vCmd.CommandText = Select * from tbl_Master_Product where pid=' + vCode + '; vDrd = vCmd.ExecuteReader(CommandBehavior.Default); if (vDrd.HasRows) { vDrd.Read(); txtNo.Text = vDrd[pid].ToString(); txtName.Text = vDrd[PNAME].ToString(); cmbGroupName.SelectedItem = vDrd[grp_id].ToString(); } vDrd.Close(); vCmd.Dispose(); return true; } catch (Exception ex) { MessageBox.Show(ex.Message); return false; } }

Suthish Nair · Answer

Are you using combo box in DataGridView?

Javeed M Shaikh · Answer

Please post your code snippet.

Pravin Ghadge · Answer

Yes i have tried it. it gives me null when i quickwatch the combobox bt in datareader it shows me the exact value.

Javeed M Shaikh · Answer

did you try setting the combox box property SelectedValue to your ID.

Pravin Ghadge · Answer

Thanx Javed for ur reply. I have Product Master form where i have Group name as combobox. In this combobox iam showing GroupName using Displaymember property which iam fetching from Group Master. At the time of saving the form data iam only saving groupid not the group name in database. So at the time of editing record how should i show groupname in combobox without join. Plz revert back....

Javeed M Shaikh · Answer

Hi Pravin The question is not clear do you want to show group name on the form than why dont you join the two tables and get the group name along with other details. Please if you can be more clear and specific in your requirements it will help us to try and provide some solution.