Multi Column from Simple DataTable

[Christian]

Hi,

I'd like to populate a multicolumn combobox from a datatable, however the examples only seem to show how to do this using the SessionDataSource item. How would I do this with just  simple datatable?

Cheers,
Christian

[Shinu]

Hello Christian,

Check the following code library which expalins more about this.
Dynamic Multi-Column Template

-Shinu.

[Christian]

Ah, ok, I did see this - I had hoped there would be a simpler way :)

[Cat Cheshire]

You can use combobox attributes:

<telerik:RadComboBox ID="RadComboBox1" runat="server"
    DropDownWidth="330px">
    <ItemTemplate>
        <%# DataBinder.Eval(Container, "Value")%>
        <%# DataBinder.Eval(Container, "Text")%>
        <%# DataBinder.Eval(Container, "Attributes['Address']")%>
    </ItemTemplate>
</telerik:RadComboBox>

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        DataTable data = CreateDataSource();
        for (int i = 0; i < data.Rows.Count; i++)
        {
            RadComboBoxItem item = new RadComboBoxItem();
            item.Text = data.Rows[i]["Name"].ToString();
            item.Value = data.Rows[i]["ID"].ToString();
            item.Attributes.Add("Address", data.Rows[i]["Address"].ToString());

            RadComboBox1.Items.Add(item);
            item.DataBind();
        }
    }
}

protected DataTable CreateDataSource()
{
    DataTable dt = new DataTable();
    dt.Columns.Add(new DataColumn("ID", typeof(string)));
    dt.Columns.Add(new DataColumn("Name", typeof(string)));
    dt.Columns.Add(new DataColumn("Address", typeof(string)));


    DataRow dr = dt.NewRow();
    dr["ID"] = "1";
    dr["Name"] = "Name 1";
    dr["Address"] = "Address 1";
    dt.Rows.Add(dr);

    DataRow dr2 = dt.NewRow();
    dr2["ID"] = "2";
    dr2["Name"] = "Name 2";
    dr2["Address"] = "Address 2";
    dt.Rows.Add(dr2);

    DataRow dr3 = dt.NewRow();
    dr3["ID"] = "3";
    dr3["Name"] = "Name 3";
    dr3["Address"] = "Address 3";
    dt.Rows.Add(dr3);

    return dt;

}

[Christian]

This is what I was looking for, thanks.