If you want to add values from multiple textboxes into single column then you just concatenate the string...below is the example, you add the values you actually need.
Note the use of String.Format which enables you easy reading of the query without having to worry about closing all the quotes and easier copying into the database for testing. Note also that proper casing makes the thing more readable. Also, use full text instead of shortcuts like "brgy", you'll thank yourself in a year when you return and have no idea what that means :)
The answer to your question is bold, the rest is free education.
Query = String.Format("INSERT INTO tblRightOfWayAgreement (Name, PS, PS1, brgy, mun, nameTO, TOnum, dateoffack)
VALUES ('{0}', '
{1}', '{2}', '{3}', '{4}', txtName.Text,
cmbps.Text + " some other value",
txtPS.Text,
txtBrgy.Text,
txtMun.Text,
txtTO.Text,
txtPiece.Text,
txtAck.Text
)
Now that the solution is done:
I STRONGLY SUGGEST you use stored procedure or at least do something to prevent
SQL Injection[
^]
Consider what would happen if I entered the following in txtName
'; GO; DROP TABLE tblRightOfWayAgreement; --
NEVER TRUST USER INPUT!!
If this helps please take time to accept the solution.
Submit an article or tip