Author: Spider8990 | Posted on: 1/17/2009 12:29:51 AM | Views : 280

Good Day
Can anyone please give me advise on what i need to do to make this work please.
I have values in a listbox that must all go into one single datafield
I'm using a Sqldatasource control to insert this into the database
but somewhere my code is wrong, could you please have a look...
1)the datafield is marked Keywords  where the listbox values must go in:

 
<asp:sqldatasource ID="InsertBusinessREGDataSource" runat="server"

connectionstring="<%$ ConnectionStrings:ASPNETDBConnectionString %>"
       
InsertCommand="INSERT INTO [TempSignUPOrder] ([OrderNumber],
[SubscriptionPackage], [SubscriptionPrice], [TransactionDate],
[FirstName], [LastName], [CellularPhoneNumber], [CompanyName],
[PhysicalAddress], [PostalZipCode], [CountryID], [CityID],
[PhoneNumber], [FaxNumber], [E ...

Go to the complete details ...