DataList Question

khng · April 18th, 2005, 08:51 PM

Is that possible to add a <asp:button> to use as itemtemplate of datalist control, so when user click on that button ASP.NET can know which record does the user clicking on.

If possible, please let me know how to implements in

For question asking, please made sure that your question is as similar as possible while providing enought level of details!
Since not all peoples, like to read large amounts of text just for reading or requirement and waste the answer time to read your text

r_ganesh76 · April 19th, 2005, 06:02 AM

Hope this helps

Code:

<%@ Page Language="C#" %>
<script runat="server">
    System.Data.DataSet GetAuthors()
    {
        string connectionString = "server=\'(local)\'; user id=\'uid\'; password=\'pwd\'; database=\'pubs\'";
        System.Data.IDbConnection dbConnection = new System.Data.SqlClient.SqlConnection(connectionString);

        string queryString = "SELECT [authors].[au_lname], [authors].[au_id] FROM [authors]";
        System.Data.IDbCommand dbCommand = new System.Data.SqlClient.SqlCommand();
        dbCommand.CommandText = queryString;
        dbCommand.Connection = dbConnection;

        System.Data.IDbDataAdapter dataAdapter = new System.Data.SqlClient.SqlDataAdapter();
        dataAdapter.SelectCommand = dbCommand;
        System.Data.DataSet dataSet = new System.Data.DataSet();
        dataAdapter.Fill(dataSet);

        return dataSet;
    }

    void Page_Load(object sender, EventArgs e)
    {
        dlAuthors.DataSource = GetAuthors();
        dlAuthors.DataBind();
    }

    void cmdClick_Command(object sender, CommandEventArgs e)
    {
        lblSelected.Text = e.CommandArgument.ToString();
    }

</script>
<html>
<head>
</head>
<body>
    <form runat="server">
        <table>
            <tr>
                <td>
                    <asp:Label id="lblSelected" runat="server" forecolor="Red">Select From List</asp:Label></td>
            </tr>
            <tr>
                <td>
                    <asp:DataList id="dlAuthors" runat="server" BorderStyle="None" GridLines="Both" BorderWidth="1px" BorderColor="#CC9966" BackColor="White" CellPadding="4">
                        <ItemStyle forecolor="#330099" backcolor="White"></ItemStyle>
                        <FooterStyle forecolor="#330099" backcolor="#FFFFCC"></FooterStyle>
                        <HeaderStyle font-bold="True" forecolor="#FFFFCC" backcolor="#990000"></HeaderStyle>
                        <SelectedItemStyle font-bold="True" forecolor="#663399" backcolor="#FFCC66"></SelectedItemStyle>
                        <ItemTemplate>
                            <asp:button id="cmdClick" OnCommand="cmdClick_Command" Text="Select" runat="server" CommandArgument='<%# DataBinder.Eval(Container.DataItem, "au_lname") %>'></asp:button>
                            &nbsp;<asp:Label id="Label1" runat="server" text='<%# DataBinder.Eval(Container.DataItem, "au_lname") %>'></asp:Label>
                        </ItemTemplate>
                    </asp:DataList>
                </td>
            </tr>
        </table>
    </form>
</body>
</html>

Regards
Ganesh