DataGridView Total Item Issues

kuikui

The data is read from the database to the datatable and then added totals at the bottom of the window
string selectCommand = "select ID, GXID, GXname, GXprice from WS_GX where ProductID = 1";
dataAdapter = new OleDbDataAdapter (selectCommand, conn);
DataSet ds = new DataSet ();
dataAdapter.Fill (ds, "WS_GX");
DataTable table = ds.Tables ["WS_GX"];
object objSum = table.Compute ("Sum (GXprice)", null);
bindingSource1.DataSource = table;

In the above code, objSum is used to calculate the total

But whatever
selectCommand = "select ID, GXID, GXname, GXprice from WS_GX where ProductID = 1";
still is
selectCommand = "select ID, GXID, GXname, GXprice from WS_GX";


The value of the total item is added up according to all the items in the database, which causes the total error. How can I solve it ????

kuikui

My code

// Get summary first
object objSum = newTable.Compute("Sum(number)", null );//newTable is the dataTable you requested and
                                                     //"Quantity" is the required field in your table
// Add new row
DataRow sum = newTable.NewRow();
sum[0] = "Total";
sum["Quantity"] = objSum.ToString();

newTable.Rows.Add(sum);

skyzjbbq1

No new row?
bindingSource1.DataSource = table;?
//An improper function written by accident
private void SelData(string selquery,string tablename)
        {
            OleDbDataAdapter da = new OleDbDataAdapter(selquery, mc);
            DataSet ds = new DataSet();
            da.Fill(ds, tablename);
            DataTable dt = ds.Tables[tablename];
            DataRow dr = ds.Tables[tablename].NewRow();
            dataGridView1.DataSource = ds.Tables[tablename];
            object objSum = dt.Compute("Sum(GXprice)", null);
            string san = objSum.ToString();
            if (san=="")//When GXprice is empty.. If there is nothing empty, you can save this judgment!
            {
                objSum = (object)0;
            }
            dr[GXprice] = objSum.ToString();
            ds.Tables[tablename].Rows.Add(dr);
        }

kuikui

Thanks, let me try

踩死过河马

object objSum = table.Compute("Sum(GXprice)", null);
You used "Sum()", which should use "Group by"

which is
object objSum = table.Compute("Sum(GXprice)", "Group by (except GXprice according to the field to be counted)");

kuikui

understood
object objSum = table.Compute("Sum(GXprice)", "ProductID="+requestID);