private void button1_Click_1(object sender, EventArgs e)
{
MainMenu frm = new MainMenu();
List <object[]> data = new List <object[]>();
data = frm.get_data_table_string_like("tbasfis", "speciesname", txtsearch.Text.Trim());
if (data.Count > 0)
{
dataGridView1.Rows.Clear();
dataGridView1.Rows.Add(data.Count);
for (int i = 0; i < data.Count; i++)
{
dataGridView1.Rows[i].Cells[0].Value = (i + 1).ToString();
dataGridView1.Rows[i].Cells[1].Value = data[i][0].ToString();
if (data[i][1] == null)
{
dataGridView1.Rows[i].Cells[2].Value = "";
}
else
{
dataGridView1.Rows[i].Cells[2].Value = data[i][1].ToString();
}
if (data[i][2] == null)
{
dataGridView1.Rows[i].Cells[3].Value = "";
}
else
{
dataGridView1.Rows[i].Cells[3].Value = data[i][2].ToString();
}
}
}
}
private void search_hts(String products)
{
List <object[]> datahts;
MainMenu frm = new MainMenu();
String product = txtproductdescription.Text.Trim();
datahts = frm.get_data_table_string_like("tb_htsproduct", "commodity_description", product);
if (datahts.Count > 0)
{
dghts.Rows.Clear();
dghts.Rows.Add(datahts.Count);
for (int i = 0; i < datahts.Count; i++)
{
dghts.Rows[i].Height = 40;
dghts.Rows[i].Cells[0].Value = (i + 1).ToString();
dghts.Rows[i].Cells[1].Value = datahts[i][1].ToString();
dghts.Rows[i].Cells[2].Value = datahts[i][2].ToString();
dghts.Rows[i].Cells[3].Value = datahts[i][3].ToString();
}
select_columnbutton();
}
}
