Display Saved value of item in Dropdown

Pravin Ghadge

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!!!!!!!

13 Replies

Know the answer? Post it — somebody with the same question will find it here.

Javeed M Shaikh15y ago
Accepted answer
Please try to use "SelectedValue" instead of "SelectedItem"
Pravin Ghadge15y ago
prblm solved....
Pravin Ghadge15y ago
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 Ghadge15y ago
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 Nair15y ago
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 Ghadge15y ago
@Javeed
no result

@Suthish
No iam not using combobox in datagridview

Thanx
Pravin Ghadge15y ago
At load Event:
  oDAL.Fill_Combo_Value_Display_ID(cmbGroupName, "Select grp_id,Grp_Name from tbl_Master_Group", "grp_id", "Grp_Name");

public void Fill_Combo_Value_Display_ID(ComboBox cmb, string Query,string Value,string 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 Nair15y ago
Are you using combo box in DataGridView?
Javeed M Shaikh15y ago
Please post your code snippet.
Pravin Ghadge15y ago
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 Shaikh15y ago
did you try setting the combox box property "SelectedValue" to your ID.
Pravin Ghadge15y ago
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 Shaikh15y ago
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.