DataGridView super complicated problem, will come in to help

baby_7th

The younger brother encountered the following problems while doing the system:

1． How to retrieve and display them in the DataGridView according to three conditions (that is, two textboxes and one DropDownList value).

2． How to add a row to the bottom of the DataGridView to count the sum of each column.

3． How to add a column, the value of this column is equal to the difference between the values ​​of the first two columns (ie, column 3 = column 2-column 1). When (column 2-column 1) <0 in a row, the value of column 3 in a row is 0; otherwise, the value of column 3 in a row (column 2-column 1).

4． When the DataGridView is paginated, it is set to 10 rows per page, but when the number of rows on a page is less than 10, the footer (where "previous page, next page" is displayed) is automatically disappeared. How to display it without displaying it " Previous Next".


All its required functions are shown in a simple table as follows:
． ． ． ． ． ． ． ． ． ． ． ． ． ． ． ． ． ． ．

Serial No. 1 2 3
１ ３ 19 16
     2 13 10 0
     3 8 20 12
     4 10 6 0
Total: 34 55 28

． ． ． ． ． ． ． ． ． ． ． ． ． ． ． ． ． ．
     Previous Next

Please help how to achieve it, it is best to use C # to list the code. Thank you.

ynyulong

Bangding!

宿根草的精灵

You can refer to it!

            DataSet ds;
            ds = dbconn.selectSQL ();

            try
            {
                ds.Tables [0] .Columns [0] .ColumnName = "Serial Number";
                ds.Tables [0] .Columns [1] .ColumnName = "Column 1";
                ds.Tables [0] .Columns [2] .ColumnName = "Column 2";
                ds.Tables [0] .Columns [3] .ColumnName = "Column 3";

            int iNum1 = 0;
            int iNum2 = 0;
            int iNum3 = 0;
            for (int i = 0; i <dsTypes.Tables [0] .Rows.Count; i ++)
            {
                iNum1 = iNum1 + int.Parse (ds.Tables [0] .Rows [i] [1] .ToString ());
                iNum2 = iNum2 + int.Parse (ds.Tables [0] .Rows [i] [2] .ToString ());
                iNum3 = iNum3 + int.Parse (ds.Tables [0] .Rows [i] [3] .ToString ());
            }
            DataRow dr = ds.Tables [0] .NewRow ();
            dr ["Serial Number"] = "Total";
            dr ["column 1"] = iNum1;
            dr ["column 2"] = iNum2;
            dr ["column 3"] = iNum3;
            ds.Tables [0] .Rows.Add (dr);
            this.dataGridView1.DataSource = ds.Tables [0] .DefaultView;

宿根草的精灵

Points to note:
(1) If the serial number item must be of type string, it can be changed to "total".
(2) Column 1 is int!