Multiline Textbox Using Query......

[rajeshidea]

Hi All,

How to save multiline Textbox Using SQL Query .am saving using following SQL

<Code> = <\code>
SQL = " insert into Sitemaster (Srno,Site_name,Site_id,Bsc_id,Site_stru,Hub,Site_city,Dist_hq,Site_add )" & " values (" & txtsrno & ","
SQL = SQL & "'" & txtsitename.Text & "','" & txtsiteid.Text & "','" & txtbscid.Text & "','" & txtsitestru.Text & "',"
SQL = SQL & "'" & txthub.Text & "','" & txtsitecity.Text & "','" & txthq.Text & "','" & txtsiteadd.Text & "')"

Txtsiteadd will multiline textbox
but its saving only First line
while other lines are not saving

Appericiated Help

Thanks