private void searchTextbox_TextChanged(object sender, EventArgs e) { panel1.Controls.Clear(); int horizontal = 8, vertical = 5; connection.Open(); SqlCommand search = new SqlCommand(searchString, connection); search.Parameters.AddWithValue("@prod", "%" + searchTextbox.Text + "%"); using (var reader = search.ExecuteReader()) { int count = 0; while (reader.Read()) { p[count] = new productControl(); p[count].Name = count.ToString(); p[count].getProdId = (int)reader[0]; p[count].getUserId = (int)userId; p[count].Location = new Point(horizontal, vertical); panel1.Controls.Add(p[count]); vertical += 90; count++; } } connection.Close(); }
private void createFunctions() { int horizontal = 8, vertical = 5; connection.Open(); SqlCommand retProduct = new SqlCommand(productRetriever, connection); panel1.Controls.Clear(); using (var reader = retProduct.ExecuteReader()) { int count = 0; while (reader.Read()) { p[count] = new productControl(); p[count].Name = count.ToString(); p[count].getProdId = (int)reader[0]; p[count].getUserId = (int)userId; p[count].Location = new Point(horizontal, vertical); panel1.Controls.Add(p[count]); vertical += 90; count++; } } connection.Close(); }