void LoadCards() { panelCardsContent.Controls.Clear(); lstId.Clear(); SqlConnection con = new SqlConnection(Form1.txtcon); string txtquery = "select id_game from Games where id_studio = " + id_studio; con.Open(); SqlCommand query1 = new SqlCommand(txtquery, con); SqlDataReader read = query1.ExecuteReader(); while (read.Read()) { lstId.Add(read["id_game"].ToString()); } con.Close(); int curY = 10; for (int i = 0; i <= lstId.Count - 1; i++) { MaterialCard card = new MaterialCard(); card.Size = new Size(1000, 150); card.Location = new Point(100, curY); panelCardsContent.Controls.Add(card); CardAbout crd = new CardAbout(lstId[i]); crd.btnEdit.Click += btnEdit_Click; crd.btnDel.Click += BtnDel_Click; card.Controls.Add(crd); curY += 160; } }
void LoadCards() { panelCards.Controls.Clear(); lstId.Clear(); SqlConnection con = new SqlConnection(Form1.txtcon); string txtquery = "select id_game from Games where visible = 'true' "; if (genre != "") { txtquery += genre; } if (search != "") { txtquery += search; } con.Open(); SqlCommand query1 = new SqlCommand(txtquery, con); SqlDataReader read = query1.ExecuteReader(); while (read.Read()) { lstId.Add(read["id_game"].ToString()); } con.Close(); int curY = 10; for (int i = lstId.Count - 1; i >= 0; i--) { MaterialCard card = new MaterialCard(); card.Size = new Size(750, 150); card.Location = new Point(3, curY); panelCards.Controls.Add(card); CardAbout crd = new CardAbout(lstId[i]) { flag = true }; crd.btnDel.Visible = false; crd.btnEdit.Tag = lstId[i]; crd.btnEdit.Text = "Подробнее"; crd.btnEdit.IconChar = FontAwesome.Sharp.IconChar.ThList; crd.btnEdit.Width = 400; crd.btnEdit.Click += BtnEdit_Click; card.Controls.Add(crd); curY += 160; } }