Tech
News
Videos
Forums
Jobs
Books
Events
More
Interviews
Live
Learn
Training
Career
Members
Blogs
Challenges
Certification
Contribute
Article
Blog
Video
Ebook
Interview Question
.NET
.NET Core
.NET MAUI
.NET Standard
Active Directory
ADO.NET
Agile Development
AI
AJAX
AlbertAGPT
Alchemy
Alexa Skills
Algorand
Algorithms in C#
Android
Angular
ArcObject
ASP.NET
ASP.NET Core
Augmented Reality
Avalanche
AWS
Azure
Backbonejs
Big Data
BizTalk Server
Blazor
Blockchain
Bootstrap
Bot Framework
Business
Business Intelligence(BI)
C#
C# Corner
C# Strings
C, C++, MFC
Career Advice
Careers and Jobs
Chapters
ChatGPT
Cloud
Coding Best Practices
Cognitive Services
COM Interop
Compact Framework
Copilot
Cortana Development
Cosmos DB
Cryptocurrency
Cryptography
Crystal Reports
CSS
Current Affairs
Custom Controls
Cyber Security
Data Mining
Data Science
Databases & DBA
Databricks
Design Patterns & Practices
DevExpress
DevOps
DirectX
Dynamics CRM
Enterprise Development
Entity Framework
Error Zone
Exception Handling
F#
Files, Directory, IO
Flutter
Games Programming
GDI+
General
Generative AI
GO
Google Cloud
Google Development
Graphics Design
Graphite Studio
Hardware
Hiring and Recruitment
HoloLens
How do I
HTML 5
Infragistics
Internet & Web
Internet of Things
Ionic
Java
Java and .NET
JavaScript
JQuery
JSON
JSP
Knockout
Kotlin
Langchain
Leadership
Learn .NET
Learn iOS Programming
LINQ
Machine Learning
Metaverse
Microsoft 365
Microsoft Fabric
Microsoft Office
Microsoft Phone
Microsoft Teams
Mobile Development
MongoDB
MuleSoft
MySQL
NEAR
NetBeans
Networking
NFT
NoCode LowCode
Node.js
Office Development
OOP/OOD
Open Source
Operating Systems
Oracle
Outsourcing
Philosophy
PHP
Polygon
PostgreSQL
Power Apps
Power Automate
Power BI
Power Pages
Printing in C#
Products
Progress
Progressive Web Apps
Project Management
Public Speaking
Python
Q#
QlikView
Quantum Computing
R
React
React Native
Reports using C#
Robotics & Hardware
RPA
Ruby on Rails
RUST
Salesforce
Security
Servers
ServiceNow
SharePoint
Sharp Economy
SignalR
Smart Devices
Snowflake
Software Architecture/Engineering
Software Testing
Solana
Solidity
Sports
SQL
SQL Server
Startups
Stratis Blockchain
Swift
SyncFusion
Threading
Tools
TypeScript
Unity
UWP
Visual Basic .NET
Visual Studio
Vue.js
WCF
Wearables
Web API
Web Design
Web Development
Web3
Windows
Windows Controls
Windows Forms
Windows PowerShell
Windows Services
Workflow Foundation
WPF
Xamarin
XAML
XML
XNA
XSharp
Register
Login
4
Answers
Populate comboBox with actual relation name and rest records names
carlito
13y
1.6k
1
Reply
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
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
Problem In Inheritence
[C#] Buttons and shortcuts