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();
}
}
