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