Hi all,
Can we concatenate a string value with the value from database?
For Eg: I have to get the names from database and concatenate with a textbox
value and store it in database again in different table.
What i have tried to do is:
Dim strSql As String = " Insert into
Mess(UserName,Number,Title,Lan,Txt,Status) Select '" & strUserName & "',*
NNub*,'" & strTitle & "','" & strLan & "',*Name* '" & strMessage.Replace("
'", "''") & "','" & StrStatus & "' From Group Where GroupName='" &
dllgroup.SelectedItem.Text & "' and UserName='" & strUserName & "'"
Here im taking the NNub from the database directly.What i need is i have to
concatenate Name & strMessage.
So that it will save in database; if strmessage is "HI"
Tom HI
Jerry HI
Like this.
Is it possible. Because i tried my level best, pls help me if anyone can
advise on this...
--
****************
Thanks & Regards,
Jeena Ajiesh
