UPDATE a DropDownList box~ HElp Please

7 Mar 2007 8:41 PM

Brad Isaacs

Using ASP.NET 2.0 with SQL Server 2000

Inside my dropdown list box I am using an SQL DataSource

SELECT RTRIM(c.Name_First) + ' ' + RTRIM(c.Name_Last) AS Contact,
                            c.phone As PriPortPhone
FROM mppaContacts c

Now I am trying to UPDATE the table name mppaContacts with what the user
selects from the drop down list box.

How do I UPDATE the table when the names are concatenated?    I need to
select a substring for the Name_First field then for the Name_Last field.

UPDATE mppaContacts
SET
       [Name_First] = @FirstName
       [Name_last] = @LastName
       [phone]       = @phone

Any ideas would be greatly appreciated........not sure how to extract the
individual names and place them into their specific fields.

Thanks in advance

~Brad

------------------------------
Brad Isaacs

12 Mar 2007 4:38 PM

salonen

Show quote

On Mar 7, 3:41 pm, "Brad Isaacs" <bisa***@rogers.com> wrote:
> Using ASP.NET 2.0 with SQL Server 2000
>
> Inside my dropdown list box I am using an SQL DataSource
>
> SELECT RTRIM(c.Name_First) + ' ' + RTRIM(c.Name_Last) AS Contact,
>                             c.phone As PriPortPhone
> FROM mppaContacts c
>
> Now I am trying to UPDATE the table name mppaContacts with what the user
> selects from the drop down list box.
>
> How do I UPDATE the table when the names are concatenated?    I need to
> select a substring for the Name_First field then for the Name_Last field.
>
> UPDATE mppaContacts
> SET
>        [Name_First] = @FirstName
>        [Name_last] = @LastName
>        [phone]       = @phone
>
> Any ideas would be greatly appreciated........not sure how to extract the
> individual names and place them into their specific fields.
>
> Thanks in advance
>
> ~Brad
>
> ------------------------------
> Brad Isaacs

Have you tried this?

UPDATE mppaContacts
SET
        [Name_First] = @FirstName
        [Name_last] = @LastName
        [phone]       = @phone
WHERE rtrim([Name_First]) + ' ' + rtrim([Name_last]) =
rtrim(@FirstName) + ' ' + rtrim(@LastName)

It's not going to be terribly efficient but since you aren't using an
obvious key value to retrieve the data and you could update multiple
rows if the first name/last name combination isn't a key.

I would recommend returning a ContactID in your original query and
using that as your ValueMember on the combo box instead of the First
Name/Last Name combination(?).

Austin