private void pnamebox_TextChanged(object sender, EventArgs e)
{
string key = pnamebox.Text.Trim();
DataTable dt = new DataTable();
dt = sf.Search(key);
stocklist.DataSource = dt;
}
private void button3_Click(object sender, EventArgs e)
{
String s = searchbox.Text.Trim();
if (s != "")
{
DataTable dt = cf.Search(s);
productlist.DataSource = dt;
}
else
{
DataTable dt = cf.Select();
productlist.DataSource = dt;
}
}