sample code
string sql = "SELECT S.SaleID, P.ProductID, P.ProductName, P.Manfacturer, S.CustomerID, S.SoldDate, S.Qty,P.Rate, (s.Qty * P.Rate) AS [Total] FROM Products P INNER JOIN Sales S ON s.ProductID = P.ProductID";
using (SqlConnection con = new SqlConnection("connectionString"))
using (SqlDataAdapter sadp = new SqlDataAdapter(sql, con))
{
DataSet ds = new DataSet();
sadp.Fill(ds);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}