Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 961
  • Last Modified:

Empty Datagrid

How do i show and empty datagrid.

i need to show its header but the rows will be empty? Rows will be added dynamically

First thing First.
Can some one show me how to create a datagrid just to show its headers....i dont want to bind it to any db datasource

0
AsishRaj
Asked:
AsishRaj
  • 4
  • 3
1 Solution
 
nmarunCommented:
It turns out you need to do some kind of data binding to show the datagrid only with headers.

// aspx page
<asp:DataGrid ID="dgTest" runat="server" AutoGenerateColumns="false">
    <Columns>
        <asp:TemplateColumn>
            <HeaderTemplate>
                Header 1 
            </HeaderTemplate>
        </asp:TemplateColumn>
        <asp:TemplateColumn>
            <HeaderTemplate>
                Header 2
            </HeaderTemplate>
        </asp:TemplateColumn>
        <asp:TemplateColumn>
            <HeaderTemplate>
                Header 3 
            </HeaderTemplate>
        </asp:TemplateColumn>
        <asp:TemplateColumn>
            <HeaderTemplate>
                Header 4 
            </HeaderTemplate>
        </asp:TemplateColumn>
        <asp:TemplateColumn>
            <HeaderTemplate>
                Header 5 
            </HeaderTemplate>
        </asp:TemplateColumn>
    </Columns>
</asp:DataGrid>
 
// code-behind page:
DataTable dt = new DataTable();
dt.Rows.Add(dt.NewRow());
dgTest.DataSource = dt;
dgTest.DataBind();

Open in new window

0
 
AsishRajAuthor Commented:
yeap that work great.

One simple Question
Now how do i insert a new row when a button is clicked
0
 
nmarunCommented:
>>'insert a new row'
Do you mean you need textboxes to show up so the user can add data?
or
Do you mean that the user has entered data through some other GUI and you want to that data in the grid?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
AsishRajAuthor Commented:
>>Do you mean you need textboxes to show up so the user can add data?

Yes. Finally i think i have met the real Guru
0
 
nmarunCommented:
You can do that in a few ways. Using a panel containing the fields is one way:

<asp:DataGrid ID="dgTest" runat="server" AutoGenerateColumns="false">
    <Columns>
        <asp:TemplateColumn>
            <HeaderTemplate>
                Header 1 
            </HeaderTemplate>
        </asp:TemplateColumn>
        <asp:TemplateColumn>
            <HeaderTemplate>
                Header 2
            </HeaderTemplate>
        </asp:TemplateColumn>
        <asp:TemplateColumn>
            <HeaderTemplate>
                Header 3 
            </HeaderTemplate>
        </asp:TemplateColumn>
        <asp:TemplateColumn>
            <HeaderTemplate>
                Header 4 
            </HeaderTemplate>
        </asp:TemplateColumn>
        <asp:TemplateColumn>
            <HeaderTemplate>
                Header 5 
            </HeaderTemplate>
        </asp:TemplateColumn>
    </Columns>
</asp:DataGrid>
<asp:Button ID="btnShowAdd" runat="server" onclick="btnShowAdd_Click" Text="Add" />
<br />
<asp:Panel ID="pnlTest" runat="server">
    <table>
        <tr>
            <td>
                <asp:TextBox ID="txtBox1" runat="server" Width="50px" />
            </td>
            <td>
                <asp:TextBox ID="txtBox2" runat="server" Width="50px" />
            </td>
            <td>
                <asp:TextBox ID="txtBox3" runat="server" Width="50px" />
            </td>
            <td>
                <asp:TextBox ID="txtBox4" runat="server" Width="50px" />
            </td>
            <td>
                <asp:TextBox ID="txtBox5" runat="server" Width="50px" />
            </td>
            <td>
                <asp:Button ID="btnSave" runat="server" Text="Save"/>
            </td>
        </tr>
    </table>
</asp:Panel>
 
// code-behind
protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        pnlTest.Visible = false;
        DataTable dt = new DataTable();
        dt.Rows.Add(dt.NewRow());
        dgTest.DataSource = dt;
        dgTest.DataBind();
    }
}
 
protected void btnShowAdd_Click(object sender, EventArgs e)
{
    pnlTest.Visible = true;
}

Open in new window

0
 
AsishRajAuthor Commented:
can we insert a new row in the datagrid when the button is clicked.

