Populate comboBox with actual relation name and rest records names

carlito

Hi there i got some problem i got 2 tables:

plain_table
-------------------------
plain_id
plain_name
FK_temperature_id

temperature_table
-------------------------
temperature_id
temperature_name

it's 1:1 relation

I got a datagridview where i list values from plain_table and left join to temperature. I can choose some record from datagrid - event on click in datagridview some record from plain_table then i populate controls plain_id - textbox, plain_name - textbox and FK_temperature_id - by combobox

my problem is i want to populate this combo by set first value of this combo on actual relation name from temperature_name, and then rest populate it rest of temperature_name's

ok some of code i made:
this how's I go to other form and take plain_name value from datagrid:

Code:

myfrmPlainEdit.plain_name = GrdPlain.CurrentRow.Cells[0].Value.ToString()

Now i am on second form

Code:

public string plain_name;

now i trying to populate controls:

Code:

public void frmSamolotyEdytuj_Load(object sender, EventArgs e)
{
try
{
DataSet dataSet = new DataSet();

using (SqlConnection connection = new SqlConnection("Data Source=TOSHIBA;Initial Catalog=plain;User Id=sa;Password=qazwsx;"))
{
connection.Open();

using (SqlCommand command = new SqlCommand())
{
command.CommandText = ("select * from temperature");
command.Connection = connection;

using (SqlDataAdapter dataAdapter = new SqlDataAdapter(command))
{
dataAdapter.Fill(dataSet); //filles each query as result in seperate datatable

DataTable dt1 = new DataTable();
dataAdapter.Fill(dt1);

CboNewTemperatura.DataSource = dt1;
CboNewTemperatura.DisplayMember = "temperature_name";
CboNewTemperatura.ValueMember = "temperature_id";
//CboNewTemperatura.SelectedValue = "temperature_id";
}

using (SqlDataReader dr = command3.ExecuteReader(CommandBehavior.CloseConnection))
{
while (dr.Read())
{
TxtNewPlain_name.Text = Convert.ToString(dr["plain_name"]);
}
dr.Close();
}
}
}
}
}
}
}
catch
{

}
finally
{

}
}

i populate a combobox, but how to set first value to actual name in relation with record i pick from datagrid? I trying with selectedvalue but..
plz help

4 Replies

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

carlito15y ago
All is about I want to bind to my controls all values of choosed record from datagrid.

Like i wrote above i got

temperature_table and it has those records:

temperature_id    temperature_name
1                      temperature1
2                      temperature2
3                      temperature3
4                      temperature4
5                      temperature5

Now for example I got:

plain_id    plain_name         FK_temperature_id
1            MIG                   4

So plain_id 1 is in relation with temperature_id4

Now in my project i got on main form datagridview where by dataset i fill this datagrid view by query:
[code]
SELECT     plain_table.plain_name,n_table.dlugosc, temperature.temperature_name
FROM         plain_table INNER JOIN
                      temperature ON plain_table.FK_temperature_id = temperature.temperature_id
[/code]
So now i have got filled a datagridview....

Now i got button Edit:
[code]
private void cmdEdit_Click(object sender, EventArgs e)
        {
            frmPlainEdit myfrmSamolotyEdytuj = new frmPlainEdit ();
            frmPlainEdit .plain_name = GrdPlain.CurrentRow.Cells[0].Value.ToString();
            frmPlainEdit .ShowDialog();
        }
[/code]

Now on seconf MDI form i got a controls which i bind...

[code]
public partial class frmPlainEdit : Form
    {
        public string plain_name;

......
......

public void frmPlainEdit _Load(object sender, EventArgs e)
        {
            try
            {
                DataSet dataSet = new DataSet();

                using (SqlConnection connection = new SqlConnection("Data Source=compInitial Catalog=plain;User Id=sa;Password=haslo;"))
                {
                    connection.Open();

                    using (SqlCommand command = new SqlCommand())
                    {
                        command.CommandText = ("select * from temperature");
                        command.Connection = connection;

.................

using (SqlDataAdapter dataAdapter = new SqlDataAdapter(command))
                                    {
                                        dataAdapter.Fill(dataSet); //filles each query as result in seperate datatable

                                        DataTable dt1 = new DataTable();
                                        dataAdapter.Fill(dt1);

                                        CboNewTemperatura.DataSource = dt1;
                                        CboNewTemperatura.DisplayMember = "temperature_name";
                                        CboNewTemperatura.ValueMember = "temperature_id";
                                    }

[/code]

I want to populate CboNewTemperatura (combobox) by all names from table temperature but i want to set selected value on that is in actually in relation... So from example first selected value should be 4 (name temperature_4) and below

temperature_1
temperature_2
temperature_3
0
Prabhu Raja15y ago
I can't Understand Carlito. what these are all.
0
carlito15y ago
I can only dt1. :
TableCleared
TableClearing
TableName
TableNewRow
0
Prabhu Raja15y ago
hi carlito,

try this

CboNewTemperatura.DataSource = dt1;
CboNewTemperatura.DisplayMember =dt1.Tables[0];
CboNewTemperatura.ValueMember = "temperature_id";

------------------------------
if this helps you, mark it as "Correct Answer"
0