Error "Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."

I am trying to dynamically bind to a repeater. The code below shows both my codebehind and my ASPX page.

To give you some background as to why I am doing it this way is because when I try to statically place the Datasource on the page. I cannot pass the variable that I need to the datasource

The query being this "SELECT resume_file_size, resume_file_type, resume_name, date_uploaded, resume_file_name, viewedcount FROM resumes WHERE (uid = @uid)",

the @uid is actually the GUID that is provided to the user. when I try to pass that to a static Datasource as through a querystring or session variable it treats it as a string and prevents it from being used as a comparison to a GUID. so I thought of doing it the way I have it down below.

Over all if someone can tell me how to do it my initial way please do. But if not can someone explain how to fix the way I have it below?

Error "Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."

protected void Page_Load(object sender, EventArgs e)

{

string uname = Page.User.Identity.Name;

MembershipUser user = Membership.GetUser(uname);

if (uname != "")

{

Guid userId = (Guid)user.ProviderUserKey;

SqlConnection cnn = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\jobs.mdf;Integrated Security=True;User Instance=True");

SqlDataAdapter da = new SqlDataAdapter("SELECT resume_file_size, resume_file_type, resume_name, date_uploaded, resume_file_name, viewedcount FROM resumes WHERE (uid = @uid)", cnn);

da.SelectCommand.Parameters.Add("@uid", SqlDbType.UniqueIdentifier).Value = userId;

DataSet ds = new DataSet();

da.Fill(ds, "resumes");

Repeater1.DataSource = ds.Tables["resumes"];

Repeater1.DataBind();

}

}

<asp:Repeater ID="Repeater1" runat="server">

<tr>

<td colspan=3>

Your Resumes currently on our system.

</td>

</tr>

</HeaderTemplate>

<tr>

<td align=left>

<% Eval("resume_file_name"); %>

</td>

<td align=right>

Last Updated: <% Eval("date_uploaded"); %>

</td>

Re: Error "Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."

I wouldn't suggest doing it this way, but for the sake of brevity for you, the solution to this problem is to change your code from <% Eval("date_uploaded"); %> to <%# Eval("date_uploaded") %>. The <% %> syntax is effectively a wrapper for Response.Write, so it doesn't allow the use of Eval, XPath, or Bind. The <%# %> syntax is only called when the parent control is being data bound, therefore it allows Eval.

Re: Error "Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."

Your suggestion worked for that specific issue Thank you for that.

but after running into that I came up with a much larger issue.

With the repeater I do not have delete,Update options... This is the reason I initially wanted to go with either a gridview or Details view but the problem I had with that is when I create the sql query to pull the info from the database I need to use the Uniqueidentifier field for a comparison. The problem I am having with that is the SQLDataSource does not allow for the UniqueIdentifier to be used. It keeps telling me something to the extent of.. "Cannot cast UniqueIdentifier as String"

Do you know how I can use a Gridview or Detailsview with using a uniqueIdentifier as a comparison in the SQL Query?

I hope that makes sense.....

Re: Error "Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."

Disregard that last message I figured out how to allow a gridview

SqlConnection cn = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\jobs.mdf;Integrated Security=True;User Instance=True");

SqlDataAdapter SQLda = new SqlDataAdapter("SELECT date_uploaded, resume_name, viewedcount FROM resumes WHERE (uid = @uid)", cn);

SQLda.SelectCommand.Parameters.Add("@uid", SqlDbType.UniqueIdentifier).Value = userId;

DataSet SQLds = new DataSet();

SQLda.Fill(SQLds, "resumes");

GridView1.DataSource = SQLds.Tables["resumes"];

GridView1.DataBind();

Re: Error "Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."

When I wanted to relate two dropdown list , I got same errors ....Then I tried using using usercontrol for the related dropdownlist and added this user control to details view and binded the public properties of user control in html . Things work fine....

You can get detailed writeup in http://aspdotnetprojects.googlepages.com/home

