TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
carlito
NA
6
3k
Populate comboBox with actual relation name and rest records names
Sep 6 2011 3:19 AM
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
Reply
Answers (
4
)
Problem In Inheritence
[C#] Buttons and shortcuts