Binding Data to a DataGrid

RPG SEARCH · August 8th, 2004, 08:48 AM

Hi There,

I have the problem of in my datagrid i have named the columns and set where i want the data to be displayed... but it displays all the information twice once under my headings and the second time under the database field names. have i set something wrong, i tried working it out with the beginners guide but i cant seem to work it out.

<%@ Page Language="VB" %>
<script runat="server">

    'This binds the data from the messages to the datagrid

    Sub Page_Load()

        GridMessages.DataSource = GetMessages
        GridMessages.DataBind()

    End Sub

        'This gets all the message details from the database

        Function GetMessages() As System.Data.DataSet
            Dim connectionString As String = ConfigurationSettings.AppSettings("connectionStrin g")
            Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString )

            Dim queryString As String = "SELECT [Messages].[MessageID], [Messages].[GuestName], [Messages].[GuestEmail], ["& _
    "Messages].[GuestURL], [Messages].[GuestMessage] FROM [Messages]"
            Dim dbCommand As System.Data.IDbCommand = New System.Data.OleDb.OleDbCommand
            dbCommand.CommandText = queryString
            dbCommand.Connection = dbConnection

            Dim dataAdapter As System.Data.IDbDataAdapter = New System.Data.OleDb.OleDbDataAdapter
            dataAdapter.SelectCommand = dbCommand
            Dim dataSet As System.Data.DataSet = New System.Data.DataSet
            dataAdapter.Fill(dataSet)

            Return dataSet
        End Function

</script>
<html>
<head>
    <link href="includes/stylesheet.css" type="text/css" rel="stylesheet" />
</head>
<body>
    <form runat="server">
        <p align="center">
            <img height="60" src="images/logo.jpg" width="468" />
        </p>
        <p align="center">
            Sign Guest Book | View Guest Book
        </p>
        <p align="center">
            <table cellspacing="0" cellpadding="0" width="600" border="0">
                <tbody>
                    <tr>
                        <td width="600">
                            <asp:DataGrid id="GridMessages" runat="server" CssClass="GridMessages" Width="827px" AllowPaging="True" CellSpacing="-1" BorderWidth="1px" BorderColor="Black" CellPadding="2">
                                <FooterStyle borderwidth="1px" borderstyle="Solid" bordercolor="Black" backcolor="Blue"></FooterStyle>
                                <HeaderStyle horizontalalign="Left" borderwidth="1px" borderstyle="Solid" bordercolor="Black" verticalalign="Top" backcolor="DarkGray"></HeaderStyle>
                                <AlternatingItemStyle borderwidth="1px" borderstyle="Solid" bordercolor="Black" backcolor="#E0E0E0"></AlternatingItemStyle>
                                <Columns>
                                    <asp:TemplateColumn HeaderText="Name">
                                        <ItemTemplate>
                                            <%# Container.DataItem("GuestName") %>
                                        </ItemTemplate>
                                    </asp:TemplateColumn>
                                    <asp:TemplateColumn HeaderText="Email">
                                        <ItemTemplate>
                                            <%# Container.DataItem("GuestURL") %>
                                        </ItemTemplate>
                                    </asp:TemplateColumn>
                                    <asp:TemplateColumn HeaderText="Homepage">
                                        <ItemTemplate>
                                            <%# Container.DataItem("GuestEmail") %>
                                        </ItemTemplate>
                                    </asp:TemplateColumn>
                                    <asp:TemplateColumn HeaderText="Message">
                                        <ItemTemplate>
                                            <%# Container.DataItem("GuestMessage") %>
                                        </ItemTemplate>
                                    </asp:TemplateColumn>
                                </Columns>
                            </asp:DataGrid>
                        </td>
                    </tr>
                </tbody>
            </table>
        </p>
    </form>
</body>
</html>

Cheers

David

planoie · August 8th, 2004, 09:32 AM

You need to add AutoGenerateColumns="False" to the datagrid markup.

<asp:DataGrid id="GridMessages" runat="server" CssClass="GridMessages" Width="827px" AllowPaging="True" CellSpacing="-1" BorderWidth="1px" BorderColor="Black" CellPadding="2" AutoGenerateColumns="False">

RPG SEARCH · August 8th, 2004, 10:14 AM

Hi there,

Thanks for that! I wanted to specify the width of each column and the valign of each of each column. I have tried putting these into various parts of the code but it generates errors. Is it possible?

Cheers for you help.

David

planoie · August 9th, 2004, 09:05 AM

Within the column definitions (e.g.: <asp:boundcolumn...) you can specify the width:

itemstyle-width="100"

However as is always the case with HTML, explicit widths on table cells can be problematic.

RPG SEARCH · August 9th, 2004, 11:47 AM

its an <asp:itemtemplate> column and it says that width is not an attribute for it. i tried it in the <itemtemplate> tag as well with no results. *sigh*

David

planoie · August 9th, 2004, 02:27 PM

it's not "width", it's "itemstyle-width". (original reply of mine was wrapped at the "-")