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

inserting two textbox values into one column in sql

Answers (2)