Databinding in a formView.. programmatically

[mac]

hi there.. I am a little confused on how/why some of my ctrls are able to use the SelectedValue = '<%# Bind() %>' and some are not.

The one that can bind is using an ObjectDataSource within the ascx:

 

<telerik:RadComboBox ID="ComboDepartment" runat="server"
DataSourceID="CCentres" DataTextField="CC_desc"
DataValueField="CC_desc" SelectedValue='<%# Bind("department") %>'>
<CollapseAnimation Duration="200" Type="OutQuint" />
</telerik:RadComboBox>

<asp:ObjectDataSource ID="CCentres" runat="server" SelectMethod="GetData" TypeName="CC2TableAdapters.Cost_centresTableAdapter">
<SelectParameters>
<asp:SessionParameter DefaultValue="1" Name="Empid" SessionField="empid" Type="String" />
</SelectParameters>
</asp:ObjectDataSource>

 

the one that is not working is the following 

 

 

 

 

<telerik:RadComboBox ID="ComboStatus" SelectedValue='<%#Bind("status") %>' runat="server">
<CollapseAnimation Duration="200" Type="OutQuint" />
 </telerik:RadComboBox>

 

 

the combo status is being built using the following code from within the formview_onload Event.

 

Protected Sub FormView1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles FormView1.Load

 If FormView1.CurrentMode = FormViewMode.Insert And Not IsPostBack Then

Dim Status As RadComboBox = FormView1.FindControl("ComboStatus")

Status.DataSource = functions.NameValues("status")

Status.Items.Add(New RadComboBoxItem("Select"))

Status.AppendDataBoundItems = True

Status.DataTextField = "Name"

Status.DataValueField = "Value"

Status.DataBind()

end if
End Sub

My preference is to populate the boxes from code but still them bound to the formview.. is this possible? 
thanks
mac 

 

[Princy]

Hello Mac,

When you set the DataSource in the code behind, the SelectedValue for the combobox should be also set in the code behind. A suggestion is to bind a hidden textbox with the same datafield as that of the combobox and then set the selected value of the combobox in the code behind as that of the TextBox text as shown below:
cs:

 protected void FormView2_DataBound(object sender, EventArgs e)
    {
        RadComboBox Status = (RadComboBox)FormView2.FindControl("ComboBoxID");
        Status.DataSourceID = "SqlDataSource5";
        // Status.Items.Add(new RadComboBoxItem("Select"));
        //Status.AppendDataBoundItems = true;
        Status.DataTextField = "Project_Name";
        Status.DataValueField = "Project_ID";
        TextBox txt = (TextBox)FormView2.FindControl("TextBoxID");
        Status.SelectedValue = txt.Text;
        Status.DataBind();
    }

Thanks,
Princy.

[mac]

I must not be understanding you on some level. I am attempting to just do a basic record insertion. I want to databind the selected value of the combobox to my InsertParameter. I know I can get the value at the point of insertion but feel that really should not be necessary.
I have moved the combo population commands into the formview_databound as you have but don't see why I would set the selectedValue of the combo to a blank textbox? Using your code as suggested did allow the page to load but just resulted in a null value being inserted to the recordset. Using the below html/code only results in null values being inserted. is it your suggestion to postback the selected value into the textbox instead? I might as well just grab the selected value at time of insert instead and skip the postback. I was hoping there was a more simplistic approach than adding more objects :)
 

    <telerik:RadComboBox ID="ComboStatus"   runat="server">
            <CollapseAnimation Duration="200" Type="OutQuint" />
        </telerik:RadComboBox>
<asp:TextBox ID="tbstatus" Text='<%#Bind("status") %>' runat="server" />

    Protected Sub FormView1_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles FormView1.DataBound

        Dim Status As RadComboBox = FormView1.FindControl("ComboStatus")
        Status.DataSource = functions.NameValues("status") ' this creates a datatable of values.
        Status.Items.Add(New RadComboBoxItem("Select"))
        Status.AppendDataBoundItems = True
        Status.DataTextField = "Name"
        Status.DataValueField = "Value"
Status.SelectedValue = TryCast(FormView1.FindControl("tbstatus"), TextBox).Text
        Status.DataBind()

    End Sub

[Veselin Vasilev]

Hello mac,

The problem seems to be caused by having DataValueField bound to the "Value" column while SelectedValue bound to the "status" column. They both need to be bound to one and the same column.

Sincerely yours,
Veselin Vasilev
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.