this what i have so far

 Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Not IsPostBack Then
            ' Generate rows and cells.           
            Dim dt As New DataTable()
            dt.Rows.Add(dt.NewRow())
            dgTest.DataSource = dt
            dgTest.DataBind()
        End If
    End Sub
 
    Protected Sub dgTest_ItemCreated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles dgTest.ItemCreated
        If e.Item.ItemType = ListItemType.EditItem Then
            Dim e1 As TextBox = DirectCast(e.Item.FindControl("TextBox3"), TextBox)
            e1.Width = Unit.Parse("75px")
            e1 = DirectCast(e.Item.FindControl("TextBox2"), TextBox)
            e1.Width = Unit.Parse("75px")
            e1 = DirectCast(e.Item.FindControl("TextBox1"), TextBox)
            e1.Width = Unit.Parse("75px")
        End If
    End Sub
 Sub doEdit(ByVal sender As Object, ByVal e As DataGridCommandEventArgs)
        dgTest.ShowFooter = False
        dgTest.EditItemIndex = e.Item.ItemIndex
        BindData()
    End Sub
 
    Sub doCancel(ByVal sender As Object, ByVal e As DataGridCommandEventArgs)
        dgTest.ShowFooter = True
        dgTest.EditItemIndex = -1
        BindData()
    End Sub
 
    Sub doInsert(ByVal sender As Object, ByVal e As DataGridCommandEventArgs)
'add a new row to datagrid
 
    End Sub
 
aspx
 
<asp:DataGrid ID="dgTest" runat="server" AutoGenerateColumns="false" BorderColor="White" BorderStyle="Solid" BorderWidth="2px" 
    CellPadding="3" CellSpacing="1" Font-Names="Tahoma" Font-Size="Small" 
    HorizontalAlign="Center"  ShowFooter="True"
    OnEditCommand ="doEdit" OnCancelCommand="doCancel" >
    <FooterStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" 
        Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Center" />
    <Columns>
        <asp:TemplateColumn>
            <EditItemTemplate>
                <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="Shop" 
                    DataTextField="ShopName" DataValueField="ShopCode">
                </asp:DropDownList>
                <asp:SqlDataSource ID="Shop" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:eTFSConnectionString %>" 
                    SelectCommand="SELECT * FROM [DEFShops]"></asp:SqlDataSource>
            </EditItemTemplate>
            <HeaderTemplate>
                Shop Name 
            </HeaderTemplate>
            <ItemTemplate>
                <asp:Label ID="Label2" runat="server" Text="Label"></asp:Label>
            </ItemTemplate>
        </asp:TemplateColumn>
        <asp:TemplateColumn>
            <EditItemTemplate>
                <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
            </EditItemTemplate>
            <HeaderTemplate>
                Docket Number
            </HeaderTemplate>
            <ItemTemplate>
                <asp:Label ID="Label3" runat="server" Text="Label"></asp:Label>
            </ItemTemplate>
        </asp:TemplateColumn>
        <asp:TemplateColumn>
            <EditItemTemplate>
                <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
            </EditItemTemplate>
            <HeaderTemplate>
                Docket Total
            </HeaderTemplate>
            <ItemTemplate>
                <asp:Label ID="Label4" runat="server" Text="Label"></asp:Label>
            </ItemTemplate>
        </asp:TemplateColumn>
        <asp:TemplateColumn>
            <EditItemTemplate>
                <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
            </EditItemTemplate>
            <HeaderTemplate>
                Docket Date
            </HeaderTemplate>
            <ItemTemplate>
                <asp:Label ID="Label5" runat="server" Text="Label"></asp:Label>
            </ItemTemplate>
        </asp:TemplateColumn>
         <asp:EditCommandColumn
	     ButtonType="PushButton" UpdateText="Update" CancelText="Cancel"
	     EditText="Edit" HeaderText="Edit">
      </asp:EditCommandColumn>
        <asp:TemplateColumn HeaderText="Delete">
        <FooterTemplate>
          <asp:Button CommandName="Insert" Text="Add" ID="btnAdd" Runat="server" OnClick="AddRow" />
        </FooterTemplate>
        <ItemTemplate>
          <asp:Button CommandName="Delete" Text="Delete" ID="btnDel" Runat="server" />
        </ItemTemplate>
      </asp:TemplateColumn>
 
    </Columns>
    <HeaderStyle BackColor="#3366CC" Font-Bold="False" Font-Italic="False" 
                                                    Font-Names="Tahoma" Font-Overline="False" Font-Size="Small" 
                                                    Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Center" 
                                                    ForeColor="White" />
</asp:DataGrid>

Open in new window

0
 
nmarunCommented:
Ashish,

I'd like to keep issues small and simple. The previous request of yours seems to be going out of the scope of this ticket. It's just easier for someone who sees this issue to understand what was requested and how it was solved when they see tickets with predefined scope.

Please open another ticket, explain what it is that you are doing there and I'm sure you'll find many other 'Gurus' in this discussion site.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now