Adding an Expression to the DataSet Schema

When you need information from a database in a format other than it is stored, you can create an expression to gather that information expressed in a new way. You do this through the DataSet Schema.

From the Solution Explorer, select the .xsd file. You should see a list of fields and their types. Scroll down to the last line of the table and click in the first column. Select E element from the list. Then type in your expression such as lastname + ', ' + firstname. Make sure you rebuild your solution. That field should now be available to use in databindings so you can display it on a form.