Feedback appreciated

Bhat Np

MCAD

bhatnp@gmail.com/bhatnp@yahoo.com

Re: Error "Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."

Bhat:

I have run into the same error with two dropdownlists in a fromview. After going through your solution on the URL you reference, I couldn't determine where to add the code in my application to get and set the properties you describe, step 5, does this go in a new class, the .ascx file codebehind, where?

Add two public properties for country and city

(For ex Public Property country() As String

Get

Return CountryDropDownList.SelectedValue

End Get

Set(ByVal value As String)

countryDropDownList.SelectedValue = value

End Set

End Property)

Thank you for your help!

Re: Error "Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."

Bhat:

In my code, I added the set and get property code to the code behind page of the control, Is this correct?

Now the control shows up in my form view edititem template but I'm not clear on how you bind to the control. In my case. The control has two dropdownlists as you described in the example. If I click on the smart tag and click edit databindings how do I bind to BOTH the city and country? Can you add more than one field in a binding as your example seems to state?

Thank you for your help.

Re: Error "Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."

go to html view and in UCL tag set the 2 public properties <%bind syntax

Re: Error "Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."

<div style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">Bhat:</div> <div style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </div> <div style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">Thanks for your reply and assistance. I think I'm doing everything you have described but I must not be binding the user control correctly. Correct me if I'm wrong but the user control can only be bound to one field? The user control created has two fields, city and country?</div> <div style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </div> <div style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">Is there a way to bind both? My normal binding for each would be <%# bind("country") %> <%# bind("city") %></div> <div style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </div> <div style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">In my webform, I'm using two fields, Contractor and JobTitle. The various contractors can have several to no child job titles. The same type of parent, child relationship as country and city.</div> <div style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </div> <div style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">Here is the code I'm using...</div> <div style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </div> <div style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">This is the user control.... DisplayJobTitle.ascx </div> <div style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">

<%@ Control Language="C#" ClassName="JobTitles" AutoEventWireup="true" CodeFile="DisplayJobTitle.ascx.cs" Inherits="DisplayJobTitle" %>


<asp:DropDownList ID="ddl_Contractors" runat="server" DataSourceID="ods_Contractors"


DataTextField="ShortDescription" DataValueField="ContractorID" AutoPostBack="True">


</asp:DropDownList>


/


<asp:DropDownList ID="ddl_JobTitles" runat="server" DataSourceID="ods_JobTitles"


DataTextField="JobTitle" DataValueField="JobTitleID">


</asp:DropDownList><asp:ObjectDataSource ID="ods_JobTitles" runat="server" OldValuesParameterFormatString="original_{0}"


SelectMethod="GetJobTitlesByContractorID" TypeName="BMSDataSetTableAdapters.JobTitlesTableAdapter">


<SelectParameters>


<asp:ControlParameter ControlID="ddl_Contractors" Name="contractorID" PropertyName="SelectedValue"


Type="Decimal" />


</SelectParameters>


</asp:ObjectDataSource>


<asp:ObjectDataSource ID="ods_Contractors" runat="server" OldValuesParameterFormatString="original_{0}"


SelectMethod="GetContractors" TypeName="BMSDataSetTableAdapters.ContractorsTableAdapter">


</asp:ObjectDataSource>

This is the user control code behind page.... DisplayJobTitle ascx.cs </div> <div style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class DisplayJobTitle : System.Web.UI.UserControl
{
    public string contractor
    {
        get
        {
            return ddl_Contractors.SelectedValue.ToString();

        }
        set
        {
            ddl_Contractors.SelectedValue = value;           
        }
    }

    public string jobTitle
    {
        get
        {
            return ddl_JobTitles.SelectedValue.ToString();

        }
        set
        {
            ddl_JobTitles.SelectedValue = value;            
        }
    }


}

This is formview within an edititemtemplate on my webform that is trying to do the cascadding dropdown and be bound....Staff_Edit.aspx</div> <div style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </div> <div style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">

