Re: Concatenating Multiple Values for DataValueField
From: Marina (someone_at_nospam.com)
Date: 12/03/04
- Next message: Marina: "Re: dropdownlist: 2 columns in the DataTextField"
- Previous message: Scott Mitchell [MVP]: "Re: Select columns from dataset"
- In reply to: ae: "Re: Concatenating Multiple Values for DataValueField"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 3 Dec 2004 12:15:17 -0500
What would an update mean? Which field would you be updating in any type of
scenario? No matter you accomplish this, obviously you would always have to
manually build the sql yourself, or have each column selected separately as
well, and update it appropriately.
"ae" <ae@discussions.microsoft.com> wrote in message
news:609330D5-504F-46DD-AB7D-74D8A02D12E0@microsoft.com...
> Works good, but to do updates what's your recommendation? Thanks.
>
> "RF" wrote:
>
> > Thanks much
> >
> > P.S. Oracle's concat operator is || instead of +.
> >
> > "Marina" wrote:
> >
> > > Select Col1 + '-' + Col2 as MyDataValueCol FROM MyTable
> > >
> > >
> > > "RF" <RF@discussions.microsoft.com> wrote in message
> > > news:B638C3FB-2383-45AE-8AB5-3DCB97F13840@microsoft.com...
> > > > Thanks Marina, could you give me quick SQL example? Thanks.
> > > >
> > > > "Marina" wrote:
> > > >
> > > > > You can't do that. Do it in your SQL instead, so it is one column
when
> > > it
> > > > > comes in. Or, if you are using a datatable as the source, create
an
> > > > > appropriate expression column, and use that as the data value
field.
> > > > >
> > > > > "RF" <RF@discussions.microsoft.com> wrote in message
> > > > > news:3EFEF11A-A124-4FDF-87A9-5E022DE6F1D8@microsoft.com...
> > > > > > How can I do something like this
> > > > > >
> > > > > > AuthorList.DataValueField = "au_lname" &"-"& "au_id"
> > > > > >
> > > > > > I want to concatenate two columns together. Any ideas??
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
- Next message: Marina: "Re: dropdownlist: 2 columns in the DataTextField"
- Previous message: Scott Mitchell [MVP]: "Re: Select columns from dataset"
- In reply to: ae: "Re: Concatenating Multiple Values for DataValueField"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
