PROJECT DESCRIPTION
This project shows how to modify the data items from SqlDataSource to add or hide any information to an item. This is similar to using and ItemDataBound server-side event and add some attributes to the item.
protected void Page_Load(object sender, EventArgs e)
{
DataSourceSelectArguments args = new DataSourceSelectArguments();
DataView view = (DataView) SqlDataSource1.Select(args);
DataTable dt = view.ToTable();
RadMultiColumnComboBox1.DataSource = GetModifiedDataSource(dt);
RadMultiColumnComboBox1.DataBind();
}
private DataTable GetModifiedDataSource(DataTable dt)
{
DataTable dataTable = new DataTable();
dataTable.Columns.Add(new DataColumn("ID", typeof(string)));
dataTable.Columns.Add(new DataColumn("Name", typeof(string)));
dataTable.Columns.Add(new DataColumn("Description", typeof(string)));
dataTable.Columns.Add(new DataColumn("Title", typeof(string)));
dataTable.PrimaryKey = new DataColumn[] { dataTable.Columns["ID"] };
var rowsCount = dt.Rows.Count;
for (int i = 0; i < rowsCount; i++)
{
DataRow dataRow = dt.Rows[i];
DataRow row = dataTable.NewRow();
row["ID"] = dataRow["CustomerID"];
row["Name"] = dataRow["ContactName"];
row["Description"] = dataRow["ContactName"] + " from " + dataRow["CompanyName"];
row["Title"] = dataRow["ContactTitle"];
dataTable.Rows.Add(row);
}
return dataTable;
}