Adding empty number of rows in gridview based on grid rows count

Question

Hi i am looking for having 10 records in the grid-view by default

so if the grid-view has 3 rows then there are 7 empty rows to add,

if grid-view has 4 rows then there are 6 empty rows, etc..

also if grid-view has 10 rows there's no empty rows to add

QueryClass q = new QueryClass();
grid.DataSource = q.getdata();
grid.DataBind();

Method

public DataTable getdata()
{
string query = string.Format("SELECT TOP(10) * FROM Store");
return Search(query);
}

Seany84 · Accepted Answer · 2016-04-15 00:14:22Z

3

You could create an extension method for this:

public static class HelperMethod
{
    public static List<QueryClassObj> Extend(this List<QueryClassObj> items)
    {
        while (items.Count < 10)
        {
            items.Add(new QueryClassObj());
        }
        return items;
    }
}

When you get the data and bind to your grid simply:

QueryClass q = new QueryClass();
grid.DataSource = q.getdata().Extend();
grid.DataBind();

Based on your edit you can try this

public DataTable getdata()
{
string query = string.Format("SELECT TOP(10) * FROM Store");
DataTable results= Search(query);
while(results.Rows.Count<10)
{
 results.Rows.Add(results.NewRow());
}
}

Sorry I have not been able to test my last edit as I'm away from PC

edited Apr 15, 2016 at 0:14

answered Apr 14, 2016 at 23:27

Seany84

5,5965 gold badges46 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Ayman Over a year ago

thanks but i didn't understand how to add extension method i added the method i used in question

Seany84 Over a year ago

@Ayman Replace QueryClassObj with the type of object that your q.getdata() returns

Ayman Over a year ago

system.data.datatable does not contain a definition for Extend accepting a first argument of type system.data.datatable

Seany84 Over a year ago

@Ayman See my edit. The original answer was posted before you showed the getdata()

Zein Makki · Accepted Answer · 2016-04-15 05:27:34Z

1

You can Add the missing items to your datasource:

QueryClass q = new QueryClass();

var dSource = q.getdata();

foreach (var missing in Enumerable.Range(1, 10 - dSource.Rows.Count))
{
    dSource.NewRow();
}
grid.DataSource = dSource;

grid.DataBind();

edited Apr 15, 2016 at 5:27

answered Apr 14, 2016 at 23:20

Zein Makki

30.2k6 gold badges58 silver badges66 bronze badges

Collectives™ on Stack Overflow

Adding empty number of rows in gridview based on grid rows count

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related