GridControl showing no data but empty rows C#

797 Views Asked by At

I have a gridcontrol which needs to be populated with some data.

I have created a datatable and populated data in datarow and added to the table. Data is present in table on analysis. Datatable is then set as datasource for grid. Code is below.

        DataTable table = new DataTable();
        table.Columns.Add("Tran Date");
        table.Columns.Add("Due Date");
        table.Columns.Add("Voucher");
        table.Columns.Add("Vr No");
        table.Columns.Add("Bill Amount");
        table.Columns.Add("OutStanding");
        table.Columns.Add("Remittance");
        table.Columns.Add("Balance");
        

        for (intcount=0;intcount<=BackupFunctions.mdtAgeingTemp.Rows.Count - 1;intcount++)
        {
            DataRow row = table.NewRow();
            row["Tran Date"] = BackupFunctions.mdtAgeingTemp.Rows[intcount][1];
            row["Due Date"] = BackupFunctions.mdtAgeingTemp.Rows[intcount][2];
            row["Voucher"]= BackupFunctions.mdtAgeingTemp.Rows[intcount][3];
            row["Vr No"] = BackupFunctions.mdtAgeingTemp.Rows[intcount][4];
            row["Bill Amount"] = BackupFunctions.mdtAgeingTemp.Rows[intcount][10];
            row["OutStanding"] = BackupFunctions.mdtAgeingTemp.Rows[intcount][5];
            row["Remittance"] = BackupFunctions.mdtAgeingTemp.Rows[intcount][6];
            row["Balance"] = BackupFunctions.mdtAgeingTemp.Rows[intcount][7];

            table.Rows.Add(row);
            
        }
        grdAgeing.DataSource = table;

Its found that 5 rows which is the result is displaying but they are empty. Could you figure out the issue in my code.

0

There are 0 best solutions below