search in grid view error

Question

0.00/5 (No votes)

See more:

I have used a databinder in grid view in asp.net.. In addition to it, i have used search box that search for a record from grid(grdOffice).. the databinder works fine when user views the grid view.. but as user search the content in the grid view, an error rises ...

the databinder tag is:

<asp:Label ID="lblProfile" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.genderName") %>'>

c# code for data bound when user enters a text and click on search is..

C#

grdOffice.DataSourceID = string.Empty;
       grdOffice.DataSource = searchOfficeName;
       grdOffice.DataBind();

the error i get is: "DataBinding: '.DAL.Profile' does not contain a property with the name 'gender'."

I have gender id attribute in table Profile and i pertain to bring genderName (that contains male and female) of gender table in grid view of Profile table based upon gender id.

When I am binding grdOffice,, i cannot bind in DataBinder.Eval

Any help??

Posted 3-Oct-13 1:44am

Codes DeCodes

Updated 3-Oct-13 19:13pm

v3

Add a Solution

Comments

Kamran Ajmal 3-Oct-13 7:47am

You can not call the GenderName directly as you are binding with table that contains only genderID not gender Name, Which data type you are using to bind the Grid, I mean, Entity Frame work, Linq, Store Procudure ?

Codes DeCodes 4-Oct-13 0:24am

kamran i am using linq..

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

JoCodes · Answer 1 · 2013-10-03T07:23:00

Solution 1

The error clearly shows that you have no gender name property bound . Check whether your DAL fetches you the GenderName property too

Posted 3-Oct-13 7:23am

JoCodes

Comments

Codes DeCodes 4-Oct-13 0:23am

I have already done that.. DAL fetches gendername property. as mentioned in question the grid works well before search is done means DAL is fetching gendername property..

Ajay_Saini · Answer 2 · 2013-10-03T07:25:00

please check that in your DataSource genderNams available or not. If not then you can't use this for databinding in gridview. further if you want to display genderName on behalf of gender id then i have a solution for you which you can use easily as :
<asp:label Id="lblProfile" runat="server" Text='<%#(Convert.ToString(Eval("genderId"))==1?Male:Female) %>'>

means if genderId is 1 then lable lblProfile shows Male else Female