inserting two textbox values into one column in sql

Question

please help me i hat two columns in my database address and addresstype and i have two addresstype address should be inserted based on type with one textbox

Tapan Patel · Answer

Ok . So basically you are trying to insert let's say either permanent address or temporary address. You can use ternary operator in c# code. Sql column parameter variable = string .IsNullOrEmpty (textbox1.value)= true ? textbox2.text:textbox1.text Please mark it as an answer if it addresses the issue.

Rajeesh Menoth · Answer

Hi Concatenate the two text box value into one and saved into your column. Example : string commandText = INSERT into YourTableName() Values(@myAddress); ; SqlCommand command = new SqlCommand(commandText connection); command.Parameters.Add( @myAddress   SqlDbType.Text); command.Parameters[ @myAddress  ].Value = myText1.text + ' ' + myText2.text; Reference : http://stackoverflow.com/questions/21422690/how-to-add-two-textbox-valuesdata-to-a-single-column-into-data-basemy-sql