<asp:FormView ID="FormView_Descriptors" DataKeyNames="profileid" runat="server" DataSourceID="ods_Staff_Descriptors"

DefaultMode="Edit" OnItemCreated="FormView_Descriptors_ItemCreated" OnItemUpdated="FormView_Descriptors_ItemUpdated">

<EditItemTemplate>

Company/Title: 

<uc1:DisplayJobTitle ID="DisplayJobTitle1" runat="server" Visible='<%# Bind("contractorID") %>' />


<asp:Button ID="btn_UpdateDescriptors" runat="server" CommandName="Update" Text="Save" /> 
</EditItemTemplate>

</asp:FormView>

I get this Error: InvalidCastException was unhandled by user code. Specified cast is not valid</div> <div style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </div> <div style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">ERROR is from this line.. <uc1:DisplayJobTitle ID="DisplayJobTitle1" runat="server" Visible='<%# Bind("contractorID") %>' />.. the usercontrol in the webform</div> <div style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </div> <div style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">I would assume it's because the binding isn't working...?</div> <div style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </div>

Re: Error "Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."

When you say "HTML" view do you mean the Source view in Visual Studio?

I tried binding the two dropdownlists in the user control. ( see code below) but still get the... Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control, ERROR.

Is this how you were suggesting to bind the fields?

<%@ Control Language="C#" ClassName="JobTitles"  AutoEventWireup="true" CodeFile="DisplayJobTitle.ascx.cs" Inherits="DisplayJobTitle" %>
<asp:DropDownList ID="ddl_Contractors" runat="server" DataSourceID="ods_Contractors"
    DataTextField="ShortDescription" DataValueField="ContractorID" SelectedValue='<%# Bind("ContractorID") %>' AutoPostBack="True">
</asp:DropDownList>
/
<asp:DropDownList ID="ddl_JobTitles" runat="server" DataSourceID="ods_JobTitles"
    DataTextField="JobTitle" DataValueField="JobTitleID" SelectedValue='<%# Bind("JobTitleID") %>'>
</asp:DropDownList><asp:ObjectDataSource ID="ods_JobTitles" runat="server" OldValuesParameterFormatString="original_{0}"
    SelectMethod="GetJobTitlesByContractorID" TypeName="BMSDataSetTableAdapters.JobTitlesTableAdapter">
    <SelectParameters>
        <asp:ControlParameter ControlID="ddl_Contractors" Name="contractorID" PropertyName="SelectedValue" Type="Decimal" />
    </SelectParameters>
</asp:ObjectDataSource>
<asp:ObjectDataSource ID="ods_Contractors" runat="server" OldValuesParameterFormatString="original_{0}"
    SelectMethod="GetContractors" TypeName="BMSDataSetTableAdapters.ContractorsTableAdapter">
</asp:ObjectDataSource>

Re: Error "Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."

Can anyone or Bhat give me and example of binding the two public properties to the UC1 tag?

Here is my user control tag..

Re: Error "Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."

Can anyone or Bhat give me and example of setting the two public properties to the UC1 tag?

Here is my user control tag..

<uc1:DisplayJobTitle ID="DisplayJobTitle1" runat="server" />

Is this the same as binding, I don't understand what you mean?

Re: Error "Data binding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."

There are three items I wanted to point out that Bhat doesn't mation on his solution on the website above.

1. In the code behind page where you set the user control properties, you must import the namespace System.ComponetModel...

using System.ComponentModel;

2. You must set the two properties to Bindable true...

[Bindable(true)]
  public string Contractor
    {
        get
        {
            return ddl_Contractors.SelectedValue.ToString();


        }
        set
        {
            ddl_Contractors.SelectedValue = value;
        }
    }

3. The properties DO NOT get picked up in the binding wizard, to bind the two properties you must go to source view of the user control tag and type in the property name and do the bind by hand code. In my case the first property is Contractor and the second property is Subtitled. Like so...

