hi
I have dropdownlist and textbox and button in page that when click button it will save data into database I wrote procedure that save dropdownlist and textbox text in one column below are codes:
ALTER procedure [dbo].[Documentry_InsertInfo]
@Topic nvarchar(100),
@Name nvarchar(100)
AS
BEGIN
INSERT INTO Documentry_Info
(Name,Topic)
VALUES
(@Name,@Name+'-'+@Topic)
END
here @Name is textbox's text and @Topic is dropdownlist selectedItem text now probelm is when I enter text in textbox like ("Neda") and select Item from Dropdownlist ("Iran") I expect that it saves data in database like:
Neda-Iran
but it save data like:
Neda- Iran
I mean it put space between - and Dropdownlist selectedItem how I can delete this space?
Best Regards
Neda