C#

libcef.dll

CefSharp.Core.dll

SELECT p.pcode, p.pdesc, b.brand, c.category, p.price p.qty 

SELECT p.pcode, p.pdesc, b.brand, c.category, p.price, p.qty 

public void LoadRec()
        {
            try
            {

                int i = 0;
                dgvProduct.Rows.Clear();
                _sqlConn.Open();
                _sqlCmd = new SqlCommand("SELECT p.pcode, p.pdesc, b.brand, c.category, p.price, p.qty FROM tblProduct as p inner join tblBrand as b on b.id = p.bid inner join tblCategory as c on c.id = p.cid where p.pdesc like '" + txtSearchProd.Text + "%'", _sqlConn);
                _sqlDR = _sqlCmd.ExecuteReader();
                while (_sqlDR.Read())
                {
                    i++;
                    dgvProduct.Rows.Add(i, _sqlDR[0].ToString(), _sqlDR[1].ToString(), _sqlDR[2].ToString(), _sqlDR[3].ToString(), _sqlDR[4].ToString(), _sqlDR[5].ToString());
                }

                _sqlDR.Close();
                _sqlConn.Close();
            }
            catch(Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            _sqlConn.Close();
        }

using (var sqlConn = new SqlConnection("..."))
using (var sqlCmd = new SqlCommand("SELECT p.pcode, p.pdesc, b.brand, c.category, p.price, p.qty FROM tblProduct as p inner join tblBrand as b on b.id = p.bid inner join tblCategory as c on c.id = p.cid where p.pdesc like @SearchProd + '%'", sqlConn))
{
    sqlCmd.Parameters.AddWithValue("@SearchProd", txtSearchProd.Text);
    
    sqlConn.Open();
    
    using (var sqlDR = sqlCmd.ExecuteReader(CommandBehavior.CloseConnection))
    {
        while (sqlDR.Read())
        {
            i++;
            dgvProduct.Rows.Add(i, sqlDR[0].ToString(), sqlDR[1].ToString(), sqlDR[2].ToString(), sqlDR[3].ToString(), sqlDR[4].ToString(), sqlDR[5].ToString());
        }
    }
}

When I try to execute the code Sir, there is no data displayed on my datagrid.

I also try the to run these query on my sqlserver.

SELECT p.pcode, p.pdesc, b.brand, c.category, p.price, p.qty 
FROM tblProduct 
as p inner join tblBrand 
as b on b.id = p.bid inner join tblCategory 
as c on c.id = p.cid 
where p.pdesc like '%'

but theres no data showed.

SELECT p.pcode, p.pdesc, b.brand, c.category, p.price, p.qty 
FROM tblProduct p
INNER JOIN tblBrand b
       ON b.id = p.bid
WHERE p.pdesc LIKE '%'

public class myclass2
    {
    public int Id { set; get; }
    public string Name { set; get; }
    public override string ToString()
        {
        return $"{Id}:{Name}";
        }
    }

myDataGridView.DataSource = mylist;
myDataGridView.Columns[1].HeaderText = "My other class";