<uc1:DisplayJobTitle ID="DisplayJobTitle1" Contractor='<%# Bind("contractors") %>' JobTitle='<%# Bind("Subtitled") %>' runat="server" />

Hopefully Bhat will update his example to include these three items for a more conclusive solution example.

Re: Error "Data binding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."

Thanks ..

properties for the user control is as under in user control

<System.ComponentModel.DesignerSerializationVisibility(ComponentModel.DesignerSerializationVisibility.Visible), System.ComponentModel.Bindable(True), System.ComponentModel.Browsable(True), System.ComponentModel.SettingsBindable(True)> _

Public Property Equipmenttype() As String

Get

Return EquipmemtTypeDropDownList.SelectedValue

End Get

Set(ByVal value As String)

EquipmemtTypeDropDownList.SelectedValue = value

End Set

End Property

<System.ComponentModel.Bindable(True), System.ComponentModel.Browsable(True)> _

Public Property equipmentModel() As String

Get

Return EquipmentModelDropDownList.SelectedValue

End Get

Set(ByVal value As String)

EquipmentModelDropDownList.SelectedValue = value

End Set

End Property

When you used the user control in main aspx page , you have to bind the user control's properties in the following way

<asp:TemplateField HeaderText="Equipment Data">

<uc1:EquipmentUserControl ID="EquipmentUserControl1" Equipmenttype='<%# bind("EquipmentType") %>' equipmentModel='<%# bind("Equipmentname") %>' runat="server" />

</InsertItemTemplate>

</asp:TemplateField>

Sorry for delay in replying........

Regards

bhat

Re: Error "Data binding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."

This thread saved my life!!!! I was fighting with this problem for over a month!!!!

Thank you all!

Re: Error "Data binding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."

Yes I would like to second that... Thank you! I just ran into this same exact problem and had already wasted several hours trying to come up with a solution. This worked like a charm and took about 10 minutes to implement.

Re: Error "Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."

Hello There,

From this Post i have Found that for error Error "Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control." has a Second cause also First Cause I have Discuss and Solved you Can find it by following link.Please Share Other cause and Solution there.Thank you

http://dotnet-magic.blogspot.com/2009/04/databinding-method-such-as-evalxpath.html

Re: Error "Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."

<p>

I got this post very helpful

<asp:Repeater ID="postCategoryRepeater" runat="server" DataSourceID="postCategoryDataSource">

<asp:Repeater ID="postRepeater" runat="server" DataSource='<%# DataBinder.Eval(Container.DataItem, "PostCollection") %>'>

Test

</ItemTemplate>

</asp:Repeater>

</ItemTemplate>

</asp:Repeater>

<data:PostCategoryDataSource ID="postCategoryDataSource" runat="server" SelectMethod="GetAll" EnableDeepLoad="true">

<Types>

<data:PostCategoryProperty Name="PostCollection" />

</Types>

</DeepLoadProperties>

</data:PostCategoryDataSource>

<p>

Re: Error "Data binding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."

I have a different situation. I am using Visual Web Developer 2008 and coding in Visual Basic. My page was working prior to a change that I made to one of the tables that I use in a dropdownlsit.

I change the table so that the ID is alphanumeric and not an integer. I thought I had recompiled and changed all the code. I cannot find why I am now getting this error. Here is my code for the DDL:

<asp:DropDownList ID="ddlLeadType" runat="server" BackColor="LightSalmon"
                                DataSourceID="odsLeadType" DataTextField="LeadType"
                                DataValueField="LeadTypeID" SelectedValue='<%# Bind("LeadType") %>'
                                Width="150px">
                            </asp:DropDownList>

Thanks for your help!!

Re: Error "Data binding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."

I found the solution ...

In the Dataset file, <Dataset>.xsd, it was showing two fields for the lead type. The LeadType was the old field as an integer. The LeadType1 was the new field as a string. Once I changed the LeadType to be a string, then everything worked correctly.

FYI to anyone who might have this situationn.