This is a migrated thread and some comments may be shown as answers.

[Solved] Display minimum n number of record

1 Answer 133 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Fenil
Top achievements
Rank 1
Fenil asked on 12 Feb 2013, 01:27 PM
Hi,

I am binding RadGrid using generic list. I want to display minimum 10 rows of grid even if rows are there or not in database.I have also tried after inserting blank rows in list, it display blank records but also some buttons which i have put there. Please give some suitable idea.

Thanks in advance
Fenil

1 Answer, 1 is accepted

Sort by
0
Accepted
Princy
Top achievements
Rank 2
answered on 13 Feb 2013, 05:20 AM
Hi,

Please take a look into the sample code I tried to hide the Button from the blank rows.

ASPX:
<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="false" AllowPaging="true"
    PageSize="10" OnNeedDataSource="RadGrid1_NeedDataSource" OnItemDataBound="RadGrid1_ItemDataBound">
    <PagerStyle AlwaysVisible="true" />
    <MasterTableView>
        <Columns>
            <telerik:GridBoundColumn DataField="Tiny">
            </telerik:GridBoundColumn>
            <telerik:GridCheckBoxColumn DataField="bitField">
            </telerik:GridCheckBoxColumn>
            <telerik:GridButtonColumn ButtonType="PushButton" UniqueName="Button1">
            </telerik:GridButtonColumn>
        </Columns>
    </MasterTableView>
</telerik:RadGrid>

C#:
protected void RadGrid1_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
    string selectQuery1 = "SELECT  * FROM [BigField]";
    SqlDataAdapter adapter1 = new SqlDataAdapter(selectQuery1, conn);
    conn.Open();
    adapter1.Fill(dt1);
    conn.Close();
    if (dt1.Rows.Count < 10)
    {
        DataRow dr = null;
        for (int i = 0; i <= 10 - dt1.Rows.Count; i++)
        {
            dt1.Rows.Add(new object[] { });
        }
    }
 
    RadGrid1.DataSource = dt1;
}
protected void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
    if (e.Item is GridDataItem)
    {
        GridDataItem dataItem = (GridDataItem)e.Item;
            
        if (dataItem["Tiny"].Text == " ")
        {
            CheckBox check = (CheckBox)dataItem["bitField"].Controls[0];
            Button btn = (Button)dataItem["Button1"].Controls[0];
            check.Visible = false;
            btn.Visible = false;
 
        }
    }
}

Regards,
Princy.
Tags
Grid
Asked by
Fenil
Top achievements
Rank 1
Answers by
Princy
Top achievements
Rank 2
Share this question
or