OpenaccessDatasource Query: Combining two fields and populate combo box

[Gerrit du Preez]

Hi there

I am using an OpenAccessDatasource and want to select two fields (Firsname and Surname) and combine them into one to populate a cobo box.

In other words: In my database I have a field for Firstname and one for Surname.  I want to populate a combobox with values where these two are joined together  to display the name and surname in the drop down list. 

How can this be achieved by using the OpenAccessDatasource?  I want to use this approach as well in the RadScheduler and would like to run the query in my aspx page and not from the code behind.

Thank you

Gerrit

[IT-Als]

Hi Gerrit,

One way it can be solved is to introduce a transient read only property on your class (for example the class Person) and have this property getter combine the firstname and surname field to return the full name, like this:

public class Person
{
  // Persistent fields
  string firstname;
  string surname;

  // Properties for firstname and lastname fields not shown for clarity

  // The readonly getter to combine the name
  string Fullname
 {
   get
   {
      return firstname + " " + lastname
   }
 }
}

and then you bind the display text of the combo to that readonly property.

Regards

Henrik

[Gerrit du Preez]

Hi Henrik

Thanks for your reply.

I tried it and added it as follows to my User class

       public string Fullname
        {
            get { return firstname + ' ' + lastname; }

        }

I now get this error:

Identifier 'Fullname' is not a parameter or variable or field of 'OpenAccessData.User'. If 'Fullname' is a property please add the FieldAlias attribute to it.

I tried adding a FieldAlias attribute, but then it returns only the value of the field specified in the FieldAlias and not a concatenated value of the two fields.

Any advise?

Thanks

Gerrit

[IT-Als]

Hi Gerrit,

I really can't think of any issues here.. Maybe you can post some more code: the query (in the aspx page I suppose) the collects the information, the binding and the class definition..and I'll take a look..

Regards

Henrik