private void button10_Click(object sender, EventArgs e) { OleDbDataAdapter dataAdapter = new OleDbDataAdapter(db.selectBlydo, db.connect); DataSet ds = new DataSet(); dataAdapter.Fill(ds); DGVIEWBlydo.DataSource = ds.Tables[0].DefaultView; //TRecept.Enabled = false; DGVIEWBlydo.Columns[0].Visible = false; if (DGVIEWBlydo.RowCount > 0) { EditItems.Clear(); for (int i = 0; i < DGVIEWBlydo.ColumnCount; i++) { EditItems.Add(DGVIEWBlydo.Rows[0].Cells[i].Value.ToString()); } } DGSostav(Convert.ToInt32(EditItems[0])); TRecept.Clear(); getRecept(Convert.ToInt32(EditItems[0])); }
private void getRecept(int id) { List <string> receptall = new List <string>(); string recept = ""; db.connect.Open(); OleDbCommand cmd = db.connect.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = db.selectRecept + id; cmd.ExecuteNonQuery(); OleDbDataReader myOleDbDataReader1 = cmd.ExecuteReader(); int i = 0; while (myOleDbDataReader1.Read()) { i++; } myOleDbDataReader1.Close(); db.connect.Close(); if (i != 0) { DataTable dt = new DataTable(); OleDbDataAdapter da = new OleDbDataAdapter(cmd); da.Fill(dt); foreach (DataRow item in dt.Rows) { receptall.Add(item[0].ToString()); } TRecept.Text = receptall[0]; } else { TRecept.Clear(); } }