Binding Variable in asp.net

Question

Problem:

Exception Details: System.Data.EntitySqlException: The query syntax is not valid. Near term '<', line 8, column 16.

Code Behind:

    protected void Page_Load(object sender, EventArgs e)
    {

        int Id = 3;

        Page.DataBind();
    }

project.aspx.cs

<asp:EntityDataSource ID="ProjectEntityDataSource" runat="server" ConnectionString="name=DBEntities" DefaultContainerName="DBEntities" EnableFlattening="False" EntitySetName="projects" Select="it.[Id], it.[ClientId], it.[Name], it.[Description]"
    Where="it.ClientId = <%# Id %> " >
</asp:EntityDataSource>

What i have tried: ASP.NET databinding / getting variables from codebehind

I know it's too easy but i'm not able to figure out where the problem really is why i'm not able to bind the code behind data.Thanks!

शेखर · Accepted Answer · 2013-04-09 07:33:30Z

2

You can take help of the following example In your case

protected void Page_Load(object sender, EventArgs e)
{
     ProjectEntityDataSource.WhereParameters["Username"].DefaultValue ="3";
     Page.DataBind();
}

aspx

<asp:EntityDataSource ID="ProjectEntityDataSource" runat="server"
     ConnectionString="name=DBEntities" DefaultContainerName="DBEntities" 
     EnableFlattening="False" EntitySetName="projects" Select="it.[Id], it.[ClientId], 
     it.[Name], it.[Description]" Where="it.ClientId = @Username">
      <WhereParameters>
        <asp:Parameter Name="Username" Type="String" />
    </WhereParameters>
</asp:EntityDataSource>

edited Apr 9, 2013 at 7:33

answered Apr 9, 2013 at 7:28

शेखर

17.6k14 gold badges64 silver badges123 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nitin Maheshwari · Accepted Answer · 2013-04-09 07:47:40Z

2

<asp:EntityDataSource ID="ProjectEntityDataSource" runat="server" 
    ConnectionString="name=DBEntities" DefaultContainerName="DBEntities" 
    EnableFlattening="False" EnableInsert="True" EnableUpdate="True"      
     EntitySetName="projects" Where="it.ClientId= @Id"  >
    <WhereParameters>
        <asp:QueryStringParameter Name="Id" Type="Int32" QueryStringField="Id" />
    </WhereParameters>
</asp:EntityDataSource>

Try this code.

answered Apr 9, 2013 at 7:47

Nitin Maheshwari

2132 silver badges10 bronze badges

Comments

Amit Singh · Accepted Answer · 2013-04-09 07:31:56Z

1

change like this.....it will work i think...

 Where='<%#"it.ClientId =" + Id.ToString %> '

answered Apr 9, 2013 at 7:31

Amit Singh

8,12922 silver badges30 bronze badges

Collectives™ on Stack Overflow

Binding Variable in asp.net

3 Answers 3

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Linked

Related