inserting two textbox values into one column in sql

prabha haran

10y1.1k.NET

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tapan Patel10y ago
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.
0
Rajeesh Menoth10y ago
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
0