This is a migrated thread and some comments may be shown as answers.

RAD Combobox html escape

4 Answers 268 Views

ComboBox

This is a migrated thread and some comments may be shown as answers.

4 Answers, 1 is accepted

answered on 22 Dec 2010, 11:21 AM

Hello Asif,

I suppose you want to set some styles for RadComboBox Items from code behind. Here I am sharing similar code that I tried in my application.

aspx:

<telerik:RadComboBox runat="server" ID="RadComboBox4">

<ItemTemplate>

<%# Eval("Name") %>

</ItemTemplate>

</telerik:RadComboBox>

C#:

protected void Page_Load(object sender, EventArgs e)

{

RadComboBox4.DataSource = CreateDataSource();

RadComboBox4.DataTextField = "Name";

RadComboBox4.DataValueField = "ID";

RadComboBox4.DataBind();

}

protected DataTable CreateDataSource()

{

DataTable dataTable = new DataTable();

dataTable.Columns.Add(new DataColumn("ID", typeof(string)));

dataTable.Columns.Add(new DataColumn("Name", typeof(string)));

DataRow dr = dataTable.NewRow();

dr["ID"] = "1";

dr["Name"] = "name1";

dataTable.Rows.Add(dr);

DataRow dr2 = dataTable.NewRow();

dr2["ID"] = "2";

dr2["Name"] = "name1";

dataTable.Rows.Add(dr2);

DataRow dr3 = dataTable.NewRow();

dr3["ID"] = "3";

dr3["Name"] = "<span style='padding-left:20px'>name3";

dataTable.Rows.Add(dr3);

return dataTable;

}

Please go through the above code and check whether you missed anything. Please feel to share the comments.

Shinu.

answered on 22 Dec 2010, 07:45 PM

Hi,
Thanks for the quick response. Please have a look at my code and tell me what exactly thing I am missing. In my code I am trying to achieve If category has sub category then I am pushing sub category a little bit to achieve a tree structure.

c#
DataTable dt = new DataTable();
DataSet ds;
protected void Page_Load(object sender, EventArgs e)
 {
 dt.Columns.Add("id", typeof(string));
 dt.Columns.Add("categoryName", typeof(string));

 RadComboBoxItem radComboBoxItem = new RadComboBoxItem("", "0");
 radComboBoxItem.Text = "No Category";
 radComboBoxItem.Value = "0";
 SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["sitefinity"].ToString());
 try
 {
 conn.Open();
 SqlCommand command = new SqlCommand("sp_FAQCat", conn);
 command.CommandType = CommandType.StoredProcedure;
 command.ExecuteNonQuery();
 ds = new DataSet();
 SqlDataAdapter adapter = new SqlDataAdapter(command);
 adapter.Fill(ds);
 adapter.Dispose();
 DataRow[] drs = ds.Tables[0].Select("parentCategoryID is NULL", "categoryName");

 for (int i = 0; i < drs.Length; i++)
 {
 DataRow dr = dt.NewRow();
 dr["id"] = drs[i]["ID"].ToString();
 dr["categoryName"] = drs[i]["categoryName"].ToString();

 dt.Rows.Add(dr);

 DataRow[] child_drs = ds.Tables[0].Select("parentCategoryID='" + drs[i]["id"] + "'", "categoryName");
 if (child_drs.Length > 0)
 recuresive(drs[i]["ID"].ToString(), 1);
 }

 selectFAQsCat.DataSource = dt;
 selectFAQsCat.DataTextField = "CategoryName";
 selectFAQsCat.DataValueField = "ID";

 selectFAQsCat.DataBind();
 selectFAQsCat.Items.Insert(0, radComboBoxItem);
}
 catch (Exception ex)
 {
 Response.Write(ex.ToString());
 //throw;
 }
 finally
 {
 conn.Close();
 }
}

protected void recuresive(string parentID, int lvl)
 {
 DataRow[] child_drs = ds.Tables[0].Select("parentCategoryID='" + parentID + "'", "categoryName");
 for (int i = 0; i < child_drs.Length; i++)
 {
 DataRow dr = dt.NewRow();
 dr["ID"] = child_drs[i]["ID"].ToString();
 dr["categoryName"] = "" + child_drs[i]["categoryName"].ToString() + "";
 dt.Rows.Add(dr);

 DataRow[] granchild_drs = ds.Tables[0].Select("parentCategoryID='" + child_drs[i]["id"] + "'", "categoryName");
 if (granchild_drs.Length > 0)
 recuresive(child_drs[i]["ID"].ToString(), lvl + 1);
 }

 }

aspx:

<telerik:radcombobox runat="server" id="selectFAQsCat">
</telerik:radcombobox>