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 { } } |